…247″] Percona Server for MySQL version 5.1.69-14.7[/caption] Percona is glad to announce the release of 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 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 2 Comments
…Percona Server for MySQL version 5.6.11-60.3[/caption] Percona is glad to announce the first Release Candidate release of Percona…definition for the User Statistics tables in INFORMATION_SCHEMA (CLIENT_STATISTICS, INDEX_STATISTICS, TABLE_STATISTICS, THREAD_STATISTICS, and USER_STATISTICS) led to the …
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… New Features: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now …was used. Bug fixed #1107539 (Sergei Glushchenko). Suboptimal code for User Statistics feature has been optimized to make sure no additional …
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…=”247″] Percona Server for MySQL version 5.5.30-30.2[/caption] Percona is glad to announce the release of Percona Server for MySQL 5… 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
…who are really interested in Percona XtraDB Cluster (PXC) and …MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL… track of global achievement statistics in a single table …some metadata: BEGIN; INSERT INTO users_groups (user_id, group_id) VALUES (…
Post: Auditing login attempts in MySQL
December 28, 2012 By 4 Comments
…User Statistics If you are using Percona Server then there is a third option to get information about our users, the User Statistics… about a particular user: mysql> select * from user_statistics where user=’root’\G *************************** 1. row *************************** USER: root TOTAL_…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
….5.24-log’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Percona XtraDB Cluster (GPL), wsrep_23….’s statistics page, and the others are for PXC. We will have MySQL listening …=mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql…
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… corruption. This bug was introduced in MySQL 5.5.18 and Percona Server inherited it from MySQL. Bug fixed #915814 (George Ormond Lorch…
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. (…per query. If you’re running Percona Server you can get the value from User Statistics *************************** 1. row *************************** USER:user TOTAL_CONNECTIONS: 1 CONCURRENT_CONNECTIONS…
Post: Find unused indexes
June 30, 2012 By Leave a Comment
… two most common here. User Statistics from Percona Server and pt-index-usage. User Statistics User Statistics is an improvement on Percona Server that adds some…INDEX_STATISTICS but first we should enable User Statistics: mysql> SET GLOBAL userstat=on; After all this hard work we have the statistics…
