…profile slowly growing overtime, indicating a possible memory bug. Whatever the reason, there is a simple but powerful way to profile MySQL…) (see here if this is not clear) Now, before you run mysqld under …_io_cache*, st_mysql_mutex*, Format_description_log_event const*) (in /usr/local/percona/mysql…
Post: Caching could be the last thing you want to do
July 24, 2010 By 14 Comments
… which were designed to be “optional” (but clearly they weren’t). I think with great …cache misses, which can make this problem even worse. Caching can reduce visibility – You look at the performance profile… to capture queries. Run them through MySQL‘s EXPLAIN command. Do your queries SELECT *, …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 9630066 | | Bytes_received… so it’s clear what I’m…change the performance profile and workload …
