May 26, 2012

Comment: How to track down the source of Aborted_connects

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

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: ext4 vs xfs on SSD

I’ve also had to benchmark ext4 vs XFS, on a RAID10 of spinning drives. Many DBAs like …, but I’m not sure how frequently they benchmark XFS vs ext4, and how much of their recommendation comes from the…

Comment: How to change innodb_log_file_size safely

…] /usr/libexec/mysqld: ready for connections. Version: ’5.0.95′ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution Also…

Post: Percona welcomes Drizzle 7.1

… tables, the Drizzle protocol plugin, authentication from a file, MySQL UNIX socket protocol, javascript plugin, authentication via tables (similar to MySQL), RabbitMQ…

Post: ext4 vs xfs on SSD

… see running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually amount of threads does not affect the result…

Comment: Finding out largest tables on MySQL Server

… 58G 2012-04-24 13:41 tablename.ibd On disk vs the information_schema query, there is around 9GB discrepancy. Does…

Comment: Percona white paper: Forecasting MySQL Scalability

…/mysql-white-paper/mysql-performance-analysis-with-percona-toolkit-and-tcp-ip-network-traffic/ This covers the first half of my…

Comment: Percona white paper: Forecasting MySQL Scalability

… gave one session on – Extracting Scalability and Performance Metrics from TCP Traffic in Surge Conference 2011. Is there any place where…

Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5

…, and the only difference in query time is 48.78s vs 48.91s, so I don’t see Hash Join and… the amount of data is read from disk 2.2G vs 5G. However, there is one number in MariaDB 5.5…