…hit a bug. It is also possible that this binary or one of the libraries it was linked against…variables. Some pointers may be invalid and cause the dump to abort. Query (0): is an invalid pointer …56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced and loaded for… is similar to the Dump/Restore of the Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied into backup… TABLESPACE on MySQL and Percona Server 5.6 as described in Exporting and Importing Tables guide. Bugs Fixed: xtrabackup_56 binary was…
Post: Percona XtraBackup 2.1.0 'release candidate' for MySQL available for download
May 7, 2013 By Leave a Comment
… InnoDB Buffer Pool Preloading introduced in MySQL 5.6. Starting with MySQL 5.6 buffer pool dumps can be produced and loaded for… is similar to the Dump/Restore of the Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied into backup… fail. Bug fixed #1169726. For the Debian and the Linux binaries, the –version message which should include the revision was showing…
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
… there are many documents about that: http://dev.mysql.com/doc/refman/5.6/en/replication-gtids…fatal error 1236 from master when reading data from binary log: ‘The slave is connecting using CHANGE MASTER…the shell buffer because the restore of the dump will continue. Be cautious. Same problem again so…
Post: How to obtain the "LES" (Last Executed Statement) from an Optimized Core Dump?
September 9, 2012 By 9 Comments
… seen when using optimized (release) binaries: debug symbols have been stripped out. In non-optimized binaries, the query would (in most cases… compilation time) First we inspect the mysql_execute_command frame: (gdb) frame 21 #21 0x00000000005a30af in mysql_execute_command (thd=thd@entry… found in an optimized core dump by checking the contents of the thd array in the mysql_execute_command frame. By simply…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
…. Recently in MySQL 5.6, mysqlbinlog got a new feature addition that supports connecting to remote MySQL instances and dumping binary log data to local disks ( http://dev.mysql.com/doc/refman/5.6…
Post: MySQL Installation and upgrade scripts.
May 21, 2007 By 3 Comments
… why number of people established slow by safe upgrade procedures – dump your data and reload. Little tip to mention – upgrading to… get RedHat or Fedora which comes with MySQL binary and if you’re standard MySQL user you would just use that RPM and… out where but this was pure “rpm -Uvh MySQL*” in the directory with few downloaded MySQL binaries so it should be pretty straightforward.
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… done in many cases. There is really no gain in dumping table via mysqldump and loading it back. If performance is… be making MySQL Replication to work. You might need to inject MySQL 5.0 in between so it will convert binary log events… Percona Server features which are marked as making database binary incompatible with MySQL. Our focus on compatibility is indeed so high there…
Post: Fighting MySQL Replication Lag
September 22, 2008 By 7 Comments
… query design mistakes which result in low hanging fruit troubleshooting MySQL Replication Lag First fact you absolutely need to remember is… and small and fast updates which go after it in MySQL binary log can’t proceed. It is either more than than… all updates from the transactions are buffered together and when dumped to binary log as one big chunk which can’t be…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… in compressed file size. Though in this example we used MySQL binary log file which often contains plenty of similar events, which… which makes it easy drop in replacement. I got LZOP binary which was built against LZO 1.0, more resent version… and slower compression make sense because it takes longer to dump and much longer to load to the database anyway so…
