…_file_size = 64M (without the “B” in “MB” string) This works on my site on a Debian Squeeze system where I… sure that innodb_buffer_pool_size is for performance reasons set to x4 of log file size. On my system I… a dynamic innodb log file RECREATE did NOT seem to work if you are going to delete the log files later…
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… script with multiple level of concurrency and find out doing work from 32 processes is faster than just having one process…
Comment: ext4 vs xfs on SSD
May 3, 2012 By 23 Comments
… XFS on the hardware we bought. I found that ext4 worked really well out of the box, while XFS required poorly… all our MySQL DBs with ext4, and it’s been working great for the past 7 months. I recently had an…, to my great surprise, changing the number of allocation groups, setting the correct sunit/swidth for the RAID array, or using…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
I have been working for a customer benchmarking insert performance on Amazon EC2, and … that we can see the impact of growth in data-set on the insert rate. We can see that adding the…
Post: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 23, 2012 By 20 Comments
…LOCK does not work as optimally as you could think it works. Even …| show processlist | 0 | 0 | 1 | +——-+——+———–+———-+————+——+——————————+——————————+———–+—————+———–+ 5 rows in set (0.00 sec) As result …
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
… temporary table to original name. How does data visibility works in this case ? DDLs are not transactional and as…UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… a new join algorithm Hash Join. This join algorithm only works with equi-joins. Now let me briefly explain how hash…. This step is known as probe step. This join algorithm works best for highly selective queries, and obviously when the first… benchmarking in-memory workload, the InnoDB buffer pool size is set to 6G and the buffer pool was warmed up, so…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… benchmarking in-memory workload, the InnoDB buffer pool size is set to 6G and the buffer pool was warmed up, so… benchmarking IO bound workload, the InnoDB buffer pool size is set to 1G and the buffer pool was not warmed up… the performance of secondary key lookups as well. But this works only with joins and specifically with Block Access Join Algorithms…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… uses MySQL to identify potential causes. Is it working with large blobs ? Using user variables ? Prepared Statements ?… | sum(data_length+index_length) | +——————————-+ | 126984 | +——————————-+ 1 row in set (0.98 sec) This however will not cover…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 10 Comments
… Server in the following meaning: Data compatibility. Percona XtraDB Cluster works with databases created in MySQL / Percona Server Application compatibility. There… to start work with Percona XtraDB Cluster Percona XtraDB Cluster is based on Percona Server with XtraDB and includes Write Set REPlication…
