…innodb_status_fileblogpercona.commanual innodb_strict_modeblogpercona.commanual innodb_support_xablogpercona.commanual innodb_sync_spin_loopsblogpercona.commanual innodb_table_locksblogpercona.commanual innodb_thread_concurrencyblogpercona.commanual innodb…repair…
Post: Long PRIMARY KEY for Innodb tables
October 3, 2006 By 8 Comments
…`,`thumb_width`,`thumb_height`) ) ENGINE=InnoDB; Why did I use this solution compared to others: Innodb Tables – This table is getting much more reads…, saving IO dramatically. No recovery worries – checking/repairing large MyISAM tables in case of MySQL/System crash is painful and great to be…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 4 Comments
…mysql:mysql * mysql> repair table test_myisam USE_FRM; +——————+——–+———-+———-+ | Table | Op | Msg_type | Msg_text | +——————+——–+———-+———-+ | test.test_myisam | repair…
Post: mysql_upgrade and Innodb Tables
May 14, 2010 By 7 Comments
… attempt to run REPAIR TABLE for them. This will fail with “The storage engine for the table doesn’t support repair” error message. This… simply run ALTER TABLE tbl ENGINE=INNODB which will rebuild table with new MySQL version and normally will fix issues identified by mysql_upgrade. You…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… InnoDB tables — don’t use GUIDs. Which brings me to my next point: Use InnoDB Assuming that you will use the stock MySQL… the cost of repairing huge MyISAM tables and taking downtime, I would not use MyISAM for anything but read-only tables when things… use InnoDB/XtraDB tables… Optimize For I/O It is pretty much inevitable: if you do this kind of data processing in MySQL…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
… – users may issue different queries which may trigger check/repair running for many tables at onces, which typically make system extremely slow… MySQL 5.0 XA is taking care of this synchronization. .frm Corruption – Few people know MySQL is not really ACID even with Innodb tables…
Post: 10+ Ways to Crash or Overload MySQL
November 13, 2007 By 20 Comments
… tables would be repaired at the same time. What if user uses all 100 of his allowed connections to ALTER 100 different tables… them using mysql_stmt_send_long_data call – Server buffers such data until you have executed prepared statement. Innodb Table Cache Leak – Innodb never shrinks its internal table cache (data dictionary) so by creating and accessing large amount of Innodb tables you can…
Post: Magic Innodb Recovery self healing
May 22, 2007 By 2 Comments
… index we always could repair table by running ALTER TABLE with limited impact to production system (as only one table of about a hundred…’t really recover data on per table basics. Also if MySQL crashes during recovery lower values of innodb_force_recovery normally would not… dump potentially corrupted tables (in this particular corruption instance Innodb did not print table name in question), drop tables, restart Innodb without innodb_force_recovery and…
Post: MySQL Server Memory Usage
May 17, 2006 By 18 Comments
… to MyISAM tables. myisam_sort_buffer_size used for ALTER TABLE, OPTIMIZE TABLE, REPAIR TABLE commands. For …memory consumption Innodb Table Cache. Innodb has its own table cache in which meta data about each table … tables. It also means user having CREATE TABLE privilege should be able to run MySQL …
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
… better data consistency guaranty or being bitten repairing multiple GB MyISAM table few times, though Table Locks is probably the most important issue… which are not supported for Innodb tables. So what can you do ? Leave Tables as MyISAM The beauty of MySQL storage engines is you…
