I’ve never found a way to snoop on data passing through a Unix socket.
Comment: How to track down the source of Aborted_connects
May 15, 2012 By 17 Comments
I know this is an old post, but I’m hoping it’s still monitored. Do you have any suggestions on how to accomplish something similar but with a socket rather than TCP?
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
…] /usr/libexec/mysqld: ready for connections. Version: ’5.0.95′ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution Also…
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
… PHP with MYSQL, these are MYSQL values: datadir=/data/mysql socket=/data/mysql/mysql.sock max_connections = 600 wait_timeout = 60…/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql.sock When I start the database service…
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
…, the Drizzle protocol plugin, authentication from a file, MySQL UNIX socket protocol, javascript plugin, authentication via tables (similar to MySQL), RabbitMQ…
Comment: Online MySQL Configuration Wizard from Percona
March 15, 2012 By 23 Comments
… slave). Then I don’t like the idea of putting socket and pid files in mysql data directory. My usual choice…
Post: MySQL Connection Timeouts
April 19, 2011 By 2 Comments
…: 38409 times the listen queue of a socket overflowed 38409 SYNs to LISTEN sockets dropped This means some SYN packets have to be dropped because kernel buffer of connection requests on LISTEN socket is overflow – MySQL is not accepting connections as quickly as… connections coming to LISTEN sockets. Once there is connection coming it it needs to create a new socket for incoming connection and…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
… 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… performs faster than Query Cache if TCP/IP socket is used, but if Unix Socket is used to connect to MySQL MySQL…
Comment: Rare evil MySQL Bug
November 20, 2009 By 7 Comments
…() and accept() calls in the trace are from handle_connections_sockets() in sql/mysqld.cc. It is supposed to select() on (at most) 2 file descriptors: the IP server socket and the unix server socket. Now in this case, one of these somehow… reason it works at all is probably that the server sockets are usually created early and hence get low file descriptors…
Comment: Percona Server now both SQL and NOSQL
December 20, 2010 By 19 Comments
… operations ( SQL Parsing, Query analyzer etc.. ), but while using handler socket to have massive concurrent writes thus bypassing all those operations… 16 core machine to process requests with the traditional mysql socket but slave process the binary log using HandlerSocket it might…, while the slave will read the HSbinlog straight into handler socket write socket 
. I am sure it’s not that easy, you…
