… add binary log filters; this ensures that the top-level master and its binary logs are fully intact, and then the binary log filters are executed on the intermediate server, thus resulting in less binary… –skip-grant-tables and insert a few rows into an InnoDB table, but trying to run a simple mysqlslap just hung…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
… has introduced innodb_read_views_memory and innodb_descriptors_memory status variables in the Extended Show Engine InnoDB Status to improve InnoDB memory usage…. If a slave was running with its binary log enabled and then restarted with the binary log disabled, Crash-Resistant Replication could…
Post: Migrating between MySQL schemas with Percona Xtrabackup
June 10, 2013 By 2 Comments
… to the dirty tablespace and voila, you have a consistent binary backup at a point in time. When running Percona Server… target database: mysql orig_old < /tmp/orig.schema.sql Ensure innodb_import_table_from_xtrabackup = 1 (dynamic variable) Prepare the backup… FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA=’orig’ AND ENGINE=’InnoDB‘; EOF mysql -N -B <<'EOF' > import-ddl.sql SELECT CONCAT…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… MySQL hot backup software that performs non-blocking backups for InnoDB and XtraDB databases. This release is the current GA (Generally… pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with… the innodb_data_file_path option which could cause backup to fail. Bug fixed #1169726. For the Debian and the Linux binaries…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… this re-release only affects RPM so our dpkg and binary packages remain unchanged. Percona XtraDB Cluster was also affected by… upstream bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov). In the… #1041981 (Alexey Bychko). Fixed the upstream bug #68197 that caused InnoDB to misclassify internal read operations as synchronous when they were…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… computed using weighted sum over group members. Percona XtraDB Cluster binary will now be bundled with the libjemalloc library. For RPM… fixed #1154095 (Alex Yurchenko). If variable innodb_thread_concurrency has been defined to throttle InnoDB access, and work load contained DDL statements…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…-29.3 which could cause a server to hang when binary log is enabled. Bug fixed #1162085 (Alexey Kopytov). Fixed upstream… upstream bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov). In the… #1041981 (Alexey Bychko). Fixed the upstream bug #68197 that caused InnoDB to misclassify internal read operations as synchronous when they were…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… pool dump files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with… were not printed to stderr directly. Because of that all InnoDB error or diagnostic messages are never printed by xtrabackup_56… the innodb_data_file_path option which could cause backup to fail. Bug fixed #1169726. For the Debian and the Linux binaries…
Post: MySQL alternative Percona Server 5.1.68 -14.6 now available
April 19, 2013 By 3 Comments
…. Bugs fixed #1031427 and #1051874. When mysqldump was used with –innodb-optimize-keys option it produced invalid SQL for cases when… creation optimization. Bug fixed #1081016. When mysqldump was used with –innodb-optimize-keys and –no-data options, all secondary key definitions…-14.2 which could cause a server to hang when binary log is enabled. Bug fixed #1162085. Percona Server would re…
Post: Virident vCache vs. FlashCache: Part 1
May 16, 2013 By 3 Comments
… where the MySQL working set is significantly larger than the InnoDB buffer pool (thus leading to a lot of buffer pool… appropriate sysctl setting; with vCache, there is a command-line binary which can modify many of the same parameters, but doing…
