最近遇到Gallery與資料庫問題整理

整理一下, 以免忘記...

1. InnoDB 跟 資料庫cache的實作關連, 如何設定?
ibdata1, ib_logfile0, ib_logfile1
ENGINE=MyISAM
ENGINE=InnoDB

2. MySQL資料庫如何轉postgress
http://phorum.study-area.org/viewtopic.php?t=9787
http://www.pgsql.com/download/
http://www.omnistarinc.com/~fonin/downloads.php#my2pg

3. DB使用經驗
http://blog.dragon2.net/archives/2005/10/24/228.php

4. InnoDB相關資料
High Performance MySQL Chapter 6: Server Performance Tuning
http://dev.mysql.com/books/hpmysql-excerpts/ch06.html

InnoDB Configuration
http://dev.mysql.com/doc/refman/5.0/en/innodb-configuration.html

Adding and Removing InnoDB Data and Log Files
http://dev.mysql.com/doc/refman/5.0/en/adding-and-removing.html

InnoDB Performance Tuning Tips
http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html