…_average innodb_file_per_table = true innodb_data_file_path = ibdata1:100M:autoextend innodb_flush_method = O_DIRECT innodb_log_buffer_size = 256M innodb_flush… #####plugin options innodb_read_io_threads = 16 innodb_write_io_threads = 4 innodb_io_capacity = 4000 innodb_use_native_aio=0 #not innodb options (fixed…_size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…: #####fixed innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method…_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… NOT the typical form of Eventual Consistency, known as asynchronous repair, that most people think of). Callaghan’s Law But what… applying Callaghan’s law to single-server Innodb, we’d get: [On a single node Innodb server] a given row can’t… your hotspots were really bad in standalone Innodb, you might consider relaxing the fsync: set innodb_flush_log_at_trx_commit to…
Post: mysql_upgrade and Innodb Tables
May 14, 2010 By 8 Comments
… with “The storage engine for the table doesn’t support repair” error message. This seems to confuse a lot of people…. Another solution is to simply run ALTER TABLE tbl ENGINE=INNODB which will rebuild table with new MySQL version and normally… be fixed such a way. With Oracle intentions to make Innodb default storage engine in next MySQL release I’m hopeful…
Post: Magic Innodb Recovery self healing
May 22, 2007 By 2 Comments
… us – as it was not clustered index we always could repair table by running ALTER TABLE with limited impact to production… this particular corruption instance Innodb did not print table name in question), drop tables, restart Innodb without innodb_force_recovery and load them… to get lucky second time today. And Indeed Restarting Innodb with innodb_force_recovery=0 allowed it to start normally and I…
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… is Full Text Search indexes which are not supported for Innodb tables. So what can you do ? Leave Tables as MyISAM…. Use “Shadow” MyISAM Table You can keep main data in Innodb but build a “shadow” MyISAM table which is used for…
Post: Long PRIMARY KEY for Innodb tables
October 3, 2006 By 8 Comments
… and spoke a lot about using short PRIMARY KEYs with Innodb tables due to the fact all other key will refer…`,`thumb_width`,`thumb_height`) ) ENGINE=InnoDB; Why did I use this solution compared to others: Innodb Tables – This table is getting much… few close pages, saving IO dramatically. No recovery worries – checking/repairing large MyISAM tables in case of MySQL/System crash is…
Post: Recovering CREATE TABLE statement from .frm file
December 17, 2008 By 5 Comments
… test_innodb | CREATE TABLE `test_innodb` ( `a` int(11) DEFAULT NULL, `b` int(11) DEFAULT NULL ) ENGINE=InnoDB…| Op | Msg_type | Msg_text | +——————+——–+———-+———-+ | test.test_myisam | repair | status | OK | +——————+——–+———-+———-+ 1 row in set …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…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_threadsblogpercona…
Post: Small things are better
October 8, 2006 By 15 Comments
… in kernel log and filesystem needed to be checked and repaired even though it is journaling file system which should not… repairing took many hours especially as automatic check on boot failed and had to be manually restarted. Same may happen with Innodb… for example you need to add extra column to 500GB Innodb table. It will probably take long hours or even days…
