So I think these are the only options, but if someone has another idea I'd be glad to hear it. Our current server just isn't handling the load anymore so, it has single processor....
Option 1:
Single server with dual processor and change from IDE to SCSI
Option 2:
One server with mysql on it, a second one to handle application (collecting and reporting on data)
Which do you think would be better?
Travis
I would do some more benchmarking to find out where your bottleneck is. You don't give any hardware specs, so it's hard to say...
Run 'top' and see how much CPU / memory is being used by each ( mysql and 'application' ).
If you CPU usage isn't high, maybe you would benefit from adding some more RAM. MySQL will run a LOT faster if all the tables can fit in RAM.
Also check out the options in my.cnf to see that you're actually using your resources. Maybe MySQL is limited by options in here?
Personally, I would go with a dual CPU system with PLENTY of RAM, and some SATA disks. But as I said, you may get away with just giving it more RAM.
-- Daniel Kasak IT Developer * NUS Consulting Group* Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
