… than traditional MyISAM table locks. Let me start with some examples. First lets run SELECT Query: —TRANSACTION 12303, ACTIVE 26 sec mysql tables… the same rows. Now finally lets illustrate how MySQL and Innodb level locks play together with each other. To do this we can…
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
…_get_page(index)) InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you… hint – you may want to CHECK your MyISAM table you use for recovery after MySQL crashes to make sure indexes are not… to use higher innodb_force_recovery modes to block purging activity, insert buffer merge or recovery from transactional logs all together. Though the…
Post: MySQL Backup tools used by Percona Remote DBA for MySQL
March 13, 2013 By 8 Comments
… entire schema) was dropped accidentally Your InnoDB table was corrupt and mysql shuts down Your server or …: If you have a lot of non-transactional tables (i.e. myisam), use –rsync option. This will … your data from backup is another topic. Piecing together data after accidental data loss is one …
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
…be recommended transactional storage engine or just default storage engine will switch from MyISAM to Falcon… but there was nothing told about Innodb features, even ones such as page …together with a lot of other good stuff. Robin also showed some optimized improvements for subqueries in MySQL…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…data mining stock market transactions,” or whatever the …mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql…time to convert MyISAM tables to InnoDB. (But then again,…, because they are tightly bound together, and tweaking one …
Post: Beware of running ANALYZE in Production
September 2, 2008 By 10 Comments
… updates table statistics using index dives, unlike with MyISAM when it scans indexes holding table lock for… run short transactions it may not be the big deal but if you mix long reporting together with… are no reasons Innodb can’t do this without locks but in practice some old mysql design artifacts…
