…/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: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…MySQL Replication Latency in Percona XtraDB Cluster[/caption] I was curious to check how Percona XtraDB Cluster behaves when it comes to MySQL…mysql# sysbench –test=oltp –oltp-auto-inc=off –oltp-test-mode=nontrx –oltp-nontrx-mode=update_key –mysql-user=root –mysql…per-request statistics: min: 0….
Post: Quickly finding unused indexes (and estimating their size)
December 5, 2012 By 2 Comments
… It’s quite easy to collect statistics about index usage in Percona Server (and others) using the User Statistics patch. By enabling ‘userstat_running… droppable_indexes view to use that information: mysql> drop view if exists droppable_indexes; mysql> create view droppable_indexes as select all…
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 7 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 …
