… (parent_id=0 is special value which matches significant amount of … to be used to largest extent possible: mysql> explain SELECT thread_id FROM …MySQL could look at the stats and adjust them appropriately – the plan for second…MySQL selecting (A) index instead of (A,B) or even worse it can can select…
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
… slow query time in seconds, having 1 second minimum value. For most of … candidates. So “tail -f mysql-slow.log | mysql_slow_log_filter -T 0….important to find queries which cause largest load on the server, which …seconds to complete ### Rows analyzed 1 – 1 SELECT id FROM forum WHERE id=XXX; SELECT…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… for new connections as in MySQL. This is very helpful …value of long_query_time=0, because if you set it to some other value say 0.1 seconds…shows the top queries with largest impact – longest sum of run … # EXPLAIN /*!50100 PARTITIONS*/ SELECT option_name, option_value FROM wp_options WHERE autoload …
