mysql crashing under 100 user loads
I am having a problem with mysql. I am running a php web site that uses a (mysql Ver 11.15 Disturb 3.23.39 for pc-linux-gnu (i686))database. Whenever i get a load of about 100 simultaneous users, mysql begins to spawn D stat processes and the site dies. Everything works very well with smaller loads. I am running this on a Quad Proc HP LH4 with 1GB Ram (which isn't being touched much) running Slack ware 7.1 upgraded to kernel 2.4-efs Apache http/https any help would be greatly appreciated. here is a small sample of the spawned processes. root 104 0.0 0.0 1600 800 ?S12:04 0:00 /bin/sh ./bin/safe_mysqld -u mysql mysql 129 0.0 1.1 51632 10208 ? S12:04 0:00 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/local/mysq mysql 131 0.0 1.1 51632 10208 ? S12:04 0:00 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/local/ mysql 132 0.0 1.1 51632 10208 ? S12:04 0:00 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo mysql 133 0.0 1.1 51632 10208 ? S12:04 0:00 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo mysql 149 0.0 1.1 51632 10208 ? S12:05 0:11 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo mysql 152 0.0 1.1 51632 10208 ? S12:06 0:09 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo mysql 153 0.0 1.1 51632 10208 ? S12:06 0:11 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo mysql 154 0.0 1.1 51632 10208 ? S12:06 0:10 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo mysql 155 0.0 1.1 51632 10208 ? S12:06 0:10 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo mysql 156 0.0 1.1 51632 10208 ? D12:06 0:10 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo mysql 157 0.0 1.1 51632 10208 ? S12:06 0:11 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo mysql 158 0.0 1.1 51632 10208 ? S12:06 0:10 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo mysql 159 0.0 1.1 51632 10208 ? D12:06 0:11 _ /usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: What's the best os?
The server is a quad xeon lh4, it will host a web site written in php, and using a mysql database which holds 125,000 squ's and descriptions. The server's only job is to host this site. Thanks for the responce. dave freeman -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Friday, June 01, 2001 1:42 AM To: David Freeman Cc: [EMAIL PROTECTED] Subject: Re: What's the best os? On Fri, Jun 01, 2001 at 12:30:20AM -0400, David Freeman wrote: > I am putting together a new web server to serve our new web site. > We expect a-lot of traffic on this site, so we have purchased a HP > LH4 quad xeon 550 2mb cache server. The site will use the mysql > database to hold about 125,000 squ's with descriptions, and notes > for each squ. The web surfers will be searching through the > database frequently. > > My question is, what is the best OS for a heavy usage, > multi-processor mysql database driven web site. We could use almost > anything, but we would prefer to use a free OS such as freebsd or > Linux based OS. Since you mentioned multi-processor, I'd recommend Linux (2.4 with ReiserFS) or Solaris. FreeBSD won't let you take full advantage of both CPUs the way other OSes will. One thing that's not entirely clear, though, is whether your server is a database server only. Or do you plan on running Apache on it as well? If it's not a dedicated DB server, the multi-processor issue will become less important. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 6 days, processed 41,280,444 queries (73/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
What's the best os?
Hi group, I am putting together a new web server to serve our new web site. We expect a-lot of traffic on this site, so we have purchased a HP LH4 quad xeon 550 2mb cache server. The site will use the mysql database to hold about 125,000 squ's with descriptions, and notes for each squ. The web surfers will be searching through the database frequently. My question is, what is the best OS for a heavy usage, multi-processor mysql database driven web site. We could use almost anything, but we would prefer to use a free OS such as freebsd or Linux based OS. Any input would be greatly appreciated!! David Freeman www.prioritycomputers.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
