Tejaaa,
Open conf/_advanced.php and change the line that says

$debug = 0

and make it say

$debug = 1

Then view your pages to see if you can tell what part of the process is taking the most time. That could be a clue to where the resource problem might be. You can add a link here once that's done and have others take a look. Also, check your stats and see how many hits you're getting each day. It's possible that your blog is popular enough that your host can't handle it.

It looks like you're using around 1% of the server resources. If they can't handle that you may need to upgrade to a better host or even a dedicated server. Your hitcount will give us a good clue about this.

You should probably also consider upgrading to 1.9.3 or better yet the newly released 1.10. They'll both offer performance improvements.

Finally, can you give us an idea of your spam load? Your stats page will tell how many hits are blacklisted. And how many spam comments make it through? There are more effecient ways to handle spam than the blacklist.

If it helps to look at the site, the site URL is www.itejas.com

Thanks personman for the response. I did what you said to do (change the _conf file).

To answer your question, I have not been blogging on www.itejas.com for a long time now. I don't get any new comments either. The blog is there as is for a long time now.

Date XML Robots Browser Unknown Total
Del05/05/07 14 3 7 3 27
Del05/04/07 536 348 262 157 1303
Del05/03/07 619 355 286 235 1495
Del05/02/07 594 374 186 250 1404
Del05/01/07 605 281 113 170 1169
Del04/30/07 537 296 180 153 1166
Del04/29/07 517 529 181 176 1403
Del04/28/07 594 432 385 208 1619
Del04/27/07 587 378 280 301 1546
Del04/26/07 629 372 313 172 1486
Del04/25/07 617 535 300 141 1593
Del04/24/07 675 419 497 231 1822
Del04/23/07 1508 577 244 183 2512
Del04/22/07 732 1043 187 386 2348
Del04/21/07 698 466 536 251 1951
Del04/20/07 637 381 328 159 1505
Total 10099 6789 4285 3176 24349

Below is some data from Global hits page. I don't see much change in the performance after changing the code in the _conf file.

What other information can help to help you help me more? :)

Tejaaa

Tejaaa,
The debug code isn't meant to help performance. It outputs a bunch of useful debug information at the bottom of the page. Since you disabled it again, I can't see that information and have any hope of diagnosing the problem.

You're not getting enough hits for that to be a problem. I have an install that gets around 20,000 per day and it's on a shared hosting server and the host has never complained.

I did notice a few spam comments.

I still think that if they're complaining about 1%, then it's a crappy host. You may want to think about moving. You could try upgrading first, though.

Another option is YaBBa's forthcoming spam blocking utility:
http://www.innervisions.org.uk/babbles/2007/05/02/aprils_shower

Good luck,

Danny

Just out of interest, why do you serve up so many posts per page? I'm sure I counted 20...
Not sure what effect it would have on your server but they all have to rendered every time.

For sure drop the post count in half, upgrade to at least 1.9.3 (and 1.10 if you're feeling adventurous), and think about ditching the who's online block.

Also: plan on ditching the host. Whether you can make them happy or not, they're lame.

John and EdB thanks for the responses. I have followed your advice and dropped the post count on the page to 5 posts only.

I have upgraded to the latest Miami version. EdB you are right, I might have to drop Lunarpages and take my sites somewhere else. But the last thing I want to do right now is to change three Domains onto another hosting provider.

Do you guys have any recommended hosting providers?

But let me know if there is anything else I can try to bring down the resources without any significant damage to the blog performance.

Tejaaa

Re Hosting...
[URL=http://b2evolution.net/about/recommended-hosting-lamp-best-choices.php]Web hosting services: recommended hosts[/URL]

"Below are our top web hosting choices. These companies are not only great hosts for your blog/website. They also offer free automated installation of popular software — including, of course, b2evolution — as well as outstanding customer support!"

I'm going to move away from realwebhost and go with hostgator when my rwh time is up. I have no problem with rwh other than the space for the money. Both offer cpanel with fantastico, and both cost about the same, so why not go with the bigger storage and bandwidth values? Then again the other web has less traffic so maybe a resource hog like you would get yelled at by hostgator? ;) Seriously, you might want to look at both of those names and see if they seem good to you.

Back to you hogging up all the resources:

Do you have hotlink protection enabled? For me it was easy to turn on via cpanel. I forget exactly what option - probably something simple like "enable hotlink protection" just in case that's part of your problem. Seems to me your host didn't give you very much to go on, although it does seem to be in your php area where stuff is getting busy.

Also when was the last time you optimized your database? Are you okay with the idea of emptying your evo_hitlog table? Also the sessions table. Both of those can grow very big, so shrinking them might be in your best interests.

Do I understand correctly that you're running 3 domains on one hosting account? Like using add-on domains? If so that could be part of the problem. No single bit is the killer, but the combined weight of 3 domains might take a heavy toll.

Oh yeah are you running anything other than b2evolution? If so it's possible it's another program that's not playing nice with the available server power.

Also, and I only say this because who knows, but also is it possible someone is hogging space from you? Once a long time ago I saw a database via my phpmyadmin that simply wasn't mine. It was an ecommerce type of thing. I could edit it, but I couldn't delete it. Took me quite a while to get my host to recognize what the problem was because they just figured it was my database in there. It came back time and time again too. RWH really took care of me in that situation, but I don't know what they did to finally get rid of the bad thing. So you might want to poke around your files and databases to see if there is anything that doesn't seem like yours. Could be that someone else has found a way to use your space for their purposes.

I use dreamhost. We run a b2evolution install with about 20 blogs and over 10K hits per day, skins.b2evolution.net, plugins.b2evolution.net and about 20 other web sites. I've got unlimited databases and tons of HDD space. It's still shared hosting and not as fast or powerful as a dedicated server, but for the price you get a lot. No automated b2evo install, but I've always found it to be a pretty painless task. Check the prices at dreamhost.com and if you're interested, I'll give you a coupon code for some more discount.

EdB,
I already had "Hot Link" enabled within Cpanel. My domain and other three domains are already listed there.

I have never optimised the database. How do we go about doing it?

I have truncated all the records from both hitlog and session tables that you mentioned. I have reduced the size of database by 6 MB (that is what those tables took).

I have confirmed with Lunarpages and they said the stats are only for Itejas.com site and not anything else. Checked all other files and databases and they are all mine.

Anything else that I can try?

Tejaaa

Optimizing is pretty simple. In phpmyadmin select your database then click "select all" to get all the checkboxes next to the tables checked. Then from a dropdown box select "optimize".

Has your host noticed any reduction in load from the changes you've made?

Hi EdB, You are THE Man.

I think it did the trick and yes it did reduce the load. This is what my latest resource usage is according to them.

itejas2 itejas.com

CPU usage: 0.76
Memory usage: 0.53
MySQL usage: 0.0

Top Process %CPU 41.0 /usr/bin/php
Top Process %CPU 25.5 /usr/bin/php
Top Process %CPU 17.6 /usr/bin/php

I have optimised the tables and the size of the database is further reduced by .5 MB. The guys from Lunarpages are happy to move my sites to a production server in next 24 hours if the usage remains this low.

BTW: I had a look at Dreamhost and their plans do look great.

Tejaaa