May 26, 2012

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: How to change innodb_log_file_size safely

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

Post: Benchmarking single-row insert performance on Amazon EC2

… ran 5 instances of iiBench simultaneously to simulate 5 concurrent connections writing to the table, with each instance of iiBench writing…

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.

Post: Announcement of Percona XtraDB Cluster 5.5.23

… list of IP addresses for a new node, it will connect to the first available Binaries are available from downloads area…

Post: Testing Fusion-io ioDrive2 Duo

… OS as two devices (1.2TB each), which can be connected together via software RAID. So I tested in two modes…

Comment: Load management Techniques for MySQL

… master (but having the batch job only use the slave connection). You only need to implement a generic Gearman Worker to…

Comment: New distribution of random generator for sysbench - Zipf

… get in Sysbench is to be able to handle broken connections gracefully and reconnect. Testing Percona XtraDB Cluster with HAProxy is…

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: What to tune in MySQL Server after installation

… in use: connect STACKTRACE: java.net.SocketException: java.net.BindException: Address already in use: connect at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java… com.mysql.jdbc.Connection.createNewIO(Connection.java:2641) at com.mysql.jdbc.Connection.(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266…