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 ? S 12:04 0:00 /bin/sh
./bin/safe_mysqld -u mysql
mysql 129 0.0 1.1 51632 10208 ? S 12:04 0:00 _
/usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/local/mysq
mysql 131 0.0 1.1 51632 10208 ? S 12:04 0:00 _
/usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/local/
mysql 132 0.0 1.1 51632 10208 ? S 12:04 0:00 _
/usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo
mysql 133 0.0 1.1 51632 10208 ? S 12:04 0:00 _
/usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo
mysql 149 0.0 1.1 51632 10208 ? S 12:05 0:11 _
/usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo
mysql 152 0.0 1.1 51632 10208 ? S 12:06 0:09 _
/usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo
mysql 153 0.0 1.1 51632 10208 ? S 12:06 0:11 _
/usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo
mysql 154 0.0 1.1 51632 10208 ? S 12:06 0:10 _
/usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo
mysql 155 0.0 1.1 51632 10208 ? S 12:06 0:10 _
/usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo
mysql 156 0.0 1.1 51632 10208 ? D 12:06 0:10 _
/usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo
mysql 157 0.0 1.1 51632 10208 ? S 12:06 0:11 _
/usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo
mysql 158 0.0 1.1 51632 10208 ? S 12:06 0:10 _
/usr/local/mysql/bin/mysqld --defaults-extra-file=/usr/lo
mysql 159 0.0 1.1 51632 10208 ? D 12: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