…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: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
…/lib/mysql/slow_query.log | for compatibility with MySQL 5.1 and | userstat_running | OFF | to control gathering of user statistics….0 | Percona | GPL | The names are Innodb_scan_* | | userstatsv2.patch | SHOW USER/TABLE/INDEX statistics | V2 | Google | GPL | Added INFORMATION_SCHEMA.*_STATISTICS |…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…Percona Server. Another great thing about Percona Server is the ability to enable logging atomically, not just for new connections as in MySQL… the statistics available after the query is actually executed, while no such statistics are…is an overall summary: # 8.1s user time, 60ms system time, 26.23M …
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 5 Comments
… statistics is used for JOIN optimizations and helping the MySQL optimizer choose the appropriate index for a query. If a table’s statistics… of seconds on execution time. # Time: 110923 1:48:17 # User@Host: user1[user1] @ [172.20.6.1] # Thread_id: 10140441… the tables’ statistics. Luckily, this can be controlled with Percona Server with the variable innodb_stats_auto_update (from MySQL Community 5.1…
Post: Percona builds with Percona patchsets
July 16, 2008 By 35 Comments
… InnoDB statistic (show extended InnoDB usage during query execution in slow log) Google’s patches with user statistics, and statistics about tables…to the source releases: mysql-5.0.62-percona.tar.bz2 md5:0d8a37e09eca93cde6170866293a82ff mysql-5.1.26-percona.tar.bz2 md5:…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql… MySQL configuration Then I’ll look at my.cnf quickly for anything weird: [percona@db1 ~]$ grep…of queries in odd statuses, like “statistics“, I know something weird is going …
Post: Percona Server and XtraBackup weekly news, March 5th
March 6, 2011 By Leave a Comment
… this week in Percona Server: For users who upgraded to Squeeze, the new version of Debian… Yasufumi clarified his idea for XtraDB to store statistics for the ::records_in_range() handler function, … decided to make innobackupex always back up the MySQL system database, even for partial backups; it …
Post: Percona Server and XtraBackup weekly news, February 26th
February 27, 2011 By 5 Comments
…width=”250″ caption=”Percona Server Logo”][/caption] Other news for Percona Server: Many users noticed …, which will be based on MySQL 5.1.55. We merged …statistics for the ::records_in_range() handler function, instead of accessing the data. This could improve performance for complex queries. A user…
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
…the Percona Software Repositories). Based on MySQL 5.1.59, including all the bug fixes in it, Percona … specified, it will be killed. This prevents users from blocking purge by mistake. Block startup … After adding an index using Fast Index Creation, statistics for that index provided by InnoDB were …
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
…the Percona Software Repositories). Based on MySQL 5.5.16, including all the bug fixes in it, Percona … specified, it will be killed. This prevents users from blocking purge by mistake. Block startup … After adding an index using Fast Index Creation, statistics for that index provided by InnoDB were …
