… is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE transaction-isolation…_concurrency = 8 max_heap_table_size=200M log-output = FILE log-slow-queries=/tmp/mysql-slow.log long_query_time = 1 innodb_data… benchmark optimized – for example doublewrite is disabled; checksums are disabled; binary log is disabled – this is not what you would probably run…
Post: Announcing Percona XtraBackup 2.0.4
December 4, 2012 By 2 Comments
… of the doublewrite buffer wasn’t added to the backup-my.cnf and after the restore old doublewrite buffer file was used… fail on –apply-log when filesystem didn’t support Linux AIO. Bug fixed #1065561 (Alexey Kopytov). XtraBackup binary would ignore innodb_use_native_aio when it’s specified either in my.cnf or as a command…
Comment: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
… try the settings for any OLTP workloads they have. back_log is calculated based on max_connections. You’re right that… do it in the server defaults but in the default my.cnf file that we ship. It’s also done by the… the ability to write less information in the binary log when using row-based logging. Both of those are good and I recommend…
Post: Replication of MEMORY (HEAP) Tables
October 15, 2010 By 7 Comments
… and ROW replication contain the changes to the data in binary logs. This requires the data to be same on Master and… can do the following: Add skip-slave-start in your my.cnf; run SLAVE STOP; dump all your memory tables using MySQLDump…/TREE replication. In this case you will need to disable binary logging while loading data from mysqldump as you may not want…
Post: Announcing Percona Playback 0.5
November 26, 2012 By
… can measure how a server or database upgrade, change in my.cnf or schema change can affect the overall performance of your… supports reading the slow query log from standard input (stdin) instead of log file. For this release binary packages were prepared, full list is available in our documentation. Bugs fixed: Multi-line queries in the slow query log…
Post: Percona Server 5.1.58-12.9
August 17, 2011 By 2 Comments
…machine restarts. The configuration variables for my.cnf have been kept for compatibility and…). Uninitialized values in the Slow Query Log patch. Bug Fixed: #794774 (Oleg Tsarev…, please see the following links: Downloads: Binary distributions, Percona Software Repositories Installation instructions …
Comment: Reasons for MySQL Replication Lag
August 8, 2011 By 9 Comments
… do have some clarifications on configuration and network . On my.cnf config binary log format is a key factor . Any specific reason it has…
Comment: Concurrent inserts on MyISAM and the binary log
May 14, 2008 By 7 Comments
I tried setting binlog_format=row in my.cnf, verified that it worked, and then ran an INSERT and an INSERT..SELECT. The results were the same: this code does not seem to be affected by the binary logging format at all.
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
…autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files_in_group = 3 xtrabackup: innodb_log_file_… special option “export” xtrabackup –defaults-file=/etc/my.reg.cnf –prepare –export –use-memory=8G –…storage engine, you can take one of our binary builds with 5.1.36. On …
