… case you may be able to connect to MySQL through Unix Socket or TCP/IP or neither. It also looks like there is a correlation…[0x408b60] So as you can see accept gets pretty high socket number – probably because of large innodb_open_files I tested… used during recovery. Note the process gets accept on the socket to fail with EAGAIN (which is not well described in…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… to all MySQL clients [client] #password = your_password port = 3306 socket = /tmp/mysql.sock #tmpdir =/mysql_tmp/ # Here follows entries for…_len=3 #skip-grant-tables # Don’t listen on a TCP/IP port at all. This can be a security enhancement… same host. # All interaction with mysqld must be made via Unix sockets or named pipes. # Note that using this option without enabling named…
Post: Cache Performance Comparison
August 9, 2006 By 74 Comments
… (TCP/IP) 12200 MySQL Query Cache (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 so I did not do much of error control or other precausions…
Post: Poor man's query logging
November 7, 2008 By 5 Comments
… the logging before starting the database instance or, even more work, by applying the patch …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 …
