#/etc/my.cnf

[mysql]
prompt=”\u:\d> ”
pager=more

#更多请参考：
http://www.mysqlab.net/docs/refman/en-5.1/page/mysql-commands.html

#将库中是myisam引擎的表转成innodb

select concat(‘alter table ‘, TABLE_SCHEMA, ‘.’, TABLE_NAME, ‘ engine=innodb;’) from information_schema.TABLES where ENGINE=’Myisam’ and TABLE_SCHEMA<>’mysql’ and TABLE_SCHEMA<>’information_schema’ into outfile ‘/tmp/ivan_alter.sql’ ;

source /tmp/ivan_alter.sql

#看都有哪些sql没走索引

set global log_queries_not_using_indexes=on;

# 临时提高innodb的性能，比如在raid卡电池没电的时候，风险自担。

set global innodb_flush_log_at_trx_commit = 2;

#……

Related posts:

1. [MySQL5.1] Master上批量将Myisam引擎转Innodb
2. Innodb如何查看剩余表空间？
3. Raid1+0 stripe size for MySQL InnoDB
4. MySQL 5.5 表分区功能增强
5. MySQL5.5与MySQL5.1 性能(比较)对比测试
6. update更新数字主键的时候可能导致主从(master/slave)复制中断