I've gotten some weird responses to this type of question before, but I'd like some input anyway. We are getting a new dedicated database server. Currently our load average is hovering above 2 and although things work fine, that snappiness is fading as the load becomes higher. We may be able to squeeze some more speed out of the current machine, but we are interested in making a redundant setup anyway, so a new machine it is.
Currently, we have a dual 1.3 Ghz PIII processor machine with raid 1 scsi160 drives on Linux 2.4.7-10smp with 1GB RAM running 3.23.49a-Max on an ext3 partition. I feel that there are three problems. High load in general, not the best filesystem for the job, and the fact that there is only one raid1 diskspace. This is my solution: dual Xeon 2.8 GHz, 2GB RAM, 1 RAID 1 partition (2 disks) for the OS, 1 RAID5 partition (3disks) for the db. Then, what I would like to get some feedback on is whether to use a raw partition or what filesystem. Although ext3 is slow, I have actually had somebody unplug the database machine, plug it back in, and when it rebooted, everything worked fine and there was no corruption. I think I have to thank ext3 for that. If the raw partition cannot handle that, then I am not interested in using it. Any comments are greatly appreciated. Does anybody have 300 queries per second or more? What kind of hardware do you have? This is top now: 11:56am up 22 days, 2:07, 1 user, load average: 4.22, 3.64, 3.25 100 processes: 96 sleeping, 4 running, 0 zombie, 0 stopped CPU0 states: 93.4% user, 6.2% system, 0.0% nice, 0.0% idle CPU1 states: 90.2% user, 9.4% system, 0.0% nice, 0.0% idle Mem: 1028432K av, 1020672K used, 7760K free, 0K shrd, 53612K buff Swap: 522104K av, 33328K used, 488776K free 364720K cached PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND 4434 mysql 17 0 441M 409M 2744 R 35.3 40.7 901:02 mysqld-max 4470 mysql 9 0 441M 409M 2744 S 21.0 40.7 61:07 mysqld-max 4462 mysql 17 0 441M 409M 2744 S 20.2 40.7 63:07 mysqld-max 4463 mysql 9 0 441M 409M 2744 S 20.2 40.7 65:34 mysqld-max 4449 mysql 15 0 441M 409M 2744 R 19.3 40.7 66:47 mysqld-max 18483 mysql 10 0 441M 409M 2744 S 19.1 40.7 103:58 mysqld-max 4437 mysql 14 0 441M 409M 2744 S 14.8 40.7 64:52 mysqld-max 4444 mysql 9 0 441M 409M 2744 S 11.0 40.7 65:39 mysqld-max 4450 mysql 16 0 441M 409M 2744 S 10.1 40.7 65:14 mysqld-max 8776 adam 15 0 988 988 764 R 7.2 0.0 0:03 top 4001 mysql 9 0 441M 409M 2744 S 6.6 40.7 79:12 mysqld-max 18580 mysql 9 0 441M 409M 2744 S 4.9 40.7 101:26 mysqld-max 4467 mysql 9 0 441M 409M 2744 S 4.4 40.7 64:10 mysqld-max 18577 mysql 13 0 441M 409M 2744 R 1.5 40.7 99:48 mysqld-max 4432 mysql 9 0 441M 409M 2744 S 0.3 40.7 66:15 mysqld-max 4458 mysql 9 0 441M 409M 2744 S 0.3 40.7 62:31 mysqld-max And mysqladmin status: Uptime: 1908444 Threads: 10 Questions: 268078040 Slow queries: 21540 Opens: 1098 Flush tables: 1 Open tables: 730 Queries per second avg: 140.469 And vmstat: procs memory swap io system cpu r b w swpd free buff cache si so bi bo in cs us sy id 2 0 0 33328 5104 53652 366912 0 0 3 6 6 2 4 1 4 --------------------------------------------------------------------- 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