The fact that you have "several millions of rows" may indicate that you have an I/O problem, not CPU.. do some benchmarking. and perhaps the solution is going to (if not already) SCSI drives, or some kind of raid configuration (recommend raid 0+1)
Or if you want to keep costs low.. perhaps using mysql built in "virtual raid" feature where the database spans the database over multiple ide drives (ideally on different channels).. I've got several celeron servers with u160 scsi raid, and they smoke! good luck! On Wed, 6 Aug 2003, 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? > > I'm hoping to see a response like, "Oh yeah - I moved to a P4 from a Celeron > and operations that used to take 10 minutes now take 1 minute or less - all > because MySQL has special options to take full advantage of the P4's power." > Or something like that. <fingers crossed> > > - Jonathan > > > > -- > 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]
