Hello, I am going to switch my mysql server configuration, and
I’d like to know what do you think about this configuration.
I have 2 servers, one (apache2, php5) and the otherone mysql (mysql-server 5.0.38, last debian version).
The mysqlserver specifications are.
3 disks 72GB SAS 15,000 rpm RAID 5
2 Dual Core Intel® Xeon® (2.66GHz, 1333 FSB)
4GB DIMM PC2-5300 (I know… is too low ( )
All tables are Innodb, and database have arround 90M now, but it will grow exponentially. Now have the “standar” mysql configuration and I ll change for this one.
[client]port = 3306socket = /var/run/mysqld/mysqld.sock[mysqld]port = 3306bind-address = 192.168.1.2socket = /var/run/mysqld/mysqld.sockskip-lockingkey_buffer = 2048Mmax_allowed_packet = 2Mmax_connections = 800table_cache = 5600open_files_limit = 6000sort_buffer_size = 4Mread_buffer_size = 4Mread_rnd_buffer_size = 8Mthread_cache_size = 16query_cache_size = 32Mthread_concurrency = 8skip-name-resolvelog-bin=mysql-bininnodb_data_home_dir = /var/lib/mysql/innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextendinnodb_log_group_home_dir = /var/lib/mysql/innodb_log_arch_dir = /var/lib/mysql/innodb_buffer_pool_size = 2048Minnodb_additional_mem_pool_size = 20Minnodb_log_file_size = 500Minnodb_log_buffer_size = 8Minnodb_flush_log_at_trx_commit = 1innodb_lock_wait_timeout = 50[mysqldump]quickmax_allowed_packet = 16M[mysql]no-auto-rehash
Thanks !
Martin