Important CPU abuse from Php

Hi all,

I received an email from my host last night stating that the forum is putting to much pressure on the CPU and will suspended my account until it is fixed.

I only opened the site 12 hours before after transferring everything over from SMF

They have aggreed to let me in, if I keep the whole site offline so I can fix it but I have no idea on what to do?? I have 1600 members and only average about 40 people on at any time.

Any Ideas??

I am running version 1.0.9

when I run debug and access the forum, it says
30 queries logged & 414 legacy queries logged

Not sure if this helps?

Cheers

I got confirmation from the host today that it is the forum that is causing the problem

I updated to version 1.0.10 hoping that it would fix it but it is the same except for 1 less query

Anyone have any idea on what I should do?

First I think you should ask for real numbers to see this, also give us an URL if still operational.
You're first in having a problem like that, and we have users with big forums (over 400k threads and over 20k users...)
Coulld you share with us what your forum is about and how you use it?

I have had to take it offline and redirect all my user back over to my old site for the time being.

It is a fishing forum with 8 categories and 50 topics. It has just over 40000 posts and never has more than 40 people on at any time. I also had the whole forum closed to guests.

How many queries are normal? When I can get back in with my temp address I will copy the whole list. It looked as though there were multiple queries for each topic.

I just got in and got a copy of the debug



I can also email it if you like or post the whole lot here if need be?

Without sounding impatient, Anybody know whats wrong?

Yes, I do know. I have not merged all of my SQL optimizations and some queries are still very slow, especially if your MySQL server is using MyISAM tables (default). Number of queries has nothing to do with the speed -- it's the slow queries reading whole/most of the table that matters.

How large forum do you have?

It had 46000 posts, 4500 topics and 1500 members.

Is there anything I can do my end to optimize and speed up the queries or will it be in an updated version?

Just thinking, If I upgrade to 1.0.10 is it going to fix it or are there still some slow queries in that build?

Is there anyway I can measure it on my end or do I wait and see if the host comes back and tells me off