WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] MySql problem? (21 posts)

  1. MrMuff
    Member
    Posted 8 years ago #

    Hello,

    I've been using the wordpress for 3 months and everything has worked fine until now... Now, it seems that it overloads my server with MySql queries from time to time and the site loads up very slowly or not at all.

    My WordPress version is 1.5.2

    Does anybody know where the problem might be?

    Thank you!

  2. Mark (podz)
    Support Maven
    Posted 8 years ago #

    A link to your site would help.
    Has your host emailed you at all ?
    What plugins do you have running ?
    Who is your host ?

  3. MrMuff
    Member
    Posted 8 years ago #

    Link: http://www.purebeautyblog.com/ NSFW

    I have my own servers, never had problems with sites... even blog was running smoothly without problems until recently...

    Active plugins: page navigation, pools, RSS fetched link list...

    There are currently 932 posts and 35 comments, contained within 13 categories.

  4. MrMuff
    Member
    Posted 8 years ago #

    A few days ago it had between 12-13k visitors a day, not because of the problems it went to 10k daily :(

  5. Mark (podz)
    Support Maven
    Posted 8 years ago #

    You seem to be using the plugin that generates the 1,2,3,4,5 etc at the bottom of the page. Try disabling that - it has been reported to slow things down.
    I added the NSFW above.

  6. MrMuff
    Member
    Posted 8 years ago #

    what does NSFW mean? ok, I will try to disable that! At the moment, the server is also extremely slow, so we should find out if that helps soon!

    Disabling it right now...

  7. ifelse
    Member
    Posted 8 years ago #

    "what does NSFW means?"

    Not safe for work.

  8. MrMuff
    Member
    Posted 8 years ago #

    When I look at the report (SHOW PROCESS LIST) it seems that the blog sends too many MySql queries to the server and it causes the slowdown...

    [Moderated - code removed. We can't understand it]

  9. MrMuff
    Member
    Posted 8 years ago #

    I did reboot my server now and MySql was clean again... however, after a while another MySql query appeared and didn't kill itself... just the same as above... so it seems that some queries don't kill themselves and stay there and once there are too many (maybe they reach a limit), there is no more space for new queries and server slows down...

    anyone?

  10. MrMuff
    Member
    Posted 8 years ago #

    mysql> status
    --------------
    mysql Ver 14.7 Distrib 4.1.8a, for pc-linux-gnu (i686)

    Connection id: 2239
    Current database:
    Current user: xtoplist@localhost
    SSL: Not in use
    Current pager: stdout
    Using outfile: ''
    Using delimiter: ;
    Server version: 4.1.8a
    Protocol version: 10
    Connection: Localhost via UNIX socket
    Server characterset: latin1
    Db characterset: latin1
    Client characterset: latin1
    Conn. characterset: latin1
    UNIX socket: /tmp/mysql.sock
    Uptime: 31 min 58 sec

    Threads: 171 Questions: 85729 Slow queries: 1897 Opens: 151 Flush tables: 1 Open tables: 140 Queries per second avg: 44.697

  11. Mark (podz)
    Support Maven
    Posted 8 years ago #

    Please list all your plugins.
    When was it all last known to be good and what did you do since ?

  12. MrMuff
    Member
    Posted 8 years ago #

    I posted two posts, it was still OK, then I tried to browse categories, it seemed to work... then I tried to search for certain KW's and here the problem was... anyway, it's not just searching because last time I searched for something with no troubles...

    here is the PROCESS LIST after it happened... now, it's jammed!

    [Moderated - code removed. We can't understand it]

  13. Mark (podz)
    Support Maven
    Posted 8 years ago #

    Please list all your plugins.

  14. MrMuff
    Member
    Posted 8 years ago #

    Active plugins: pools, RSS fetched link list...

  15. MrMuff
    Member
    Posted 8 years ago #

    and I was also using page navigation, but it think that the problem wasn't in page navigation... now, page navigation is disabled!

  16. Mark (podz)
    Support Maven
    Posted 8 years ago #

    The ... implies there are more ?

    What is this 'pools' ?

  17. MrMuff
    Member
    Posted 8 years ago #

    ... is my stupid habbit, sorry about that!

    POOLS - http://www.lesterchan.net/portfolio/programming.php - WordPress 1.5 Poll

    ---

    now, it's down again :( and page navigation was disabled.

    can't that be because of the number of posts?
    -> There are currently 932 posts and 35 comments, contained within 13 categories.

  18. Mark (podz)
    Support Maven
    Posted 8 years ago #

    It's not posts/comments, and that plugin is fine.
    Your blog is loading fine for me now...

  19. MrMuff
    Member
    Posted 8 years ago #

    yep, because I rebooted my server again...

    I don't think it's because of plugins I use at all. I see all my trade partners using them too.

    Maybe it's just that when more people browse the site, MySql gets overloaded.

    This was when it happened last time:

    Threads: 171 Questions: 85729 Slow queries: 1897 Opens: 151 Flush tables: 1 Open tables: 140 Queries per second avg: 44.697

  20. whooami
    Member
    Posted 8 years ago #

    quite simply, all of your pastes look like a memory and configuration issues to me. Put some more memory in that box, and do some tweeking within Apache to accomodate the traffic, ie, mod_bandwidth, for starters (Yes i know that will not help mysql connections).

    Im sure you know your site is NOT the only adult site on that box, I easily found others.

    Lots of traffic means you need a good box with memory. Its that simple.

  21. MrMuff
    Member
    Posted 8 years ago #

    Hello guys,

    it seems that I found the problem... I totally forgot that I enabled compresion (had no clue it could be this) on my site a few days ago... I disabled it and site seems fine again!

    whooami: My server should be fast enough, I have 2GB of memory!

    Thanks for your time, I really appreciate it!

    Martin

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags