… with monopolizing replication thread. For example if I need to delete old data instead of DELETE FROM TBL WHERE ts
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… to edit: /etc/mysql/my.cnf Also make sure that innodb_buffer_pool_size is for performance reasons set to x4… Baron recommend you to be on the safe / perfect side. innodb_log_file_size is always a fixed parameter and it… this blog a dynamic innodb log file RECREATE did NOT seem to work if you are going to delete the log files…
Comment: InnoDB's gap locks
May 7, 2012 By 14 Comments
… affected (0.00 sec) root@localhost:test 14:35:22>delete from t where i=25; Query OK, 1 row affected… came out my insert still be blocked. The SHOW ENGINE INNODB STATUS information as follow: —TRANSACTION 0 27638, ACTIVE 1207 sec…
Post: InnoDB's gap locks
March 27, 2012 By 14 Comments
…. They only occur if you do UPDATE or DELETE or SELECT FOR UPDATE. InnoDB provides REPEATABLE READ for read-only SELECT, but…? Is possible to detect those gap locks using SHOW ENGINE INNODB STATUS: —TRANSACTION 72C, ACTIVE 755 sec 4 lock struct(s… need to create locks to prevent that from happening. 2- innodb_locks_unsafe_for_binlog = 1. Disables the gap locks except…
Comment: InnoDB's gap locks
April 13, 2012 By 14 Comments
… NULL, `c` char(20) DEFAULT NULL, KEY `i` (`i`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 mysql> select * from t; +——+——–+ | i | c | +——+——–+ | 1… t; session2> start transaction; select * from t; I delete one row: session2> delete from t where i=1; session> commit; In session…
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
… Drizzle function HTTP JSON API (experimental) Some of the Percona InnoDB patches have been merged Since Drizzle 7.0 (which was… previous stable release is: 3891 files changed, 473733 insertions(+), 210435 deletions(-) The size of the Drizzle kernel (drizzled directory in the…
Comment: InnoDB's gap locks
April 6, 2012 By 14 Comments
….com/questions/15854/innodb-row-locking-how-to-implement/15864#15864. I haven’t tested it with INSERT/DELETEs, but it should…
Comment: InnoDB's gap locks
April 4, 2012 By 14 Comments
Andy, With READ COMMITTED InnoDB doesn’t take additional locks on the gap, improving the … this example with the following one using READ COMMITTED: session1> delete from t where i=25; Query OK, 1 row affected…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… have innodb-status-file option set in your my.cnf. This will make InnoDB to write the full status output into innodb_status… possibility is to create a special InnoDB table called innodb_monitor: CREATE TABLE innodb_monitor (a INT) ENGINE=InnoDB Creating it causes the full… InnoDB status is. You can also help yourself with lsof tool available for many platforms: garfield fd # lsof -c mysqld | grep deleted…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
…) > select i.INDEX_ID, i.NAME FROM INNODB_SYS_INDEXES as i INNER JOIN INNODB_SYS_TABLES as t USING(TABLE_ID… the error log. mysql (employees) > CREATE TABLE innodb_table_monitor (id int) ENGINE=InnoDB; TABLE: name employees/salaries, id 18, flags 1… recovered! 10008 has recovered his salary again 
Conclusion With InnoDB the deleted rows are not lost. You can recover them from the…
