maxell6667

CentOS and Mysql 5.0.91

Please, somone? It is really important, beacause my site is crashing whole time.

I just want to ask, if anyone has other suggestions to my problem?

Really good admin, i’m working with just said:

“The problem is, that really nothing suggests why mysql freezes”.

Yesterday at 6pm a was watching my server load through “htop”. Server load was 1 and cpu use was very small. Suddenly mqsql crashed.

Do you guys now something about “freezing mysql”? Maybe in connection to wordpress?

I asked them about it and they said: its really weird but there is really nothing, which could suggest why DB is crashing ;(

Before i switched to dedicated server i was on vps. My hosting company said before i joined their vps, uptime on whole server was 150 days. After they put my site on vps whole server started to crash (of course database). So i had to switch to dedicated server, because other users complained.

Now, my own dedicated server was cofigured by 3 really experienced admins, so i don’t think mysql is somehow bad configured.

I really don’t know what to do ;(

Yes, i have my own dedicated server…

https://www.ovh.de/produkte/superplan_ssd.xml

I hope you guys can help me somehow, because this stupid problem is really frustrating.

Here are plugins, i’m using…

Akismet
All in One SEO Pack
Disable Check Comment Flood
Faster Image Insert
Google XML Sitemaps
Hotlink 2 Link
Page Links To
Popular Posts
Post-Plugin Library
SEO Friendly Images
Simple Tags
Smart Youtube
W3 Total Cache
WP-EMail
WP-PageNavi
WP-Polls
WP Content Filter

Any idea, which can cause the problem with database?

I’m using W3 Total Cache and Litespeed, and nothing helps.

I just want to change comments order in admin panel, just to remove some long spam comments I have more then 300.000 so it’s hard to find these long spam comments. I mean here…

https://mysite.com/wp-admin/edit-comments.php

I don’t want to change comments order on my blog itself, i’m mean under posts. Just in in admin panel, so i can delete few long spam comments.

Will your solution does exactly that (change comments order in wp-admin and keep normal order under posts)?

aha ?? It doesn’t change comments order under posts (i don’t want that)?

but i want to change it in admin panel so i can delete some of them, not on blog?

Hmm, any idea what should i do?