… subqueries) and we saw in my presentation that sometimes these perform worse and sometimes better than another equivalent solution. If you… solution for randomly choosing rows involves some compromise, either of performance, or of accuracy of randomness. The ORDER BY RAND() solution… are some more tips: Check out upcoming Percona Training classes in North America and Europe. Join Percona and the MySQL community at…
Post: MySQL 5.6.10 Optimizer Limitations: Index Condition Pushdown
March 14, 2013 By 2 Comments
…_column” query in MySQL 5.6.10. This turned into a really nice exercise for checking the performance and inner workings of one of the nicest features of the newer MySQL optimizer: the Index Condition….6), reducing the executing time by almost 5 times. Pro tip: make sure you always check the Handler status variables for…
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
… implementation, especially together with LIMIT is often the cause of MySQL Performance problems. Here is what you need to know about ORDER… we stick to simple MySQL using multiple indexes on most selective columns would be good idea for performance of such queries. For… will be just 5 in this case. Many of the tips I’ve mentioned here work for ORDER BY without LIMIT…
Post: Facebook at Percona Live MySQL Conference and Expo and Advanced Registration Ending Soon
March 19, 2013 By Leave a Comment
…MySQL experts: Domas Mituzas, Database Engineer Harrison Fisk, MySQL Performance Engineer Yoshinori Matsunobu, Database Engineer Their breakout session is entitled “MySQL…
Post: Is your server's performance about to degrade?
May 18, 2010 By 13 Comments
…it wasn’t load. It was probably crossing a tipping point in the data size, or something like that…able to see queries that have mostly very fast performance, and occasionally have much worse, and — here’s … it — and that’s where improvements to the MySQL source code are necessary. But in many cases …
Post: Common MySQL traps webinar questions followup
January 17, 2013 By 1 Comment
… constraints. Q: Are there any technical considerations or best practice tips to have a replicated slave in the cloud, for example… in the cloud, and it is common that you prefer performance over data safety for a slave. So you may want… and wanted to learn MySQL administration suggest any book or practices. Of course I’m biased but High Performance MySQL 3rd edition is…
Comment: Using delayed JOIN to optimize count(*) and LIMIT queries
April 25, 2007 By 22 Comments
[...] MySQL Performance Blog » Using delayed JOIN to optimize count(*) and LIMIT queries (tags: Tech Database MySQL Performance Tips) [...]
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…-check-mysql-innodb plugin checks for several indicators of severe internal problems within InnoDB, such as contention that crosses a tipping point… down for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in… in that list, there are several others that can be performed with existing plugins, so there was no need to write…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… binlogs off your primary server so you can perform point in time recovery. Store your binlogs … long term backups with little additional work Tips/Tricks: –add-header=x-amz-server-side-…, long term backups Decompressing Percona XtraBackup for MySQL in parallel using all your resources available …
Page: Presentations
May 3, 2006 By
… optimal MySQL performance giving some advice of selecting prover values for them. Download MySQL Performance CookBook MySQL Users Conference 2007, Santa Clara,CA, April 2007 Tips and Tricks on how you can speed up various things in MySQL…
