I think upgrading to 2.42 fixed it.

Nope. It broke after a couple of hours. I had to go to regular php5. Any ideas?

They're telling me that it's slow sql queries. Any ideas on how to fix it? I've already optimized and repaired tables.

Well hello there! You currently have 10 posts per page and (it seems) 292 pages. WOW! But that shouldn't be the big issue. I'm not really good at the details of what queries hit the server harder, but let's take a few smart guesses.

I *THINK* the "who's online" widget is kinda heavy on resources, so you might want to make it go away. Simply remove it, even though it does sort of show "look how many people read my blog" thus encouraging visitors that you have good stuff to say.

I *THINK* the calendar is another one that takes up more power than it delivers. True that it is a convenient little "graphical archive" tool, but then again it is quicker to use your "Archives" in the sidebar to find something you posted last year. So I would make that one go away.

MAYBE cutting down to 7 posts per page will help, but this one is a total guess that is probably very very insignificant.

3-pronged approach? Remove the calendar and the who's online widgets, then consider cutting the number of posts per page. Between them you might be able to reduce the load on your server. ALTERNATIVELY wait for someone smart to come along and say "run this special thing and let's see what's clocking in where" because smart people say that sort of thing.

Ed. It's great to hear from you! I cut out the ministat one and the widget to show posts on sidebar. The thing was working great until Bluehost did something to break the fast CGI.

I'll see how that works out.

Ah I didn't notice ministats. The author already noted that one doesn't cache so it is doing a lot of queries every time a page load happens. Dunno nothing about fast CGI though.

Make a copy of your blog in some /dev/ or /hack/ or /test/ or whatever folder and view the blog in debug mode. That will tell where the slow queries are.
You may also gain performance by generating static pages out of the main (first) page. You might set up a cron job doing that every ten or five minutes or manual after every (post) change.

Like EdB I'm not into fastCGI, do someone else may want to answer that question.
Blueyed is preparing version 3 of B2evolution with major improvements in database query performance. You may want to contact him. He might have some stuff ready and I think he'll be pleased to test on a busy server.

Good luck

OK. I'll do that. By the way, if I get rid of "who's online," can I bring it back as easily?

OK. I see it's a plugin so I'll just disable it.

Are there any stuff I can enter in php.ini?

Apache version 2.2.9 (Unix)
PHP version 4.4.9