Hi Friends ,
I have huge WAP content database and it's included with wallpapers, ringtones,
games ...etc.That content database getting hits more that 1000 /sec. This is
actually massive.
My Webserver s are Tomcat and apache , because some applications written in
java and some are php . perl. Hence i needed to use that both wap servers.Due
high load for the content database ,it's getting hang/stuck/panic. I couldn't
even restart the mysql service. I have restart the machine , no any other way
to release the stucked load.
OS - RHEL : 2.6.9-42.0.3.ELsmp
MySql - 4.1.7
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords=1
#########################
flush
back_log=2000
connect_timeout=10
interactive_timeout=25
join_buffer_size=4M
key_buffer=1024M
max_allowed_packet=64M
max_connections=2000
max_connect_errors=100000
myisam_sort_buffer_size=256M
read_buffer_size=8M
read_rnd_buffer_size=8M
sort_buffer_size=8M
table_cache=4096
thread_cache_size=400
thread_concurrency=16
wait_timeout=50
query_cache_size=1024M
query_cache_limit=32M
query_cache_type=1
log=/var/log/mysqld_sql.log
log-error=/var/log/mysqld_error.log
#########################
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
Now , i have to think about any perfect load balancing method , i can't
duplicate the databse in another machine. It's directly conflict with serving
contents for each request.
can somebody help me on it ? what would be the perfect way to have a balance
the load ?
How can we take the statics of mysql databse ? is there any open source product
available ?
Thanx in advance,
Shaine.
---------------------------------
New Yahoo! Mail is the ultimate force in competitive emailing. Find out more
at the Yahoo! Mail Championships. Plus: play games and win prizes.
