… true federation support. 4. Be Solid MySQL has very good stability track record, with exception of MySQL 5.0 it was typically safe to… on MySQL because subqueries optimizer weakness. I’m saying about XA which were released in MySQL 5.0 without consistent work with MySQL close Partner – Innobase to ensure Group Commit still works in 5.0 and…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…. Clicks by day, by customer, top ads by clicks, top ads by click-through ratio, and so … You can have the clicks column record the total, and the blue_clicks column record only blue clicks; to …save that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, doing …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…paste everything I see into it. If there’s no record later that someone else can follow, I am not … also elect to use in some cases): vmstat 5 5 iostat -dx 5 5 If you don’t know how to read …the top 10 most expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL …
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
…) Records: 300024 Duplicates: 0 Warnings: 0 mysql> update employees set age = ((YEAR(CURDATE())-YEAR(birth_date)) – (RIGHT(CURDATE(),5)
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
…fail over in both directions. Aside from MySQL Cluster, which is more special-purpose, …three sets of stats to find the top tables on the active server and … passive + SELECT passive site.benefits 8.30 5.73 1.32 . 3.13 0….in a production steady-state. The buffered records are forced to be merged by the…
Post: MySQL Slow query log in the table
May 31, 2007 By Leave a Comment
… MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you …100 you would find new queries coming to the top of the list rather than in the end. If…consuming. This is actually where being able to sort records by physical position quickly without need to have indexes…
Post: Shard-Query adds parallelism to queries
November 15, 2010 By 16 Comments
… workloads. In fact, both Percona Server and MySQL 5.5.7rc have numerous performance improvements which benefit …on a range of records. This table is partitioned by month which means that MySQL can use partition …;text-indent:0px;padding-left:3px;border-top:1px solid #CCC;border-right:1px solid #…
Comment: Innodb vs MySQL index counts
November 30, 2011 By 6 Comments
… ## copy the .frm with 3 columns back on top > flush tables; Query OK, 0 rows affected (0… in the mysqld.err. (this was on vanilla MySQL 5.5) Let’s see if the ALTER TABLE trick works:…> alter table test ENGINE=Innodb; Query OK, 5 rows affected (0.01 sec) Records: 5 Duplicates: 0 Warnings: 0 > select *…
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 93 Comments
…web sites you will fine top tags, recently registered users etc …. Also note – number of records scanned to provide result … fast: mysql> explain select * from test order by k limit 5; +—-+————-+——-+——-+—————+——+———+——+———+——-+ | id | select_type …
