… Linux Server release 5.2 (Tikanga) …–log-error=/var/log/mysqld.log mysql 3172 3137 78 Nov19 ? 1…fails, then you know from the error…to use a patched binary, we can use MySQL Proxy, packet sniffing, or other techniques to get more information than the slow log… need to really know how to write queries…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…MySQL 5…failed foreign key constraint: ———————— LATEST FOREIGN KEY ERROR…LOG — Log sequence number 84 3000620880 Log flushed up to 84 3000611265 Last checkpoint at 84 2939889199 0 pending log writes, 0 pending chkp writes 14073669 log…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…mysql-5.0.51a) % su root Password: First you should apply the changes to the database configuration, specifically you need to enable slow logging…logged while doing it only for every n-th of them thus limiting the number of writes to the log. Note: this feature will fail to…
Post: Percona Server 5.1.47-rel11.0
June 21, 2010 By 13 Comments
…log_warning_1592 option to disable logging of error code 1592. Added the –microseconds_in_slow_query_log option to use microsecond precision for the slow query log…fails to compile with CFLAGS=-DUNIV_DEBUG #569156 CentOS 5: mysql-server conflicts with MySQL…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
…system extremely slow and …to use innodb-safe-binlog option in MySQL 4.1 so your Innodb log and binary log are synchronized. In MySQL 5…MySQL to fail with wierd error messages. In MySQL 4.1…to MySQL Crash Recovery – Restoring data from backup, corrupted Innodb tablespace recovery etc but I should write…
