… in MySQL 5.6.10 source, in file sql/log.cc. I discovered that they have refactored the way they write to file-based… information to the log file, it outputs the query time and lock time as floating-point numerics to microsecond scale: sql/log.cc, MYSQL… log file. To account for this, you can use a client script to dump the contents of the query log table into a flat file…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…to the amazing MySQL manual, especially the option and variable reference table. But just as frequently, I want to…file_formatblogpercona.commanual innodb_file_format_checkblogpercona.commanual innodb_file_format_maxblogpercona.commanual innodb_file… sporadic_binlog_dump_failblogpercona.commanual …
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
… thing about .ibd files you can’t easily copy the an .ibd file to another MySQL server. If you try to very often you’ll… ibdata was updated MySQL will fail to start with error: InnoDB: Reading tablespace information from the .ibd files… InnoDB: Error: trying to add tablespace… time to be sure ibdata1 has valid checksums: #./innochecksum /var/lib/mysql/ibdata1 # 5. Now you can start MySQL and take a dump from…
Post: More on MySQL Error Messages
April 6, 2011 By 9 Comments
… you may get some extra files, which do not belong to MySQL in database directory. MySQL will only remove files it knows about such as… as .sql file containing the dump of this database you will not be able to drop it until you remove this file manually. Another… /usr/share/mysql/english/errmsg.sys The file does exist so “can’t find messagefile” error message is misleading to say the least…
Post: How would you compress your MySQL Backup
June 5, 2008 By 29 Comments
… the source server in additional to IO resources which may not be available, especially for CPU bound MySQL Load. The benefit in… note the serious leap in compressed file size. Though in this example we used MySQL binary log file which often contains plenty of… slower compression make sense because it takes longer to dump and much longer to load to the database anyway so overral compression impact is…
Post: MySQL 5.6 Compatible Percona XtraBackup 2.0.6 Released
March 20, 2013 By 2 Comments
… 20.[/caption] Percona is glad to announce the release of Percona XtraBackup 2.0.6 for MySQL 5.6 on March 20… dump files). Bugs Fixed: Individual InnoDB tablespaces with size less than 1MB were extended to 1MB on the backup prepare operation. This led to…’s tmpdir always being used for temporary files. Bug fixed #1085099 (Alexey Kopytov). XtraBackup for MySQL 5.6 has improved the error…
Post: Backing up binary log files with mysqlbinlog
January 18, 2012 By 2 Comments
… was that you had to do periodic filesystem level backups of the binary log files which could still lead to data loss depending… 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: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
…? Here are ten questions you need to be able to answer: Does the backup require shutting down MySQL? If not, what is the… “dump or file copy.” Sometimes they tell me to register and download a whitepaper that just has a bullet point “Support for MySQL Databases”. Or “I have to transfer you to the salesperson who covers your region” and I never get to talk to anyone…
Post: Announcing Percona Playback 0.5
November 26, 2012 By
…tcpdump –tcpdump-file=example.dump \ –tcpdump-mode=accurate –db-plugin=libmysqlclient –mysql-host=10.8.2.10 \ –mysql-username=root –mysql-password=passW0rd –mysql-schema=imdb…server needs further tuning or how it will be able to sustain production load. If you encounter any bugs, please report…
Comment: Wishes for mysqldump
May 22, 2007 By 19 Comments
… script starts dumping next table… (I think it could be really nice parallel dump and file-per-table implementation) 2) Safe dump… harder to implement, but I think it is possible. 3) Parallel restore: The same engine, but now it would feed dump files to mysql processes…
