Re: MySQL eats 100% CPU on a quad CPU system...

2004-08-16 Thread Cemal Dalar
It depends on lots of things. But as an estimate.. Probably you need to add some indexes.. Which type of queries you are using? which database type? Other things.. what about database size? maybe you need more RAM etc.. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer

Re: MySQL eats 100% CPU on a quad CPU system...

2004-08-16 Thread Justin Swanhart
Are you swapping? Check vmstat and iostat Are your queries optimized, are they doing full table scans? Enable the slow query log. On Mon, 16 Aug 2004 14:48:35 +0200, Fahr o Mavastradioz [EMAIL PROTECTED] wrote: Hello people, I'm currently configuring a quad CPU system as a standalone

RE: MySQL eats 100% CPU on a quad CPU system...

2004-08-16 Thread Tinley, Jeremy
To: [EMAIL PROTECTED] Subject: Re: MySQL eats 100% CPU on a quad CPU system... Are you swapping? Check vmstat and iostat Are your queries optimized, are they doing full table scans? Enable the slow query log. On Mon, 16 Aug 2004 14:48:35 +0200, Fahr o Mavastradioz [EMAIL PROTECTED] wrote: Hello