… available here and from the Percona Software Repositories). Based on MySQL 5.1.62, including all the bug fixes in it… SBR, because with RBR database name is encoded within the BINLOG ‘….’ statement. Release notes for Percona Server 5.1.62-13…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
… size 1248, 3 row lock(s), undo log entries 1 MySQL thread id 3, OS thread handle 0x7f84a78ba700, query id 163… to prevent that from happening. 2- innodb_locks_unsafe_for_binlog = 1. Disables the gap locks except for foreign-key constraint…/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default isolation level so it…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
… above. [root@sb logs]# cat mysql-data-201202230157-binlog-info File Position Binlog_Do_DB Binlog_Ignore_DB mysql-bin.000022 336796712 Using the coordinates…-position 336797133 mysql-bin.000022 | mysql [root@sb logs]# mysqlbinlog –verbose –base64-output=decode-rows –start-position 336797275 mysql-bin.000022 | mysql mysql> select count…
Comment: How FLUSH TABLES WITH READ LOCK works with Innodb Tables
March 27, 2012 By 20 Comments
… InnoDB: Last MySQL binlog file position 0 15906301, file name ../log/binlog.000290 … This is a slave, it has no binlog of its own. SHOW SLAVE STATUS says Master_Log_File: binlog.000062…
Comment: Too many connections? No problem!
March 15, 2012 By 28 Comments
… have my website develop in PHP with MYSQL, these are MYSQL values: datadir=/data/mysql socket=/data/mysql/mysql.sock max_connections = 600 wait_timeout… default-time-zone=America/Caracas log-slow-queries=/var/log/mysql-slow-queries.log long_query_time=15 log-queries-not… = 1 log-bin=/data/mysql/drbd expire_logs_days = 5 max_binlog_size = 100M [client] socket=/data/mysql/mysql.sock When I start the…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
March 7, 2012 By 94 Comments
… change the “replication_info” manually in corosync to the new binlog and logpos position from when you took the dump/copy… try to edit it, so use the command that the mysql RA uses, which is: crm_attribute –type crm_config –name replication_info -s mysql_replication -v “||” Now start corosync on your slave and let…
Comment: Percona XtraDB Cluster Feature 2: Multi-Master replication
April 2, 2012 By 16 Comments
… comparison, you probably should compare single Galera node with plain mysql with binlog turned on. Having said that, 20% may be not…
Comment: Online MySQL Configuration Wizard from Percona
March 15, 2012 By 23 Comments
… if binlogging is enabled on slave). Then I don’t like the idea of putting socket and pid files in mysql data…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… amazing MySQL manual, especially the option and …binlog_cache_sizeblogpercona.commanual Binlog_cache_useblogpercona.commanual binlog_direct_non_transactional_updatesblogpercona.commanual binlog_do_dbblogpercona.commanual binlog_formatblogpercona.commanual binlog_ignore_dbblogpercona.commanual binlog…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
… can cause serve performance degradation. Configuration Changes Have you changed MySQL configuration ? OS Configuration or Hardware configuration or could have anyone… performance in general). Typical problems for replication include setting sync_binlog=1, enabling log_slave_updates, setting innodb_flush_log_at… as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the most…
