…MySQL…innodb_change_bufferingblogpercona.commanual innodb_checksumsblogpercona.commanual innodb_commit_concurrencyblogpercona.commanual innodb_concurrency_ticketsblogpercona.commanual innodb_data_file_pathblogpercona.commanual Innodb_data_fsyncsblogpercona.commanual innodb…myisam_repair_…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… next point: Use InnoDB Assuming that you will use the stock MySQL server, InnoDB is usually your best…parts of partitioning, such as maintenance and repair commands, that essentially negate the benefits of… we improve here? Especially assuming that there are indexes other than the primary key, we can…
Post: MySQL Crash Recovery
July 30, 2006 By 26 Comments
…may issue different queries which may trigger check/repair running for many tables at onces, which… Innodb you also might with to use innodb-safe-binlog option in MySQL 4.1 so your Innodb…longer time on extreme load. Innodb statistics – Unlike MyISAM Innodb does not store index cardinality in tables, …
Comment: MySQL Server Memory Usage
September 1, 2006 By 18 Comments
… ’0′ ‘Com_create_function’, ’0′ ‘Com_create_index‘, ’0′ ‘Com_create_table’, ’31′ ‘Com_dealloc_…date’, ’0′ ‘Com_rename_table’, ’0′ ‘Com_repair‘, ’0′ ‘Com_replace’, ’20801587′ ‘Com_replace_select’, …innodb_log_group_home_dir=/var/log/mysql innodb_log_arch_dir=/var/log/mysql innodb_table_locks=0 innodb…
Post: Working with large data sets in MySQL
July 5, 2007 By 12 Comments
…learn when working with large data things in MySQL is patience and careful planning. Both of …and repair may take long hours (this is indeed one of the big reasons to use Innodb even…portion of Index BTREE (even MyISAM which builds “normal” indexes by sort builds primary key and unique indexes using …
Post: Magic Innodb Recovery self healing
May 22, 2007 By 2 Comments
… with Innodb, as it is limited to only one particular index on one particular table type it is likely to be Innodb bug… problems to us – as it was not clustered index we always could repair table by running ALTER TABLE with limited impact to… course we still hoped new MySQL release will have this Innodb bug fixed) until today we got MySQL to crash during recovery process…
Post: Long PRIMARY KEY for Innodb tables
October 3, 2006 By 8 Comments
…height`) ) ENGINE=InnoDB; Why did I use this solution compared to others: Innodb Tables – This table…for number of benefits – caching data and index in memory -so cached lookups are very …. No recovery worries – checking/repairing large MyISAM tables in case of MySQL/System crash is painful…
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
… move to Innodb. The reason of the move could be just desire for better data consistency guaranty or being bitten repairing multiple… Search indexes which are not supported for Innodb tables. So what can you do ? Leave Tables as MyISAM The beauty of MySQL storage… Innodb but build a “shadow” MyISAM table which is used for full text search. In certain cases you can just use MySQL…
Post: Using MyISAM in production
June 17, 2006 By 35 Comments
… of rows in tens of thousands tables) Innodb was better choice mainly because of thouse …repaired, each may allocate myisam_sort_buffer_size and MySQL could crash or go swapping. Second – table will be locked while repair… of row cache. MyISAM tables only have indexes cached in key_buffer while data …
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 4 Comments
…indexes that this version of the engine doesn’t support. See http://dev.mysql.com/doc/refman/5.1/en/innodb…
