….) First, we set long_query_time to 0 in order to log every query. (See part two for handling massive slow log volume.) The slow… is necessary when running a large stream of queries. Benchmarks We benchmarked with slow query logs captured from our production systems. We restored… write. The slow logs were split into chunks, each containing roughly 1M queries. We warmed the cold database with the first chunk and…
Post: Percona Toolkit for MySQL Webinar Followup Questions
April 5, 2013 By 1 Comment
… you run pt-query-digest on an output of the slow log on a Windows machine? A: Yes, pt-query-digest should work… of the supported platforms. You’ll have to install ActivePerl first. Q: Are these MySQL tools able to be run against…’t be able to have access to the slow query log file, so pt-query-digest is often used with the –processlist option…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… now (slow, general, binary, and tcpdump), so you shouldn’t have a problem finding queries to run and compare. pt-query-digest is simpler pt-query-digest 2.2 has fewer…-read tools’ documentation to see what has changed. As the first release in a new series, 2.2 features are not…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had… confused me first is the order query come in the log file. If you used to do tail -100 log-slow.log and… to aggregate log entirely in SQL finding most frequent slow query types or queries which load server the most. The other handly feature…
Comment: Multi Column indexes vs Index Merge
March 12, 2010 By 31 Comments
…), lastname(2)); The requirement is for wildcard searching on the first character on the firstname and lastname. select firstname, lastname from… query it takes more than a minute to finished the query. All subsequent query is a snap. So the problem is on the first query… am getting “504 Gateway Time-out” error because of this slow first query. Any thoughts about myqsl warm up? and how to improve…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
… really slow queries but to really optimize application throughput queries which generate most of the load need to be investigated Patching Slow Query Logging – First thing… same slow query log first to fix worse queries and then come to find more optimization candidates. So “tail -f mysql-slow.log | mysql_slow_log…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… pt-query-digest Using pt-query-digest is pretty straight forward: pt-query-digest /path/to/slow-query.log Note that executing pt-query-digest can… with analysis of the query that is taking up the longest sum of run time, query ranked #1. The first row in the table above shows the Count of number of times this query was executed…
Post: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
… MySQL slow query logs using pt-query-digest you can store samples of each query into query_review table and…first seen date; * custom reports, choosing which columns to show; * filtering queries by hosts; * filtering reports by different query conditions; * graphing reports; * explaining queries…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… than data and the IO is slow (when the FS cache is cold, IO to slow IO subsystem happens) Repeated runs test…” of queries represents a set of drill-down queries to find an anomaly. I am going to focus on the first query, which uses only one join. Since it is practical for a query with only one join…
Post: A (prototype) lower impact slow query log
September 20, 2012 By 12 Comments
… open(2)ed with O_APPEND, the file offset is first set to the end of the file before writing. The…-of-queries=1000000 –concurrency=64″ on my laptop) come out at the following: straight MySQL (no slow query log): 13 seconds MySQL with slow query log enabled: 18 seconds My audit plugin slow query log: 15 seconds straight Drizzle (no slow query log…
