Forenote: I have no wish to start an OS debate.
Hello,
Once I wiped this and tried Linux (both gentoo, with their patched-to-the-hilt 2.6.5 kernel, and Debian, with a stock 2.6.6 which had just been released by the time I installed) this figure jumped to 35,000 queries per second.
First of all congratulations on getting queries that fast. :)
I have a few questions if you have the time:
1) Are you using MyISAM tables? 2) How large is the table's row size? And the result size returned? 3) Are you sorting the results? 4) What percentage are selects and updates? 5) On average, how many rows are being returned for the query?
The following question is open to anyone.
Now I've been mulling over whether to get a dual processor machine at 4x the price of a single processor P4 3+ghz machine, or just get four P4 3+ghz machines (with hyperthreading) and replicate the data and use load balancing. I'll need to replicate the data eventually so why not use 4 machines instead of 1 expensive dual processor machine? The cost is about the same and I'll have redundancy. 99% of the activity will be reads and the writes can be batched back to the master database several minutes later.
Mike
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
