…slow | percona-playback –mysql-host 127.0.0.1 –mysql-username playback –mysql-password PaSSwOrd –mysql-schema schema_name –query… a large stream of queries. Benchmarks We benchmarked with slow query logs captured from our … did 39 measurements), the next graph shows chunk 4’s workload warmed up …
Post: Webinar: MySQL 5.6 Performance Schema
May 13, 2013 By 5 Comments
….m. Pacific, I’ll be leading a Webinar titled, “Using MySQL 5.6 Performance Schema to Troubleshoot Typical Workload Bottlenecks.” In… that have been added in MySQL 5.6, go over the configuration and spend most time showing how you can use the… excessive temporary tables and external sorts Excessive internal mutex contention Slow queries due to waits on InnoDB locks and Meta Data locks…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… you were using the vanilla MySQL server, you would see an entry like this in the slow query log: # Time: 111229 3:02… 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… output ranks the queries and shows the top queries with largest impact – longest sum of run time which typically (not always) shows queries causing highest…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…Slow_launch_threadsblogpercona.commanual slow_launch_timeblogpercona.commanual Slow_queriesblogpercona.commanual slow_query_logblogpercona.commanual slow_query…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…MySQL 5.5.3 Metadata Locking behavior prior to MySQL 5.5.3 Prior to MySQL…query end | 0.000002 | | closing tables | 0.000003 | | freeing items | 0.000007 | | logging slow query…
Post: Profiling MySQL stored routines
January 19, 2009 By 4 Comments
… was – I’ll just analyze queries in the slow query log generated by our mysql build running with long_query_time=0, get the slowest… “whatstheweatherlike”. Let’s call it and see what shows up in the slow query log: mysql> SELECT whatstheweatherlike(5); +———————————————————-+ | whatstheweatherlike(5) | +———————————————————-+ | Its 5°C…
Post: Write contentions on the query cache
September 5, 2012 By 5 Comments
… improve the response time of their top slow query according to pt-query-digest’s report. This query was run very frequently and had… know more about how MySQL executes this query. So I used commands you’re probably familiar with: EXPLAIN, SHOW PROFILE, SHOW STATUS LIKE ‘Handler….162272 | | end | 0.000008 | | query end | 0.000004 | | closing tables | 0.000032 | | freeing items | 0.000035 | | logging slow query | 0.000004 | | cleaning up…
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 in … (SELECT * FROM slow_log ORDER BY start_time DESC LIMIT 100) l ORDER BY start_time which shows last queries in the end… to aggregate log entirely in SQL finding most frequent slow query types or queries which load server the most. The other handly feature…
Post: Visualization tools for pt-query-digest tables
August 31, 2012 By 6 Comments
… process MySQL slow query logs using pt-query-digest you can store samples of each query into query_review table and historical … choosing which columns to show; * filtering queries by hosts; * filtering reports by different query conditions; * graphing reports; * explaining queries; * searching and …
Post: How to convert MySQL's SHOW PROFILES into a real profile
February 20, 2012 By 12 Comments
…sec) The query consumed 0.18 seconds. Where did the time go? mysql> SHOW PROFILE FOR QUERY 1; +———————-+———-+ | Status | Duration … | 0.000002 | 0.00 | 1 | 0.0000020000 | | logging slow query | 0.000001 | 0.00 | 1 | 0.0000010000 | …
