… Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory… 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
… Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be shipped with the libjemalloc library. Benchmark showing the impact of memory… used. Bug fixed #1107539 (Sergei Glushchenko). Suboptimal code for User Statistics feature has been optimized to make sure no additional work…
Post: MySQL Binaries Percona build10
December 11, 2008 By 12 Comments
… | Percona | GPL | The names are Innodb_scan_* | | userstatsv2.patch | SHOW USER/TABLE/INDEX statistics | V2 | Google | GPL | Added INFORMATION_SCHEMA.*_STATISTICS | | show_patches.patch | SHOW PATCHES… in SHOW INNODB STATUS | 1.0 | Baron Schwartz | GPL | Bug #29126 fix | | microslow_innodb.patch | Extended statistics in slow.log | 1.1 | Percona…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… by Percona Server. Another great thing about Percona …statistics available after the query is actually executed, while no such statistics… ################### # 1ms ################################################################ # 10ms # # 100ms # 1s # 10s+ # Tables # SHOW TABLE STATUS FROM `wp_blog…
Post: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 7 Comments
…commands like SHOW INDEX, SHOW TABLE STATUS and SHOW [FULL] TABLES (or their corresponding queries from INFORMATION_SCHEMA.TABLES and INFORMATION_SCHEMA.STATISTICS) …12 seconds to update all the tables’ statistics. Luckily, this can be controlled with Percona Server with the variable innodb_stats_…
Post: Percona build7 with latest patches
November 14, 2008 By 26 Comments
… | Percona | GPL | The names are Innodb_scan_* | | userstatsv2.patch | SHOW USER/TABLE/INDEX statistics | V2 | Google | GPL | Added INFORMATION_SCHEMA.*_STATISTICS | | show_patches.patch | SHOW PATCHES… in SHOW INNODB STATUS | 1.0 | Baron Schwartz | GPL | Bug #29126 fix | | microslow_innodb.patch | Extended statistics in slow.log | 1.1 | Percona…
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
…() With userstat you can get additional THREADS_STATISTICS which show similar information to USER/CLIENT_STATISTICS but per THREAD granularity (it’s useful…, you can get them from Launchpad https://code.launchpad.net/~percona-dev/percona-patches/5.1.43. Binaries are also on… results I show amount of TradeResults transactions per 10 sec during 3600 session (more is better) As you see with percona patches…
Post: Announcing Percona Playback 0.5
November 26, 2012 By
… with Percona Playback and tcpdump Miguel already showed in his post how to use Percona Playback with the query_log plugin. Following example shows… dump file has been replayed on the server, Percona Playback will show the playback statistics in the report like: Executed 1271 queries Spent…
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 … releases: mysql-5.0.62-percona.tar.bz2 md5:0d8a37e09eca93cde6170866293a82ff mysql-5.1.26-percona.tar.bz2 md5:0574b38755786a97bc476058051cbe82 You …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… looks like this: [percona@db1 ~]$ mysqladmin ext -ri10 +———————————–+———————-+ | Variable_name | Value… paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_…odd statuses, like “statistics“, I know something …
