我对这个主题进行了一些搜索并找到了一些结果。然而,我正在寻找是否有人知道或可以向我指出一些真实或有信誉的案例研究,这些案例研究详细说明了从 MyISAM 迁移到 InnoDB 的好处(特别是性能)。
如果您能指出任何有关 MySQL 5.5 及以上版本(以 InnoDb 作为默认存储引擎)的信息,那就太好了。
这个问题实际上在 DBA StackExchange 中得到了很好的解决
https://dba.stackexchange.com/questions/1/what-are-the-main-differences- Between-innodb-and-myisam https://dba.stackexchange.com/questions/1/what-are-the-main-differences-between-innodb-and-myisam
https://dba.stackexchange.com/questions/194/how-do-you-tune-mysql-for-a-heavy-innodb-workload https://dba.stackexchange.com/questions/194/how-do-you-tune-mysql-for-a-heavy-innodb-workload
https://dba.stackexchange.com/questions/2885/should-i-move-to-innodb-during-a-planned-migration https://dba.stackexchange.com/questions/2885/should-i-move-to-innodb-during-a-planned-migration
https://dba.stackexchange.com/questions/5119/convert-table-from-myisam-to-innodb-without-downtime https://dba.stackexchange.com/questions/5119/convert-table-from-myisam-to-innodb-without-downtime
在我作为 MySQL DBA 的这些年里,我亲自将数十个 MySQL 数据库转换为我雇主的 http://www.logicworks.net/Solutions/Managed-Database WordPress https://wordpress.stackexchange.com/questions/199/steps-to-optimize-wordpress-in-regard-to-server-load/14880#14880 and Drupal https://drupal.stackexchange.com/questions/4753/how-to-convert-a-database-from-myisam-to-innodb/4794#4794客户。直接的好处是消除了高读、高写环境中的表锁定问题。
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)