One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. … you need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing… will suffer. So what you can do to prevent this problem from happening ? The answer is easy. Throttle the side load…
Post: Announcement of Percona XtraDB Cluster 5.5.23
May 14, 2012 By 11 Comments
… and improvements. List of changes: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated… Availability release. We did our best to eliminate bugs and problems during alpha and beta testing release, but this is a…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… this experiment isn’t really running the iiBench problem. The point of iiBench problem is to measure the cost of index maintenance… one of the indexes. If you keep going, making the problem be 10B rows, the cost of querying will go up… python version that Mark wrote http://bazaar.launchpad.net/~mdcallag/mysql-patch/mytools/annotate/head%3A/bench/ibench/iibench.py) is…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I… B+tree, having multiple buffer pool instances to reduce contention problems caused by buffer pool mutexes, using “estimate” checkpoint method to…
Comment: How to convert MySQL's SHOW PROFILES into a real profile
May 10, 2012 By 10 Comments
I wasn’t aware of that problem. Maybe there is a bug filed on bugs.mysql.com that will shed more light on workarounds.
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 3 Comments
… painful troubleshooting tasks with MySQL is troubleshooting memory usage. The problem usually starts like this – you have configured MySQL to use reasonable global… MySQL takes much more memory than you would expect, causing swapping or other problems. This simple problem on the surface becomes challenge with MySQL…
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 6 Comments
… EXPLAIN itself was taking same 5 seconds, which points to problem with optimizer performance. Note though if you have subqueries these… it unusable to check the optimizer performance. Solution for this problem was to use set optimizer_search_depth=0, rarely used… further I found the following explanation from Timour Katchaounov in MySQL mailing list archives I have some recollection that there were…
Post: Introducing the pmp-check-mysql-status Nagios Plugin
March 29, 2012 By Leave a Comment
… research to be frequent, severe, or subtle causes of problems in MySQL systems. They are intentionally not generic because I wanted to… I believe it should help avoid some of the common problems such as spammy alerts. There is one “generic, flexible” plugin… of status counters and variables. This is the pmp-check-mysql-status plugin, which can perform computations on status variables. By…
Post: Percona is Speaking At Open Source Data Center Conference in Nuremberg, Germany
April 19, 2012 By Leave a Comment
… hot backups with XtraBackup by Alexey Kopytov – Expert Troubleshooting: Resolving MySQL Problems Quickly by Kenny Gryp Feel free to come and say…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
… backup if you use this technique ? The problem comes from the fact how MySQL‘s Transactions work with DDL, In particular ALTER… pretty edge case scenario neither the less it can be problem for some workloads which run ALTER TABLE regularly during normal… potential cause for it. What are potential solutions for this problem ? you can use mysqldump –lock-all-tables instead which does…
