Percona's MySQL & InnoDB performance and scalability blog
… very big fan of MyISAM; I would argue that in most situations, any possible advantages to using MyISAM are far outweighed by… it configured. The second part will compare query results between MyISAM FTS and InnoDB FTS over the same data sets, and… 5.5.30 and MySQL 5.6.10 with no tuning whatsoever (with one exception that I’ll explain below) – the…
…’re looking for more details, check out detailed guide on tuning innodb buffer pool innodb_log_file_size – This depends on… check about tuning other options here or read one of our MySQL Presentations. Application tuning for Innodb Especially when coming from MyISAM background… have no changes done to application which was written keeping MyISAM tables in mind.
… twice and still cannot see any hints regarding my.cnf tuning, only some trolling on how bad “automated scripts” are and how superior the writer is into tuning my.cnf (but on the other hand perhaps the purpose… itself will start to use such things to better utilize myisam files (since today MySQL let the operating system use its…
… of cons to the table which are missing in MyISAM and vice-versa. MyISAM is like a dog and InnoDB is like… the benefits of MyISAM which includes consistently faster query speeds, tables which are easily maintained, is more easily tuned and a system that will run even when things aren’t quite right. My point is, MyISAM is still…
… but there are other things you need OS cache for – MyISAM tables (mysql database, temporary etc) will need it, .frm file… pressure. But what is more important Innodb algorithms are finely tuned with consideration what is in memory and what is on… for dedicated Innodb system. If you have fair amount of MyISAM, Archive, PBXT, Falcon or other storage engines then you will…
…’t have any specific recommandations for Zabbix, but general InnoDB tuning recommendations apply here, in large zabbix deployments, you may want…? Does xtrabackup works as a sst method for myisam? A: Yes, but for MyISAM xtrabackup is blocking, since it is backed up… while holding a lock using FLUSH TABLES WITH READ LOCK. MyISAM support is experimental. Apart from some very special, edge cases…
…, since I don;t know anything about your application. Perhaps MyISAM is the right choice. You’ve has a review by…. But you must remember that your application is probably tuned to work with MyISAM. Just as your application would not work well… they are *slower*. The reason is – because they’re safer. MyISAM‘s crashes are a show stopper for myself. 6. “…To…
… bulk_insert_buffer_size bytes of memory if done to MyISAM tables. myisam_sort_buffer_size used for ALTER TABLE, OPTIMIZE TABLE… should be able to run MySQL server out of memory MyISAM buffers. MyISAM may allocate buffer which is large enough to contain… own per thread or global memory allocations which are not tuned as buffers. Watch for these especially now with many storage…
… will not perform as good as MyISAM no questions… in particular if you tuned your applications for MyISAM for years. Innodb does not… good match for you or may be you just know MyISAM much better. I’m confident my general advice holds. You… 100 sites (as an example) use mostly Innodb vs Mostly MyISAM.
… because of row locking and no overhead as compare to MyIsam. I change 90% of my tables to innodb and currently… Innodb. Big table ie. users? comments? etc… i just compared MyIsam to Innodb while loading users from 145000 rows and found quite a significant speed gain from MyIsam. Will this be better once i tuned InnoDb settings? and add query cache? Thanks…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.