… either automatically on startup or on demand. Time interval between checks done by log copying thread is now configurable by innobackupex… MySQL 5.6. This option can be used to produce 5.6-style metadata files, that can be imported by ALTER TABLE IMPORT TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables guide. Bugs Fixed…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… was still beta. Now that MySQL 5.6 is GA, so is our support for it. Check out the Percona Toolkit supported… it and how. There’s still one noticeable omission: pt-table-sync. It’s still unclear if or how one would… the DBD::mysql Perl module that have problems. And there are certain versions of MySQL that have critical bugs. Version check will warn…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… this benchmark for MySQL Server 5.5.30, 5.6.11 and Percona Server 5.5.30 and check how these servers…. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops…_capacity = 5000 sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… much larger one, 16 tables with 5M rows each (about 23GB). So it makes sense to check if the dataset size makes…=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp…=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=9 –oltp…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… (Alexey Bychko). Reduced the overhead from innodb_pass_corrupt_table value checks by optimizing them for better CPU branch prediction. Bug fixed… (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing. Bug fixed #1041981…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… mechanism, unlike anything you find in standard async MySQL replication. It is my belief that the lack … into the certification index, which is a hash table. A small fc_limit does however keep the … There are two global status variables you can check to see what flow control is happening: wsrep_…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
…-indexes. This allows parallel processing of individual tables when rebuilding the index. Percona XtraBackup … Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client…cause SST to fail. Fixed by fix checking if xtrabackup_pid file exists once innobackupex…
Comment: How to recover table structure from InnoDB dictionary
May 8, 2013 By 4 Comments
… then ibdata1 should be valid, maybe with some corruption. The tables structure you can get from the dictionary as it is…. You can check the docs how to do it http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery… find index_id for each table – http://www.percona.com/docs/wiki/innodb-data-recovery-tool:mysql-data-recovery:advanced_techniques#recovering…
Comment: Percona Toolkit 2.2.2 released; bug fixes include pt-heartbeat & pt-archiver
May 15, 2013 By 2 Comments
hello, currently using 2.2.2 and mysql Ver 14.14 Distrib 5.5.30, for Linux (x86_…/etc/my.cnf -Dpt_heartbeat –check The –master-server-id option must be specified because the heartbeat table `pt_heartbeat`.`heartbeat` uses the server_id column for –update or –check but the server’s…
Comment: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 7, 2013 By 10 Comments
… the data are not getting updated in all the tables and only few tables are getting updated which was never the case… this regards. Note: i checked the same process on our Development server which is still running on MYSQL and it worked fine.
