… 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 84 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: Analyzing Slow Query Table in MySQL 5.6
February 18, 2013 By 1 Comment
… a report on the query log in spite of this. You could still get a report of the most frequent queries, even if the response time is so imprecise. But pt-query-digest and similar tools don’t read the query log… want to learn more about best practices for manipulating query logs and running reports on them? Register to join me February 25…
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: Write contentions on the query cache
September 5, 2012 By 5 Comments
… response time of their top slow query according to pt-query-digest’s report. This query was run very frequently and had very unstable performance… fields were correctly indexed. With SHOW PROFILE, I saw that most of the time was spent sending the result set to… performance for other queries. The best solution was simply to turn off the query cache. Conclusions: Once again, the query cache revealed bad…
