One of the very frequent cases with performance problems with MySQL is what they happen … problem, might be even not problem with your MySQL configuration, queries and hardware, even though fixing these does help in many… 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
… table to MyISAM, disable concurrent inserts and run long reporting query on the log file query execution is still proceeds. I have not…” 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…
Comment: Slow Query Log analyzes tools
November 8, 2006 By 83 Comments
… resently written the similar tool for regular query log to fetch the top of most popular queries. You can check it out at… an overview of the most frequently run queries, so you could speedup the the overall db performance by optimizing the most popular queries. In addition I…
Post: Is it query which needs to be optimized ?
March 6, 2007 By 9 Comments
… Schema Design standpoint it is best to make sure your most frequent queries do not need GROUP BY. It can be reachable by… ? Yet another approach is to throw away count and run main query with LIMIT 1000 or so, cache results for all pages… frequently I see dynamic query generation when some query variants fall back to use filesort, and it does not take many of such queries…
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 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…index structures, and the queries that run against them, is by far the most important thing to… availability solutions, all of which we can frequently help customers set up much more …
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…sync array – how frequently slots are allocated in it and how frequently threads are signaled using… to find truly conflicting statements. For most simple cases information from SHOW INNODB …buffers. Normal reads originated from query executions are executed by threads running queries. On Unix/Linux …
Post: Caching techinques
August 8, 2006 By 11 Comments
… frequent. Until Full Text itself could be optimized we added cache update algorithm which would populate cache with result set for most frequent and complicated queries as new data is loaded and index is rebuilt… how it can work in practice. Lets say you’re running big blogging site which has many blogs published. You may…
Post: Wishes for new "Pure PHP" MySQL driver
October 28, 2006 By 17 Comments
…them. Persistent Connections Ajax applications with frequent case of one query per request make persistent connections…very helpful for simple applications which may run query several times per page. I however …most optimal way to cache things but it would be very easy for many applications. Query…
Post: Why do you need many apache children ?
February 5, 2007 By 15 Comments
…real life case makes me to write again 
Most Web applications we’re working with have single… squid in front nothing else. This architecture is frequently used even for medium size web sites which… down all these hundreds of connections may start running queries at the same time, which does not help…
