…Fixed the CVE-2012-5627 vulnerability, where an unprivileged MySQL account owner could perform brute-force password … definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to the maximum…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
…attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL version 5.6.11-60.3[/caption] Percona … schema definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to the maximum …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…-30.2 milestone at Launchpad. New Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing… was used. Bug fixed #1107539 (Sergei Glushchenko). Suboptimal code for User Statistics feature has been optimized to make sure no additional work…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing… was used. Bug fixed #1107539 (Sergei Glushchenko). Suboptimal code for User Statistics feature has been optimized to make sure no additional work…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication…and you keep track of global achievement statistics in a single table with a row… groups with some metadata: BEGIN; INSERT INTO users_groups (user_id, group_id) VALUES (100, 1…
Post: Google's user_statistics V2 port and changes
September 12, 2008 By 9 Comments
… user_statistics we use in our releases. New features are quite interesting so we decided to port it to fresh releases of MySQL… per user FLUSH USER_ and CLIENT_STATISTICS commands Our port includes: INFORMATION_SCHEMA tables – USER_STATISTICS, CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS Access protection – USER_STATISTICS, CLIENT_STATISTICS available only for user…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
… User Statistics in my.cnf: 5.5 userstat = 1 5.1 userstat_running = 1 Then we get the information about a particular user: mysql> select * from user_statistics where user=’root’\G *************************** 1. row *************************** USER: root TOTAL_CONNECTIONS: 25 CONCURRENT_CONNECTIONS…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…0 The #14 and #15 here is kernel and user CPU usage of MySQL process in 1/100 of the second. (…running Percona Server you can get the value from User Statistics *************************** 1. row *************************** USER:user TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS: 0 CONNECTED_TIME: 800…
Post: MySQL extensions for hosting
April 24, 2008 By 11 Comments
… new set of commands such as SHOW TABLE_STATISTICS, SHOW INDEX_STATISTICS and SHOW USER_STATISTICS. The first two can interest anyone to periodically… catch users causing the most traffic to help you with some strategic decisions. Sample outputs: mysql> SHOW USER_STATISTICS LIKE ‘hosting2′\G *************************** 1. row *************************** User…
Post: Find unused indexes
June 30, 2012 By Leave a Comment
… explore the two most common here. User Statistics from Percona Server and pt-index-usage. User Statistics User Statistics is an improvement on Percona Server that…_SCHEMA.INDEX_STATISTICS but first we should enable User Statistics: mysql> SET GLOBAL userstat=on; After all this hard work we have the statistics plugin…
