… 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… can skip that after the snapshot restart. Using the below command and some inline searches, I was able to pinpoint the…-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…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By Leave a Comment
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…, so use the command that the mysql RA uses, which is: crm_attribute –type crm_config –name replication_info -s mysql_replication -v…
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: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… to provide our estimates. If we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb… ? You can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S…: 336986112 BINLOG_BYTES_WRITTEN: 0 ROWS_FETCHED: 485139 ROWS_UPDATED: 0 TABLE_ROWS_READ: 610954 SELECT_COMMANDS: 181243 UPDATE_COMMANDS: 0 OTHER_COMMANDS: 0…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 9630066 | | Bytes_received | 38563413074 | | Bytes_sent | 216162991863 | | Com_admin_commands | 255868807 …
Post: Filtered MySQL Replication
November 7, 2007 By 7 Comments
… not a big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication…). On the Master you can do filtering using binlog-do-db and binlog-ignore-db commands. This is there a lot of people… you need to skip some statements from binary logging. This command requires SUPER Privilege and extreme care in use but it…
Post: Percona Testing: Innodb crash / recovery tests available
December 21, 2011 By Leave a Comment
…tests have been created for the main MySQL branch. The MySQL at Facebook branch has a number…_after”, DBUG_SUICIDE();); DBUG_EXECUTE_IF(“half_binlogged_transaction”, DBUG_SUICIDE();); What happens is that…kewpie/randgen/backtrace.gdb:20: Error in sourced command file: No registers. # 2011-12-21T14:25:…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
…may not be available, especially for CPU bound MySQL Load. The benefit in this case is … Recently I did a little benchmark compressing 1GB binlog file with GZIP (compression done from OS cache…rather active project. There is also GZIP like command like compressor using LZO library called LZOP which…
Post: Google's user_statistics V2 port and changes
September 12, 2008 By 9 Comments
…BINLOG_BYTES_WRITTEN: 0 ROWS_FETCHED: 593836 ROWS_UPDATED: 0 TABLE_ROWS_READ: 549073 SELECT_COMMANDS: 214801 UPDATE_COMMANDS: 0 OTHER_COMMANDS… | +————–+————+—————–+———–+ 10 rows in set (0.00 sec) mysql> select * from information_schema.table_STATISTICS limit 10; …
Comment: Storing MySQL Binary logs on NFS Volume
August 3, 2010 By 19 Comments
… shell command that is being invoked after a binlog cycle. That shell command would get the name of the old, just retired binlog file… and disowned process. The shell command typically would be a command that will then scp the old binlog offsite. Postgres happens to have such a mechanism for their WAL, and MySQL is…
