N
noworyz
Guest
I am working on getting the VPS I have being setup to best performance and I have seen a lot of talk about changing the my.cnf file for mysql as this seems to be the major performance issue I am having.
Here is the my.cnf for my server which is the default that came with it (except for the slow queries.
Does anyone know what I should do to this file to better the server or know of any resources to tell me what settings to do?
My server specs are:
CPU: AuthenticAMD, Dual-Core AMD Opteron(tm) Processor 2212
Version: psa v8.1.1_build81070423.15 os_FedoraCore 6
OS: Linux 2.6.9-023stab043.1-smp
HD: 25GB Hard Drive Space (3GB Used)
RAM: 1GB Total (about 280 MB used)
Here is the my.cnf file
Here is the my.cnf for my server which is the default that came with it (except for the slow queries.
Does anyone know what I should do to this file to better the server or know of any resources to tell me what settings to do?
My server specs are:
CPU: AuthenticAMD, Dual-Core AMD Opteron(tm) Processor 2212
Version: psa v8.1.1_build81070423.15 os_FedoraCore 6
OS: Linux 2.6.9-023stab043.1-smp
HD: 25GB Hard Drive Space (3GB Used)
RAM: 1GB Total (about 280 MB used)
Here is the my.cnf file
Code:
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
skip-bdb
set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
log-slow-queries = slow_queries.log
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
skip-bdb
set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2