…(5.5.28-29.1). This is needed as the plugin needs the offset to some MySQL data …was working in and didn’t get significant differences between either output option, or between using the plugin…activity”,”date”:”1369155747383″,”thread-id”:”6440″,”query-id”:”0“,”user”:”debian-sys-maint”,”priv_user”:”…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
…a snapshot of a particular MySQL schema and then reload it with a different schema name on the same … database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable…on my test VM: Percona Server 5.5.30 Xtrabackup 2.0.6 Some other use cases that …
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…longer supported from MySQL 5.5). If you want to know more details, please read on! MySQL 5.0/5.1 First let’s consider MySQL 5.0 and 5.1. RESET SLAVE will…soon as you are aware of the difference between RESET SLAVE and RESET SLAVE ALL, disconnecting a replication slave is much easier with MySQL 5.5+.
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…and store against both a standard memcached instance and a minimally tuned MySQL 5…->start(); for ($i = 0; $i < 10; $i++) { for ($i = 0; $i < 100000;... only change between runs is…differences: InnoDB store operation was 280% higher (~1.73 ms/op) InnoDB fetch operation was 20% higher (~.06 ms/op) MySQL…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
…, and MySQL 6.0 was to ship the next year. MySQL releases are split between the MySQL Community, and MySQL Enterprise is released with different versions on different schedules. MySQL 5.0.37 GA and 5.1…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…1 only retries certain operations, pt-osc 2.2 retries every critical operation, and its tries and wait time between… ago and not updated since. Now that we have four base versions of MySQL (5.0, 5.1, 5.5, and 5…. run once and exit. And each treated their run-related options a little differently. This…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… announce the release of Percona XtraBackup 2.1.0-rc1 on May 7, 2013. Downloads are … between taking a full backup and an incremental one were present in the full backup directory, and …backup process. Bug fixed #1130145. Due to different implementation in MySQL 5.6 error messages were not printed …
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…difference between servers at 64 threads but a much more notable drop for 5…0 performance_schema=0 #56only loose-innodb_flush_neighbors=0 loose-metadata_locks_hash_instances=256 innodb_buffer_pool_instances=16 # MySQL 5.5 and 5…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to understand more about differences between results we have …0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp-simple-ranges=0…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL…and establish global ordering for every transaction, and the expense of doing that for Galera is approximately one RTT between…5…and Galera is no different…
