Thanx for the information , but i wanted to go for a long term plan and for a fixed solution. bcause little by little that load getting high. please need some mysql expertise help.
Thank you, Shaine. Ady Wicaksono <[EMAIL PROTECTED]> wrote: Hi Lee better you start to benchmark your system using tools like http://sysbench.sourceforge.net/ You will find out, what boundary you hit, if you hit max thread, reduce thread stack size but very careful on this stuff :) On 1/18/07, Shain Lee wrote: > 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. > --------------------------------- What kind of emailer are you? Find out today - get a free analysis of your email personality. Take the quiz at the Yahoo! Mail Championship.