…a value of long_query_time=0, because if you set it to some other value say 0.1 seconds… queries and shows the top queries with largest impact – longest sum of run time which typically… CREATE TABLE `wp_blog_one `.`wp_options`\G # EXPLAIN /*!50100 PARTITIONS*/ SELECT option_name, option_value FROM wp_…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
Post: Slow Query Log analyzes tools
September 6, 2006 By 84 Comments
…slow query time in seconds, having 1 second minimum value. For most …table scans – for example if you would be having drop down list of states in your application and use SELECT * FROM…to find queries which cause largest load on the server, …to execute combined. There is a tool mysqldumpslow in MySQL …
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…a second. From these results I read the side load on the node TO which updates are being propagated causes largest…I’m getting following result: … Result Mismatch for Value 48; Retries: 1 Delay: 0.76 ms …in parallel and updates to the sbtest table and sbtest2 table can be done in parallel (even …
Post: Getting MySQL to use full key length
January 31, 2007 By 5 Comments
…: 1 select_type: SIMPLE table: msg132 type: … is special value which matches …largest extent possible: mysql> explain SELECT thread_id FROM…from cache). MySQL could look at the stats and adjust them appropriately – the plan for second query is accessing subset of rows from…start with prefix A and you …
