…commands such as SHOW TABLE_STATISTICS, SHOW INDEX_STATISTICS and SHOW USER_STATISTICS. The first two can…uncommon someone uploads a really badly designed application, which runs queries not using indexes or… to mention: per-user CPU time usage, some queries may be CPU bound rather than reading lots…
Post: SystemTap - DTrace for Linux ?
September 14, 2009 By 17 Comments
…CPU-bound load (for CPU-bound there is OProfile, see for example http://mysqlinsights.blogspot.com/2009/08/oprofile-for-io-bound… war story going on. To profile userspace application with SystemTap your kernel should be …and script (measure time, count of call, statistics) what you what. I did not …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… similar solutions. And besides, most applications have a lot of the same …: processor : 7 vendor_id : GenuineIntel cpu family : 6 model : 15 model name …queries in odd statuses, like “statistics“, I know something weird is …) in isolation, because they are tightly bound together, and tweaking one will…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… as well as inevitable application specific scalability restrictions, such as…Statistics *************************** 1. row *************************** USER:user TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS: 0 CONNECTED_TIME: 800 BUSY_TIME: 775 CPU…which amounts to pretty IO bound load for me. But …
Comment: Performance Schema overhead
April 26, 2011 By 20 Comments
… we’re IO bound. Many applications have spare CPU and they just would not like their performance to drop for IO bound workload due… Schema in “row access counters only” mode compares to user_statistics patch in its overhead ?
Comment: Performance Schema overhead
April 25, 2011 By 20 Comments
… we’re IO bound. Many applications have spare CPU and they just would not like their performance to drop for IO bound workload due… Schema in “row access counters only” mode compares to user_statistics patch in its overhead ?
