One of the very frequent cases with performance problems with MySQL is what they happen every so often or certain times. … need to know it is not MySQL problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing… too much in this case throttling by having relatively short queries and introducing “sleeps” between them can be a good idea…
Post: MySQL Slow query log in the table
May 31, 2007 By Leave a Comment
… in MySQL is well though of in regards to avoiding trouble. For example you can’t ALTER log table while query is running…” query by removing comments and replacing constants with some placeholders as this would allow to aggregate log entirely in SQL finding most frequent slow query types or queries which load server the most. The other handly feature would be…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…queries themselves. If the client has long-running queries, it can be pretty easy to catch. Maybe they’re long-running…most expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL… solutions, all of which we can frequently help customers set up much more…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… problems. MySQL Restart MySQL Restarts may include recovery time but what is the most important…are being replicated) are frequent cause of concern. Remember replication runs as a single thread… which queries mysql. I’ve seen monitoring updates which would add excessively expensive and frequent query…
Post: Is it query which needs to be optimized ?
March 6, 2007 By 9 Comments
…MySQL Performance Forum as well as from our customers regarding query optimization… which had one thing in common – It is not query… it is best to make sure your most frequent queries do not need GROUP BY. It can…approach is to throw away count and run main query with LIMIT 1000 or so, cache results…
Post: What would make MySQL Multiple Queries Usable ?
September 5, 2007 By 1 Comment
… in most cases. What would make MySQL Multiple Queries API more usable ? Allow to run queries in parallel – The great benefit of knowning all queries at once is of course you can run… we have is with ClickAider For reporting needs we quite frequently need to have total number of records within the period…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
…timeouts, covered in another plugin) are frequent causes of serious errors in…mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running… and responds to a query. The pmp-check-mysql-status is also… already cover some of the most common and severe conditions that…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
…Connections Ajax applications with frequent case of one query per request … simple applications which may run query several times per page. …most optimal way to cache things but it would be very easy for many applications. Query…queries I would like to be able to run multiple queries for multiple MySQL…
Post: MySQL caching methods and tips
April 4, 2011 By 4 Comments
… of the most common cache methods for MySQL. Popular cache methods The MySQL query cache When the query cache is enabled, MySQL examines each query to see… keys which are not accessed very frequently. Use what you need Both Memcached and the MySQL query cache are limited in size. If… least expensive queries are the ones you never run, then the most expensive queries very well may be the ones you have to run when…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…MySQL 5 number of Innodb performance counters were exported and now available in SHOW STATUS output. Most… array – how frequently slots are allocated in it and how frequently threads are signaled …. Normal reads originated from query executions are executed by threads running queries. On Unix/Linux …
