…if the table is MyISAM there will be no rollback process so all the already updated rows can’t be recovered. This particular example is…
Post: Dynamic row format for MEMORY tables
September 6, 2011 By 5 Comments
… depending on MEMORY tables, they are no replacement for application-specific tests. We start by checking if there is any performance regression … important feature is missing from this release however: MyISAM tables are still used for temporary tables where the MEMORY tables with dynamic row …
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… about checksum failing CHECK TABLE says table is OK. This means You Can’t Trust CHECK TABLE in Innodb to be sure your tables are good. In… find exact number doing “binary search” Note even if you do not use MyISAM table but fetch data to the script instead make… in this example. Another hint – you may want to CHECK your MyISAM table you use for recovery after MySQL crashes to make sure…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… own view on using MyISAM in production. For me it is not only about table locks. Table locks is only one of MyISAM limitations you need… many hours to check recover our tables. If this happened make sure you have decent myisam_sort_buffer_size and large myisam_max_sort_file… even know you need to check MyISAM tables after crash and have been running for years survining many crashes. If you enable delay_key…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
… may have hidden dependencies of MyISAM table lock behavior in your applications, also check if your application handled deadlocks well. MyISAM will not produce deadlocks…(*) FROM TBL (with no where clause) which is very fast for MyISAM but does table/index scan for Innodb. Defaults You need to…
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
… times compression rate for this table which is heavily redundant (urls, referers, user agents etc) To check if this is fair compression rate I also… as I got this table by converting MyISAM table rather than incremental insertions. I also compared it to compressed MyISAM – this would take 1250MB…
Post: How much space does empty Innodb table take ?
December 16, 2008 By 7 Comments
…0.30 sec) Check out files (using Innodb File Per Table) -rw-rw…is pretty small. This is the good reason to avoid having very small Innodb tables – they will take much more space than MyISAM…if small tables are used The information in INFORMATION_SCHEMA can’t be used to judge how much space table is…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
… in the table) It is worth to note if you do ALTER TABLE Innodb, same as MyISAM will internally run analyze as soon as table is rebuilt… MyISAM have different stats computation method by default. Lets check how stats change for MyISAM if we change the stats computation method: mysql> set myisam…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
…Is MyISAM used as default or as a choice ? This is the most important question to ask upfront. Sometimes MyISAM is there just because it is…see significantly large table size (especially if data size is close to memory …for Innodb tables in particular for write intensive workloads. Check here for …
Post: Using CHAR keys for joins, how much is the overhead ?
June 18, 2007 By 18 Comments
… 3.5 seconds which is just 20% slower than integer based join for Innodb. Finally I decided to check if using longer strings… of times for Innodb tables MyISAM Tables may suffer significantly if key compression is not disabled Joining on Shorter CHAR keys is significantly faster than Long…
