…-mysql) Support for MyISAM, now changes to MyISAM tables are replicated to other nodes Improvements to XtraBackup SST methods, better error handling…
Comment: InnoDB's gap locks
May 7, 2012 By 14 Comments
…@localhost:test 14:35:54>insert into t values(29); ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction root@localhost:test 14:38:03>insert into t values(23); ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction root… lock struct(s), heap size 1216, 1 row lock(s) MySQL thread id 31929, query id 484616 localhost root update insert…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
May 16, 2012 By 94 Comments
… mysql plugin (ocf:heartbeat:mysql) doesn’t work, because since mysql 5.5 the statement “CHANGE MASTER TO MASTER_HOST=” ” will make an error… in his the last version on gitub. But in my MySQL – installation a “SHOW SLAVE STATUS” will ALWAYS produce a completely…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… /var/log/mysqld.log file which i believe is the error log you are talking about? 120502 11:50:41 [Note…: ready for connections. Version: ’5.0.95′ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution Also, I don’t see how MySQL could be using any other conf file other than /etc…
Comment: What to tune in MySQL Server after installation
April 28, 2012 By 116 Comments
…five employees then database is disconnected with my application. The error is given below. Because there are several queries with …at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.(MysqlIO.java:276) at com.mysql.jdbc.Connection.createNewIO…
Post: How to diagnose errors in the MySQL error log
March 26, 2012 By 4 Comments
… see questions about how to understand the nature of errors in MySQL‘s error log. Now, there is a lot of complexity to… 28 OS error code 28: No space left on device That’s the key to understanding what really happened. MySQL created a temporary table, using the MyISAM storage engine, and when the disk filled up, MyISAM got an error. Little…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
… session: transaction2 > START TRANSACTION; transaction2 > INSERT INTO t VALUES(26); ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction transaction2…/doc/refman/5.1/en/innodb-locks-set.html. Conclusion MySQL uses REPEATABLE READ as the default isolation level so it…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… # xtrabackup_55 –backup –innodb-file-per-table –target-dir=/mnt/mysql/export/ –tables=data # xtrabackup_55 –prepare –export –innodb-file-per-table –target-dir=/mnt/mysql/export ALTER TABLE data DISCARD TABLESPACE; # replace ibd with the… IMPORT TABLESPACE; After those being done i receive the following errors InnoDB: Import: The extended import of data is being started…
Comment: Emulating global transaction ID with pt-heartbeat
April 24, 2012 By 6 Comments
… about failover from intermediate slaves to master and knowing that mysql does not have a way match the transactions as ‘global… , exec_master_log_pos: 2399″ and ignore the duplicate key errors for some time untill replication catches up.This should work… even pointing to previous position and by ignoring duplicate key errors we are bringing the rows up to the same level…
Comment: How to diagnose errors in the MySQL error log
March 27, 2012 By 4 Comments
Is there any good reason why you need to use perror first instead of MySQL writing the error message into the log along with the error code?
