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

How to quickly convert mysql databases from MyISAM to InnoDB (перепечатка)

Комментариев нет

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 без остановки сервера

Комментировать