MySQL Optimisation

uk_viper · 30 Jul 2006 at 11:23

ok just noticed my server was runnning with almost all ram used up, mostly by mysql, so can anyone provide me a mysql config that would make it use a lot less ram say 128-256, max connections 100

Thanks in advance

uk_viper · 30 Jul 2006 at 11:28

Code:

[mysqld]
safe-show-database
innodb_data_file_path=ibdata1:10M:autoextend
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

uk_viper · 30 Jul 2006 at 11:35

According to the system its using around 350-400 meg, this server hosts mostly websites with some very busy forums

uk_viper · 30 Jul 2006 at 11:49

looks like that would be the best option, should have some ram left lying around