Mysql InnoDB + конвертация базы wordpress

отрывок из /etc/mysql/my.cnf (для vps с 512мб памяти) должен находится в разделе [mysqld]

#skip-innodb
innodb_buffer_pool_size = 64M
innodb_additional_mem_pool_size = 32M
innodb_log_file_size = 32M
innodb_log_buffer_size = 2M
innodb_flush_log_at_trx_commit = 0
innodb_thread_concurrency = 4
innodb_file_per_table = 1
innodb_open_files = 2048
innodb_doublewrite = 0
innodb_checksums = 0
innodb_flush_method = O_DIRECT

далее останавливаем mysql и удаляем старые лог файлы

/etc/init.d/mysql stop
rm -rf /var/log/mysql/ib_logfile*

запускаем mysql

/etc/init.d/mysql start

открываем phpmyadmin
идём в базу блога (к примеру blog или wordpress) жмём на "SQL"
вставляем

alter table wp_users engine=innodb;
alter table wp_usermeta engine=innodb;
alter table wp_term_taxonomy engine=innodb;
alter table wp_term_relationships engine=innodb;
alter table wp_terms engine=innodb;
alter table wp_posts engine=innodb;
alter table wp_postmeta engine=innodb;
alter table wp_options engine=innodb;
alter table wp_links engine=innodb;
alter table wp_comments engine=innodb;
alter table wp_commentmeta engine=innodb;

жмём OK и вуаля :)

P.S. многое взято из гугля, вроде работает, если будут глюки не кричать :)

P.P.S. список для gallery2

alter table g2_AccessMap engine=innodb;
alter table g2_AccessSubscriberMap engine=innodb;
alter table g2_AlbumItem engine=innodb;
alter table g2_AnimationItem engine=innodb;
alter table g2_CacheMap engine=innodb;
alter table g2_ChildEntity engine=innodb;
alter table g2_Comment engine=innodb;
alter table g2_CustomFieldMap engine=innodb;
alter table g2_DataItem engine=innodb;
alter table g2_Derivative engine=innodb;
alter table g2_DerivativeImage engine=innodb;
alter table g2_DerivativePrefsMap engine=innodb;
alter table g2_DescendentCountsMap engine=innodb;
alter table g2_Entity engine=innodb;
alter table g2_EventLogMap engine=innodb;
alter table g2_ExifPropertiesMap engine=innodb;
alter table g2_ExternalIdMap engine=innodb;
alter table g2_FactoryMap engine=innodb;
alter table g2_FailedLoginsMap engine=innodb;
alter table g2_FileSystemEntity engine=innodb;
alter table g2_G1MigrateMap engine=innodb;
alter table g2_Getid3PropsMap engine=innodb;
alter table g2_Group engine=innodb;
alter table g2_ImageBlockCacheMap engine=innodb;
alter table g2_ImageBlockDisabledMap engine=innodb;
alter table g2_Item engine=innodb;
alter table g2_ItemAttributesMap engine=innodb;
alter table g2_ItemHiddenMap engine=innodb;
alter table g2_LinkItem engine=innodb;
alter table g2_Lock engine=innodb;
alter table g2_MaintenanceMap engine=innodb;
alter table g2_MimeTypeMap engine=innodb;
alter table g2_MovieItem engine=innodb;
alter table g2_MultiLangItemMap engine=innodb;
alter table g2_PendingUser engine=innodb;
alter table g2_PermalinksMap engine=innodb;
alter table g2_PermissionSetMap engine=innodb;
alter table g2_PhotoItem engine=innodb;
alter table g2_PluginMap engine=innodb;
alter table g2_PluginPackageMap engine=innodb;
alter table g2_PluginParameterMap engine=innodb;
alter table g2_QuotasMap engine=innodb;
alter table g2_RatingCacheMap engine=innodb;
alter table g2_RatingMap engine=innodb;
alter table g2_RecoverPasswordMap engine=innodb;
alter table g2_RssMap engine=innodb;
alter table g2_Schema engine=innodb;
alter table g2_SequenceEventLog engine=innodb;
alter table g2_SequenceId engine=innodb;
alter table g2_SequenceLock engine=innodb;
alter table g2_SessionMap engine=innodb;
alter table g2_SubscriptionMap engine=innodb;
alter table g2_ThumbnailImage engine=innodb;
alter table g2_TkOperatnMap engine=innodb;
alter table g2_TkOperatnMimeTypeMap engine=innodb;
alter table g2_TkOperatnParameterMap engine=innodb;
alter table g2_TkPropertyMap engine=innodb;
alter table g2_TkPropertyMimeTypeMap engine=innodb;
alter table g2_UnknownItem engine=innodb;
alter table g2_User engine=innodb;
alter table g2_UserGroupMap engine=innodb;
alter table g2_WatermarkImage engine=innodb;
alter table g2_WebDavLockMap engine=innodb;