… run pt-query-digest on an output of the slow log on a Windows machine? A: Yes, pt-query-digest should work on Windows even…’t be able to have access to the slow query log file, so pt-query-digest is often used with the –processlist option. But as discussed during the webinar, you may miss some queries. Q: Can we get copies of the scripts used in…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
… Slow Query Log – Especially after the changes to log all queries slow query log may be growing too rapidly to follow, so we implemented slow query log filter… require you to keep the other window open and find query sample with real constants which matches query with placeholders to work with…
Post: How (not) to find unused indexes
October 16, 2009 By 2 Comments
… in consulting issues where customers have queries that use a BETWEEN on a date, but the window of time it is searching… not fixed in MySQL and can be a much wider window (15-60%) depending on the circumstances. In this case… that checks EXPLAIN information (like QUAN) or set your slow query log to zero microseconds (5.1 feature) and then find someway…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…(Alexey Kopytov). Uninitialized values in the Slow Query Log patch. Bug Fixed: #794774 (Oleg Tsarev). Querying global_temporary_tables caused the server … patch has been fixed on Solaris (supported platform) and Windows (experimental). Bug Fixed: #737947 (Laurynas Biveinis) Improvements and fixes …
Post: MySQL random freezes could be the query cache
March 19, 2009 By 23 Comments
… 5 minutes at a time, your chance of getting someone logged onto the machine to watch it in action are pretty… caused by scalability/concurrency/locking problems in the query cache. (One was on Windows, and we fixed it by guessing. The other… you’re having random lockups, you might try disabling the query cache, and see if that solves it. Hopefully this blog…
Comment: What’s a good buffer pool read/write ratio?
May 31, 2011 By 6 Comments
…’ll see spikes in the suspected time window and coupled with the slow query log and mk-query-digest, you have a good set…
Comment: Slow Query Log analyzes tools
February 20, 2009 By 84 Comments
Thanks for the slow query log parser tool, I have easily found the expensive queries and created index accordingly, nice and easy! I… the lock from WRITE to READ. In the lowest load window (2:00-4:00 am) [1] Lock the table READ…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… originated from query executions are executed by threads running queries. On Unix/Linux you will always see 4 helper threads, on Windows it… it is pretty much for informational purposes only. — LOG — Log sequence number 84 3000620880 Log flushed up to 84 3000611265 Last checkpoint at…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…still spotted in a wild, especially in Windows world. The restriction would normally apply to…have MySQL needs – these include MySQL buffers – query cache, key_buffer, mysql threads, temporary tables,…will need it, .frm file, binary logs, or relay logs, Innodb Transactional Logs also like to be cached…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…2048 long-query-time=5 log-slow-queries=/apps/log/slow-query interactive_timeout=300 wait_timeout=300 thread_cache = 40 max_connections=500 query_… on Windows # (via the “enable-named-pipe” option) will render mysqld useless! # #skip-networking # Replication Master Server (default) # binary logging …
