Categories
DATABASE JOB

Protected: dbs222 mysql innodb Troubleshutting

There is no excerpt because this is a protected post.

Categories
DATABASE JOB

Protected: mysql innodb 的部份參數 , my.cnf

There is no excerpt because this is a protected post.

Categories
DATABASE JOB

解決 mysql innodb 效能問題方法之一

可以用 Using Per-Table Tablespaces : http://dev.mysql.com/doc/refman/5.1/en/multiple-tablespaces.html Store each InnoDB table and its indexes in its own file. This feature is called “multiple tablespaces” because in effect each table has its own tablespace. Using multiple tablespaces can be beneficial to users who want to move specific tables to separate physical disks or who wish to restore […]