Hi all-- I'm running a PHP/Apache/MySQL web app on a server. Specs are:
Slackware Linux v8.0 Kernel 2.4.16 Dual Athlon MP 1.2 GHz processors on a Tyan S2460 Mobo 1 GB registered ecc ram I'm running MySQL 3.23.51-log, I believe, and it's the binary version for x86 supplied by MySQL. The problem I'm having is that under high load, (i.e. 250 connections to mysql server), it seems to just stop executing queries. Up to that point, it handles about 80 queries/sec. The mysql memory footprint grows to about 50 M, according to top. Then, for no apparent reason, it stops handling queries. vmstat shows that there are about 290 processes waiting for run time, although disk activity remains low. I have swap space set up on an independent drive (IDE, with UDMA2), and it's not using much of that anyhow. I've set my key_buffer to 196M, open_tables to 1000 (and /proc/sys/fs/file-max is at 4096), and reasonable defaults (from my-large.cnf) for pretty much everything else. I've analyzed all of my queries, and none of them seem to be slow. Some have using temporary and a few have using filesort, which i know is awful, but there's no reason it's going, going, going, dead. Any help would be greatly appreciated. Matthew Kahn ZipStream Computing, LLC --------------------------------------------------------------------- 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
