…per manual will chose best value automatically. Making this change I could bring optimization, and full query execution time to less than 50ms. Low values, such as 3,4 provided a bit better performance… Timour Katchaounov in MySQL mailing list archives I… if we assume MySQL users do not join lots…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…ve spoken to a lot of users with monitoring systems over the …. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file …checks in that list, there are several others that can be performed with …Queries and alert on a queries-per-second threshold. (I don’t suggest doing this; I’m only listing…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…MySQL Query Cache so it once again is appealing to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL Query…query comes from or what application user triggered such query. Query…
Post: Database problems in MySQL/PHP Applications
August 11, 2006 By 12 Comments
… queries per page which will make performance improvement…MySQL. There are many successful applications, using tens of thousands of tables per host and archiving great performance…list of values derived by previous query. For example you can do: SELECT id FROM users WHERE featured=1; Now populate List…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
…MySQL usage Personally I would see a few more things implemented. A few examples to mention: per-user CPU time usage, some queries…MySQL performance counters broken down by users (full joins, table scans, disk temp tables, etc.) limiting command availability to SUPER users…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… some interesting information about how Shard-Query will perform on each database. To do… ip” field is selected in the list of columns to show (click …-file-format=barracuda innodb-file-per-table innodb-flush-log-at-…size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…Performance_schema_mutex_classes_lostblogpercona.commanual Performance_schema_mutex_instances_lostblogpercona.commanual Performance_schema_rwlock_classes_lostblogpercona.commanual Performance_schema_rwlock_instances_lostblogpercona.commanual Performance…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
…configure MySQL Server so it uses too small amount of memory it will likey perform …queries or users will decide to run. Unfortunately this is as much close to impossible to be impractical. Here is why: List… general storage engines may have their own per thread or global memory allocations which…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…listings…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…performance system is virtually every query.) If it’s not possible to use a patched binary, we can use MySQL…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
… lists or blogs you probably heard complains about MySQL being…users. On other hand it is well known with customers like Google, Yahoo, LiveJournal,Technocarati MySQL…could perform over 300.000 of random lookups per second… to several tables or perform complex queries finding relationships between …
