scuse the ignorance are u saying high cpu usage is better used on one query or better be freed up for other queries ? ram is always an issue as the queries get buffered
> Jonathan Hilgeman wrote: > >>Currently, I have a Celeron 1.2 Ghz server with 512 RAM, and I'm >>considering moving to a P4 2 Ghz with the same amount of RAM. I have a >>few specific tables with several million rows of data, and it takes >>quite a long time to process that data on my current server. Does >>anyone have a good idea of the type of performance increase I'd see if >>I moved to a P4 server? > > It's going to depend of in your queries are disk bound or processor > bound. Check the processor usage when a big query is running (and not > much else is running). > > If the CPU usage is at 80-100% the query is processor bound, so you'll > see some improvement (though I can't tell you how much, other than the > clock rate scaling). > > On the other hand, if the CPU usage is low, you are likely disk bound, > so a faster processor won't help much. It would be better to add RAM, > tune your queries or get faster disks (or all three) in this case. > > --Ware Adams > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]