.om_merged Posted September 19, 2007 Share Posted September 19, 2007 Well I have just upgraded to mysql 5...Need some help with configuring the server here is my my.cnf I got a 1 GB RAM with 2.8 Ghz p4 operating Cent OS[mysqld] skip-locking max_connections=350 interactive_timeout=15 connect_timeout=15 key_buffer_size=128M join_buffer=1M record_buffer=1M sort_buffer_size=2M myisam_sort_buffer_size=32M table_cache=768 read_rnd_buffer_size=768K thread_cache_size=32 max_allowed_packet=16M max_connect_errors=10 read_buffer_size=1M wait_timeout=15 query_cache_limit=1M query_cache_size=16M query_cache_type=1 thread_concurrency=4 skip-innodb safe-show-database old-passwords = 1 [mysqldump] quick max_allowed_packet=16M [safe_mysqld] err-log=/var/log/mysqld.log pid-file=/var/lib/mysql/mysql.pid open_files_limit=8192 Link to comment Share on other sites More sharing options...
bfarber Posted September 20, 2007 Share Posted September 20, 2007 How much activity on the server? 1GB of RAM is low for a server, but if it's not overly active it shouldn't be a huge deal. Link to comment Share on other sites More sharing options...
.om_merged Posted September 20, 2007 Share Posted September 20, 2007 well we have two major sites running...they both have over 100 users on each at any one time...goes till 200-300 at times..maybe more..you think having a 2 GB RAM improve the performance dramatically...in a couple of months I was thinking of moving over to a dual xeon actually...but for now I need to manage with the current config. Link to comment Share on other sites More sharing options...
bfarber Posted September 21, 2007 Share Posted September 21, 2007 2GB is still low. I'd be looking at around 4GB If this server could be taking in 600 connections at once, it needs the memory to be able to handle it. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.