Apache2 Going To 100% Cpu Usage

Hi,

This is my development enviroment:

VMWare Instance

CPU: 2 cores, 2.4 GHz

RAM: 2GB

OS: Debian Squeeze

apache2 APC ON

MySQL (InnoDB 8M cache)

Here’s what happens:

We’ve just inserted test data to a table (3500 rows) and, when calling that data from a datatable in yii, we get an apache process consuming 100% CPU for over 30 seconds; just after that, the render is completed.

APC is working just fine according to my apc.php, all my MySQL tables are well indexed and I’m running out of ideas on what else to do; Is there anything I’m missing?

Ty all in advace,

John

Dear John,

Your query should be making apache to use 100% CPU. The below extension could help you to find SQL queries running time.

Extension URL : http://www.yiiframework.com/extension/yii-debug-toolbar/

Please let me if it helps

Kind Regards,

Paulraj

I hope you’re not trying to get 3500 rows at once.

Why?, what if i need that 3500 rows or more?
Is there any way to make it work?

Check if it’s a query or not first.