Widgets

Percona Server(延伸自 MySQL)預設是沒有給 my.cnf 在 /etc/mysql 裡頭的。若有需要的話,可以依照主機資源狀況,從 /usr/share/mysql 拿一份過去用。(for Percona 5.5.24, Ubuntu 12.04)

參考文件:http://superuser.com/questions/426844/where-from-to-install-my-cnf-for-percona-db

其建議的資源參考值(只計算 Percona 本身所使用到的記憶體):
  1. my-innodb-heavy-4G.cnf (apporpriate for 4GB+ memory installation with InnoDB and heavy queries)
  2. my-huge.cnf (appropriate for 2GB+ memory installation dedicated MySQL)
  3. my-large.cnf (appropriate for 512MB memory installations dedicated MySQL server)
  4. my-medium.cnf (appropriate for 128MB memory installations, small DB along with web server)
  5. my-small.cnf (appropriate for 64MB memory installation, sporadic use of the database)

0 Comments:

Post a Comment

 
Top