… machine to another and configured with Linux network interface bonding in balance-rr mode… server, thus resulting in less binary log data being sent down to the lower… information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information in file: ‘./mysql/servers.frm’ Running mysql_install_db…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
…. Percona XtraBackup would fail when preparing the MySQL 5.6 backup if the log files were bigger than 4G on the source server. Bug fixed #1164979. Due to different implementation in MySQL 5.6… innodb_data_file_path option which could cause backup to fail. Bug fixed #1169726. For the Debian and the Linux binaries, the…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
…files). Percona XtraBackup has implemented support for the InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL… by the log records in the transactional log being overwritten …file_path option which could cause backup to fail. Bug fixed #1169726. For the Debian and the Linux…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
….5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql #for SSD innodb_flush_neighbor… innodb_log_buffer_size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb_log_file_size = 4G innodb_log_files_in_group = 2 innodb_log_block…
Post: Be careful rotating MySQL logs
December 9, 2007 By 7 Comments
… typical Linux systems – If you follow most simple process – delete log file you do not need and run “FLUSH LOGS” so file is …log file is reopened MySQL will be practically unavailable causing unanticipated downtime. The workaround for this problem is very simple – instead of deleting MySQL log file…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_DIR | /mnt/nfs/dist/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6.10-linux-glibc2. | | PERFORMANCE_SCHEMA_MAX…_LOG_FILE_SIZE | 5242880 | 50331648 | | BASEDIR | /mnt/nfs/dist/5.5.30 | /mnt/nfs/dist/5.6.10 | | BACK_LOG | 50 | 80 | | OPEN_FILES… is disabled by default in MySQL 5.6 Welcome to much faster information_schema queries! innodb_log_file_size – default has been increased…
Post: Be productive with the MySQL command line
December 21, 2012 By 14 Comments
… easier. Note: The commands below are only available for Unix/Linux. Using pager Most of the graphical tools paginate results, which… set (0.00 sec) mysql> exit And now if you look at the content of the queries.log file, you will see a copy of your session. Conclusion The mysql command line client is not…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… x86_64 GNU/Linux [percona@db1 ~]$ cat /etc/*release Red Hat Enterprise Linux Server release 5.2 …safe –defaults-file=/etc/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 …innodb_log_file_size. I won’t give you a full rundown over every option in the file. But…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… are similar for any Linux distribution. The client …log_slave_updates innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 innodb_buffer_pool_size=400M innodb_log_file…mysql –mysql-engine-trx=yes –mysql-table-engine=innodb –mysql-host=127.0.0.1 –mysql-port=3307 –mysql-user=sbtest –mysql…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…N_SEGMENTS in coregrind/m_aspacemgr/aspacemgr-linux.c (when you see ‘Valgrind: FATAL: … tool: $ valgrind –tool=massif –massif-out-file=/tmp/massif.out /path/to/mysqld {mysqld…Log_event::read_log_event(st_io_cache*, st_mysql_mutex*, Format_description_log_event const*) (in /usr/local/percona/mysql…
