… 111229 3:11:26 # User@Host: msandbox[msandbox] @ localhost [] …statistics available after the query is actually executed, while no such statistics… # 1ms ################################################################ # 10ms # # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `wp…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
Comment: About This Blog
October 7, 2008 By 48 Comments
… total queries from all users@client host machines where more than 10,000 queries were issued: sql> SHOW STATISTICS Com_select, Questions, Com_update FROM conuser WHERE Questions > 10000; +—————————-+————-+———–+————+ | conuser (user@host) | Com_select | Questions…
Post: Implications of Metadata Locking Changes in MySQL 5.5
February 1, 2013 By 9 Comments
…text’; session3 > show processlist; +—-+———-+———–+——+———+——+———————————+————————————————————-+ | Id | User | Host |…init | 0.000014 | | optimizing | 0.000002 | | statistics | 0.000005 | | preparing | 0.000006 |…
Post: Checking for a live database connection considered harmful
May 5, 2010 By 38 Comments
… the ‘ping’ or ‘statistics‘ command at the MySQL protocol level, which will increment Com_admin_commands in SHOW GLOBAL STATUS, or a… # ==== ================== ================ ====== ======== =============== # 1 0x5E796D5A4A7D1CA9 10651.0708 73.1% 120487 0.0884 ADMIN STATISTICS # 2 0x85FFF5AA78E5FF6A 1090.0772 7.5% 23621 0.0461 BEGIN… # 6 0xA873BBC4583C4C85 278.4533 1.9% 6985 0.0399 SELECT users user_devices That’s right, 73% of the server’s load…
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
… – Reimplemented read-write locks Diagnostic patches. – We provide much more statistics in slow.log, i.e. execution plan, InnoDB timing, profiling… storproc() With userstat you can get additional THREADS_STATISTICS which show similar information to USER/CLIENT_STATISTICS but per THREAD granularity (it’s useful…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…have a 3 node cluster. mysql> show global status like ‘wsrep_cluster_size’; +——————–+——-+ | Variable_name | …with the least connections established. The statistics page is accessible on the … set it up, create the clustercheck user. mysql> grant process on *.* to ‘clustercheckuser’@'…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…do read-write splitting without breaking the user experience, how to take online non-…_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value |… of queries in odd statuses, like “statistics“, I know something weird is going …
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
… the system, but also there were over a hundred user queries in SHOW PROCESSLIST that were stuck in the ‘Opening Tables’ state… for each table, it calls dict_update_statistics and appears to force table statistics to be regenerated for each table It’s…, the io-wait spike is explained by table statistics being regenerated, and the SHOW PROCESSLIST connections stuck in ‘Opening Tables’ were waiting…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… are the InnoDB usage statistics. MySQL currently allows you to see many per-session statistics for operations with SHOW SESSION STATUS, but that… instead the above statistics. The full slow log entry for a query using InnoDB can look like this: # User@Host: macko[macko... if InnoDB was not used: # Time: 071031 20:03:16 # User@Host: macko[macko] @ localhost [] # Thread_id: 12 # Query_time: 0…
Post: Percona-XtraDB-9.1: released and new coming features
March 17, 2010 By 14 Comments
… waited features from 5.0: extended slow.log USER/TABLE/INDEX/CLIENT_STATISTICS + THREAD_STATISTICS ( coming in release-10) Extended slow.log is… tables Import / export of buffer_pool Transactional replication Show internal InnoDB data dictionary Show InnoDB locking/io profiling in slow.log I…
