… (TCP/IP) 9900 MySQL Query Cache (Unix Socket) 13500 Selecting from table (TCP/IP) 5100 Selecting from table (Unix Socket) 7400 Note: The test measures peak performance… to MySQL Query Cache – It performs faster than Query Cache if TCP/IP socket is used, but if Unix Socket is used to connect to…
Comment: Impact of the number of idle connections in MySQL
December 18, 2010 By 21 Comments
… a debug-compiled server with safemalloc enabled. This totally kills performance, as it uses a really expensive memory sanity check that… lots of extra testing code that is very costly for performance, safemalloc is only one of them (but a particularly expensive… threadpool). The select() only has the two server listening sockets (tcp and unix socket), each idle connection has its own waiting call in its…
Post: Poor man's query logging
November 7, 2008 By 5 Comments
…-query-log), which was designed to store poorly performing queries that run at least 2 seconds. …works only when applications communicate with MySQL through TCP sockets. When localhost (not to be confused with … not work since all traffic goes through a unix socket file. It’s most definitely not a …
