Игорь Олемской — практические заметки по системному администрированию Linux CentOS

Recently I was in need to convert all databases of a MySQL server from MyISAM engine to InnoDB. They are facing severe issues due to table level locking in MyISAM and wanted move to InnoDB. This task can be a mammoth work but if you work little smarter, all you need to execute few statements [...]

Похожие записи:

1. Compile mysql 5.1 with innodb and optimize for heavy usage
2. Оптимизация MySQL InnoDB на высоких нагрузках
3. MySQL: The total number of locks exceeds the lock table size
4. MySQL: The total number of locks exceeds the lock table size
5. Простой бэкап MyISAM таблиц MySQL без остановки сервера