Hey, I have four servers here, all identical when it comes to the hardware as well as software (same installed packages). Two of the servers run absolutely beautifully, not a single problem, but the other two are plagues by insane load as soon as they start receiving traffic. The machines are all dual PIII 933, 1 GB RAM each and two 18GB 10k rpm SCSI drives. Two days ago, I reinstalled them freshly from our old custom distribution to RH 7.3 (yes, I know ;)). Like I said, they have the exact same packages installed, and the only thing that really differs is hostname settings in config-files. The machines are running apache 1.3.26 w/ PHP 4.2.2 against MySQL 3.23.49a. When the two plagued machines accept traffic, temporary tables are created in /tmp/ (Filenames such as #sqld65_3_0.MYD, #sqld65_3_0.MYI, #sqld65_4_0.MYD, #sqld65_4_0.MYI) They are correctly removed after execution of the queries though, but since they are being written to disk, that’s a major bottleneck. The confusing thing is how two of the machines seem to be running it like it should (in memory), but the other two don’t. I have tried setting SQL_BIG_TABLES to 0, as well as increasing tmp_table_size. The temporary files created in /tmp/ “only” become 2-5 Mb, and with a tmp_table_size of 64Mb, that *really* shouldn’t be an issue IMO. Has anyone bumped into this problem before, or does anyone have any suggestions as to what might be causing the problem? / Oscar Rylin
--------------------------------------------------------------------- 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
