…, which gives you a USER_STATISTICS table. mysql> SELECT * FROM INFORMATION_SCHEMA.USER_STATISTICS WHERE USER=’#mysql_system#’\G *************************** 1. row *************************** USER: #mysql_system# TOTAL_CONNECTIONS…
Post: Announcing Percona Server 5.5.24-26.0
June 1, 2012 By 9 Comments
…, TOTAL_CONNECTIONS_SSL, has been added in the CLIENT_STATISTICS, THREAD_STATISTICS and USER_STATISTICS tables in the INFORMATION_SCHEMA database. Bugs Fixed: A… a compiler error. Bug fixed #997496 (Alexey Kopytov). Variable `thread_statistics` was a reserved word in Percona Server 5.5. As…
Post: Dropping unused indexes
January 15, 2009 By 6 Comments
…_NAME, s.INDEX_NAME FROM information_schema.statistics s LEFT JOIN information_schema.index_statistics iz ON (s.TABLE_SCHEMA = iz.TABLE…’ and (select rows_read+rows_changed from information_schema.table_statistics ts where ts.table_schema=s.table_schema and ts… first. Note this query requres MySQL with Percona Extensions and user statistics running.
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
… following query: mysql> select * from information_schema.user_statistics where user=”#mysql_system#” \G *************************** 1. row *************************** USER: #mysql_system# TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS… from replication thread: mk-query-digest slow-log –filter ‘($event->{user} || “”) =~ m/[SLAVE_THREAD]/’ > /tmp/report-slave.txt In the report…
Comment: Percona-XtraDB-9.1: released and new coming features
March 23, 2010 By 14 Comments
… not get to work is the INDEX_STATISTICS table and the TABLE_STATISTICS one, the USER_STATISTICS is running fine after setting the userstat…
Comment: Percona builds with Percona patchsets
July 18, 2008 By 35 Comments
Mark, Yes, it contains SHOW USER_STATISTICS / INDEX_STATISTICS / TABLE_STATISTICS. We are going to make this info available via INFORMATION_SCHEMA.
Post: Percona builds with Percona patchsets
July 16, 2008 By 35 Comments
… log) InnoDB statistic (show extended InnoDB usage during query execution in slow log) Google’s patches with user statistics, and statistics about tables and…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… running Percona Server you can get the value from User Statistics *************************** 1. row *************************** USER:user TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS: 0 CONNECTED_TIME: 800… (1/0%), 3BBF3B5A (1/0%)… 1753695 more # Last errno 0 # Users user # Query_time distribution # 1us # 10us # # 100us ################################################################ # 1ms ############# # 10ms ###### # 100ms # # 1s…
Comment: MySQL for Hosting Providers - how do they manage ?
November 29, 2008 By 15 Comments
… much). When you can aggregate them to see if particular users are guilty. This is often done together with watching loadavg… if your goal to help users to reduce the load rather to punish them. 3) Google User Statistics found in Percona Extensions are very good way to monitor the load on per user and per table…
Post: How to generate per-database traffic statistics using mk-query-digest
September 16, 2009 By Leave a Comment
… get overloaded. But MySQL doesn’t allow us to examine statistics on a per-database basis. Enter Maatkit. There is an…. This can be used to aggregate information by tables, hosts, users, or databases (full documentation is available via perldoc). %> perl mk…
