… see worse performance caused by slow query turned on, especially for very large (but not necessarily slow) queries. It’s a good tool but it should only be used when needed, and that’s why it’s turned off by…
Comment: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… Percona server or can I use mysql data directory? 2. What‘s the advantage of using Percona server over MySQL? 3. I…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
… include all the bug fixes in it. All of Percona’s software is open-source and free, all the details of…-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password guessing attack on other accounts efficiently. This… log system mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Missing path separator…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… disk. Now during those 300 second, other ‘innocuous’ queries which perform small insert or updates into completely different table (unrelated to…_immediate’ keeps increasing I have disabled the query cache by set global query_cache_size = 0; All this on a fairly decent…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… represented by both HTML links and entity-relationship diagrams. It’s also designed to help resolve the obtuse errors that a… forget to automate SchemaSpy via crontab once you’re done. What are some ERD tools you use and how do they…
Comment: ZFS on Linux and MySQL
June 4, 2013 By 17 Comments
… double caching by the file system vs the InnoDB caching. However, limited ARC size also limits ZFS file system’s internal metadata caching(which l2arc and deduplication both need plenty of) You need to sacrifice a little ram for ZFS metadata caching…
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… in the Percona Server 5.6 series. All of Percona’s software is open-source and free, all the details of… instead of using InnoDB heap allocation. This may improve write performance for high levels of concurrency. Bug fixed #1185686. Under very… log system mutex for the log reads needlessly, potentially limiting performance on write-intensive workloads. Bug fixed #1171699. Incorrect schema definition…
Post: Replication in MySQL 5.6: GTIDs benefits and limitations - Part 2
May 30, 2013 By 6 Comments
… to s2. This scenario can happen when you want to perform a planned failover. With GTIDs, all the operations are straightforward…(*) | +———-+ | 0 | +———-+ Can we still use master_auto_position = 1? Let’s hope so, as it is one of the ideas of… able to recover data from the crashed master, but that’s another story). In this case, you will have to promote…
Comment: Is there a performance difference between JOIN and WHERE?
May 29, 2013 By 30 Comments
… code. If your boss is wildly deviating what he needs on a continual basis, he’s either incompetent, lazy, abusive, or just…
Comment: ZFS on Linux and MySQL
May 29, 2013 By 17 Comments
Nice article! Actually I ran into performance issues during testing ZFS on Linux, it’s true it was some months before so… implementation has not yet been optimized for performance. As the project matures we can expect performance to improve.” http://zfsonlinux.org/faq…
