List:General Discussion« Previous MessageNext Message »
From:jeetendra.ranjan Date:October 14 2009 10:21am
Subject:Req. suitable .cnf file for Server used by 2000 users daily
View as plain text  
Hi,
Will you plesae guide me ?
We are about to launch one website whose database is in MySQL. I am very exited about the
server setting specially about .cnf file.
I have below hardware and .cnf details. Will you please guide me is the .cnf file details
sufficient to support current hardware. 
Initially 2000 users will visit this site everyday.
 
Hardware and OS
*************
Operating System : Red Hat Fedora Core 8 
Processor  : Intel Core 2 Quad - 2.83 GHz, 
RAM  : 4 GB
Total Disk Space : 600 GB (300 GB usable) 
RAID  : RAID1 
Disk Drive(s) : 300 GB (Drive #1), 300 GB (Drive #2) 
Bandwidth Quota : 500 GB 
Firewall  : PIX 501 
Version     : 5.0.81-community-log          
Version_comment : MySQL Community Edition (GPL) 
Version Compile Machine : i686                          
Version Compile OS      : pc-linux-gnu                 
my.cnf details
***********
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
key_buffer = 16M
key_buffer_size=4M
sort_buffer_size=2M
query_cache_size=64M
log-bin
log_queries_not_using_indexes=1
long_query_time=1
log_slow_queries=slowQry.log
join_buffer_size=4M
max_connections=150
max_allowed_packet = 32M
table_cache = 256
net_buffer_length = 8K
read_buffer_size = 2M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 8M
thread_stack=5M
thread_cache_size=128M
connect_timeout=30
query_cache_limit=32M
log-error
# Comment the following if you are using InnoDB tables
innodb_data_home_dir = /var/lib/mysql/
innodb_data_file_path = ibdata1:10M:autoextend
innodb_log_group_home_dir = /var/lib/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 4M
innodb_additional_mem_pool_size = 2M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 16M
innodb_log_buffer_size = 8M
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Thanks in advance
Regards
Jeetendra Ranjan


Thread
Req. suitable .cnf file for Server used by 2000 users dailyjeetendra.ranjan14 Oct
  • Re: Req. suitable .cnf file for Server used by 2000 users dailyShawn Green14 Oct
    • Re: Re: Req. suitable .cnf file for Server used by 2000 usersdailyjeetendra.ranjan15 Oct
  • RE: Req. suitable .cnf file for Server used by 2000 users dailyGavin Towey15 Oct
    • Re: Req. suitable .cnf file for Server used by 2000 users dailyBruce Ferrell15 Oct
  • Re: Req. suitable .cnf file for Server used by 2000 usersdailyJeetendra Ranjan20 Oct
    • Re: Req. suitable .cnf file for Server used by 2000 users dailyBruce Ferrell20 Oct
  • Re: Req. suitable .cnf file for Server used by 2000 usersdailyJeetendra Ranjan28 Oct