…# yum -y install Percona-XtraDB-Cluster-server Percona-XtraDB-Cluster-client percona-xtrabackup Install … a 3 node cluster. mysql> show global status like ‘wsrep_cluster_size’; +——————–+——-+ | Variable_name |… the least connections established. The statistics page is accessible on the…
Post: Percona Server and XtraBackup weekly news, February 5th
February 6, 2011 By 2 Comments
…He’s one of Percona‘s data recovery experts, among other things). Percona Server news: Percona Server 5.5 … as name changes to command-line options and SHOW VARIABLES variables. And Fred Linhoss committed some …on a bug that makes the INDEX_STATISTICS and TABLE_STATISTICS tables under-report by 1 the …
Post: Percona-XtraDB-9.1: released and new coming features
March 17, 2010 By 14 Comments
… new Percona-XtraDB-9.1 release, and now it is ….0: extended slow.log USER/TABLE/INDEX/CLIENT_STATISTICS + THREAD_STATISTICS ( coming in release-10) Extended slow.log…/ export of buffer_pool Transactional replication Show internal InnoDB data dictionary Show InnoDB locking/io profiling in slow…
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
…Oleg Tsarev, backport from MySQL 5.5) show_engines – Changes SHOW STORAGE ENGINES to report XtraDB when appropriate…_stats_table – If ON, the table’s statistics are stored statically in the internal table …Please report any bugs found at Bugs in Percona Server. For general questions, use our Pecona-…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…Replication Latency in Percona XtraDB Cluster[/caption] I was curious to check how Percona XtraDB Cluster behaves … interesting thing happens. The script does not show any data propagation delays but it visibly … on the different cluster node: per-request statistics: min: 0.69ms avg: 1.12ms max: …
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
… an index using Fast Index Creation, statistics for that index provided by InnoDB…-admin-statements was not listed with SHOW VARIABLES. #830199 (Oleg Tsarev). Fixed … the following links: Downloads: Binary distributions, Percona Software Repositories Installation instructions Consulting, support, …
Post: Percona Server 5.1.49-rel11.3
September 10, 2010 By 1 Comment
…_sys_stats_table. If ON, the table’s statistics are stored statically in the internal table SYS…running=1 Bug #612954 – Fixes a problem with SHOW PROCESSLIST displaying an incorrect time Bug #610525 – …on our website. The latest source code for Percona Server, including the development branch, can be …
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
…HTTP JSON API (experimental) Some of the Percona InnoDB patches have been merged Since Drizzle… the translations add more too). Some interesting statistics about this Drizzle release: The diffstat …policy, logging to syslog, authentication via LDAP. This shows that major pieces of functionality can …
Post: New patches, new builds
September 5, 2008 By 24 Comments
… | 1.0 | Percona | GPL | Ported from Debian | | microslow_innodb.patch | Extended statistics in slow.log | 1.0 | Percona | GPL | | | … BSD | | | userstats.patch | SHOW USER/TABLE/INDEX statistics | 1.0 | Google | GPL | Added INFORMATION_SCHEMA.*_STATISTICS | | show_patches.patch | SHOW PATCHES | 1.0 …
Post: Beware the Innodb Table Monitor
November 29, 2011 By 2 Comments
… for each table, it calls dict_update_statistics and appears to force table statistics to be regenerated for each table It’s… sure looks like dict_update_statistics is called twice for each table, at least in the latest Percona Server 5.1 in…, the io-wait spike is explained by table statistics being regenerated, and the SHOW PROCESSLIST connections stuck in ‘Opening Tables’ were waiting…
