… to waste time and lose performance because of this. I am one of those people. When MySQL 5.6 spends a lot…_and_free_block you are not going to have good performance results. Prior to 5.6 foreground threads were responsible for…. I think Oracle might be aware of some of these problems prior to my bug reports — but it is hard to…
Post: Diagnosing and fixing MySQL Performance Problems in Russian in Moscow, Russia
September 27, 2010 By Leave a Comment
… presentation on Diagnosing and Fixing MySQL Performance Problems . This even will be based on updated and expanded tutorial from MySQL Conference & Expo which was…
Post: Percona's Sessions at the O'Reilly MySQL Conference and Expo
April 7, 2011 By Leave a Comment
… MySQL Conference and Expo (#mysqlconf) yet. Here is a hopefully complete list. Diagnosing and Fixing MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL The Aspersa System…
Post: Friends of Percona Get 20% Off at the MySQL Conference!
February 24, 2011 By 5 Comments
…: Diagnosing and Fixing MySQL Performance Problems (Monday Tutorial) Percona Server: secret features MySQL and SSD: Usage Patterns Achieving PCI Compliance with MySQL The Aspersa System Administrator’s Toolkit Percona Server and XtraBackup: painless operations Forecasting MySQL Performance and Scalability Summary…
Post: Black-Box MySQL Performance Analysis with TCP Traffic
February 23, 2012 By 2 Comments
… system performance simply by looking at TCP packet headers, and when they arrive and depart from a system. This works for MySQL… a paper that shows some of my techniques for detecting problems in a system, which can be an easy way to…’s available from the white paper section of our website: MySQL Performance Analysis with Percona Toolkit and TCP/IP Network Traffic
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…, High Performance MySQL 2nd Edition (it’s not in the first edition). From this I get an idea where any possible problems might… at this point, it looks like MySQL is probably a good place to look for performance problems. Everything I’ve done up till… meaningless. On the other hand, pinging can be a serious performance problem. Not really for the server, since it’s a cheap…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
… good” change as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the most… more rows than before. Data growth is frequent cause of performance problems and slave lag among them. The relationship is also very…
Post: Battery Learning still problem many years after
February 10, 2011 By 7 Comments
The performance problems caused by battery auto learning go many years back. We wrote about it, other people from MySQL Community too. The… testing as part of complex IO subsystem performance testing – if you have RAID check what performance is going to be with failed… different servers at different times with team informed about slower performance than catching everyone by surprise (at least first time). Third…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
… space and how much data we can comfortably put in MySQL Instance without getting in too much trouble with backups etc… fit. For large number of applications optimizing IO performance will be number one problem do not get me wrong, I just it… performance. I also fully support Matt in his views of black boxes. If you want to be able to resolve your performance problems…
Post: Performance problem with Innodb and DROP TABLE
February 3, 2011 By 23 Comments
….1213 mysqld mysqld buf_LRU_invalidate_tablespace 168823 0.6009 mysql mysql completion_hash_update(hashtable*, char*, unsigned int, char*) 53667 0…” – there were problems of scanning large lists which were responsible for poor performance of SHOW STATUS and crash recovery performance over last couple… a lot of tables in a batch can cause serve performance problems. The stalls can take more than a second for very…
