… prevent XtraBackup failures that are caused by the log records in the transactional log being overwritten before they are copied by the… this blogpost. Percona XtraBackup option xtrabackup –export now supports transportable tablespaces introduced in MySQL 5.6. This option can be used to produce…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
… 2.2 has fewer options now. Basically, we re-focused it on its primary objective: analyzing MySQL query logs. So the ability to parse memcached, Postgres, Apache, and other logs was removed. We also removed several options that probably… pt-mysql-summary have built-in MySQL options No more “pt-stalk — -h db1 -u me”. pt-stalk 2.2 and pt-mysql-summary…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… prevent XtraBackup failures that are caused by the log records in the transactional log being overwritten before they are copied by the… this blogpost. Percona XtraBackup option xtrabackup –export now supports transportable tablespaces introduced in MySQL 5.6. This option can be used to produce…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… (Alexey Kopytov). Ported back from the upstream MySQL 5.6 the fix for unnecessary log_flush_order_mutex acquisition. Bug fixed #1163262 (Alexey Kopytov). When mysqldump was used with –innodb-optimize-keys and –no-data options… fixed #1015506 (Alexey Bychko). Percona Server for MySQL was missing help texts in the MySQL client because the help tables were missing…
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… option that can be used to specify the number of threads started by XtraBackup when rebuilding secondary indexes on innobackupex –apply-log…. innobackupex now uses Perl’s DBD::MySQL package for server communication instead of spawning the MySQL command line client. Support for InnoDB… #1175860. xtrabackup –stats option would not work with server datadir if the server isn’t running and logs were in a separate…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…standard MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication… consider relaxing the fsync: set innodb_flush_log_at_trx_commit to something besides …is fine as long as you weigh both options carefully. But in Galera you cannot relax …
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…is how one would start the memcached plugin: mysql> install plugin daemon_memcached soname ‘libmemcached.so’; … is using InnoDB under the hood (redo logs, etc). Based on the above numbers, here … server Now, there are definitely other NoSQL options for persistent cache out there (Redis, Couchbase, etc…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…_size = 36G innodb_log_file_size = 4G innodb_log_files_in_group = 2 innodb_log_block_size=4096 #####plugin options innodb_read_io_threads… = 4000 innodb_use_native_aio=0 #not innodb options (fixed) port = 3306 back_log = 50 max_connections = 2000 max_prepared_stmt_count… = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root skip-grant-tables TokuDB-related options are all defaults, as I understand…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A) appears below: #####fixed innodb options… O_DIRECT innodb_log_buffer_size = 128M innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log_files_in…
Comment: How to lag a slave behind to avoid a disaster
April 25, 2013 By 5 Comments
Is mysql ‘start slave until master-log-file master-log-pos’ reliable enough to synch up two slaves with their …. The only option I see to stop slave on slave2 and wait a few seconds to make sure master_log_position on…
