…-applications from VB6 to PhP/MySQL/Apache/InnoDB. Do you think you can show a program where row-locks are used by…
Comment: To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
April 26, 2012 By 53 Comments
Using SQL_CALC_FOUND_ROWS defiantly appears to be situational on the query (at least … for the count Data & FOUND_ROWS = .913 1) .90 for the data with SQL_CALC_FOUND_ROWS. No performance impact when using SQL_CALC_FOUND_ROWS 2) .013 for FOUND_ROWS() query
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… which has been developed by Tokutek. Though the “1 billion row insert challenge” for which this tool was originally built is… partitioning scheme such that every partition would hold 100 million rows. Table Structure The table structure of the table with no… INSERTs per second, with noticeable spikes after every 100 million rows inserted. I noticed that the insert rate drop was mainly…
Comment: Multi Column indexes vs Index Merge
May 10, 2012 By 30 Comments
… executed for the same SQL query with a …Using where | +—-+————-+————-+————-+————————————————————–+——————–+———+———————————-+——+————————————————–+ 4 rows…
Post: Percona Server 5.1.62-13.3 released!
April 26, 2012 By Leave a Comment
… and free, all the details of the release can be found in the 5.1.62-13.3 milestone at Launchpad… allows the changing names of the used databases in both Row-Based and Statement-Based replication. This was possible before by…
Post: Percona Server 5.5.22-25.2 released!
April 26, 2012 By Leave a Comment
… and free, all the details of the release can be found in the 5.5.22-25.2 milestone at Launchpad. Bugs Fixed: While running the test case found that MEMORY engine may return rows in non-deterministic order for equal keys. Bug…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… makes the insertions easy. Basically you fill in 100 million rows, then start a new partition and fill that in. During…, you didn’t graph the performance on the first 100M rows). The minimum performance troughs occur just as the partition switches… started, today the challenge would be to index 10B rows, not 1B rows. And it’s still a good challenge. The URL…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
… an output to a tmpfile, not for the content “Slave_SQL_Running: Yes” is used for to say that this server is a slave, but later the test of “Slave_SQL_Running: Yes” fails, because the server is not running as…
Post: Percona Server 5.5.23-25.3 released!
May 16, 2012 By 2 Comments
… and free, all the details of the release can be found in the 5.5.23-25.3 milestone at Launchpad…
Comment: How to track down the source of Aborted_connects
May 15, 2012 By 17 Comments
I’ve never found a way to snoop on data passing through a Unix socket.
