…/my.cnf –pid-file=/var/run/mysqld/mysqld.pid –log-error=/var/log/mysqld.log mysql 3172 3137 78 Nov19 ? 1-11:17:30…, I explain the meaning of the output, so it’s clear what I’m showing them. Then, I go through it… a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to get more information than the slow log gives us…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
…MySQL Development is done by different team working on the different components, while MySQL was not designed to be very modular with clear…MySQL Enterprise it is customers who got the bleeding edge code and for community the binary…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
…tables and indexes (with their IDs) to the error log. mysql (employees) > CREATE TABLE innodb_table_monitor (id int) … is the data so the next step is clear, extract the rows from it. To accomplish this … from an ibd file if you have a binary backup. Just use constraint_parser without the -D option…
Comment: Why MySQL's binlog-do-db option is dangerous
May 14, 2009 By 15 Comments
Which is why this behaviour is very clearly documented in the MySQL manual for this setting. http://dev.mysql.com/doc/refman/5.0/en/replication-options-binary-log.html
Post: Innodb Recovery Update - The tricks what failed.
May 24, 2007 By 3 Comments
… mean all sorts of different things: Versions later than MySQL 5.0.33 are not frequently used True many … corruptions and a lot of assertions most bugs were cleared out. People finding the bug do not report it … week old backup and running roll forward recovery using binary log can be a lot faster.
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… to have the patched MySQL installed in the system. Locate where the original mysqld binary is with: (garfield:~/work/mysql-5.0.51a… to enable slow logging (see Configuration section for details). Then rename the binary, which can be safely done even with MySQL still running…,filesort_on_disk†would be a proper flags set. To clear the filter just assign an empty string “” to this option…
