Forum Replies Created

Viewing 12 replies - 1 through 12 (of 12 total)
  • Forum: Fixing WordPress
    In reply to: MySql problem?
    Thread Starter mrmuff

    (@mrmuff)

    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

    Forum: Fixing WordPress
    In reply to: MySql problem?
    Thread Starter mrmuff

    (@mrmuff)

    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

    Forum: Fixing WordPress
    In reply to: MySql problem?
    Thread Starter mrmuff

    (@mrmuff)

    … 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.

    Forum: Fixing WordPress
    In reply to: MySql problem?
    Thread Starter mrmuff

    (@mrmuff)

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

    Forum: Fixing WordPress
    In reply to: MySql problem?
    Thread Starter mrmuff

    (@mrmuff)

    Active plugins: pools, RSS fetched link list…

    Forum: Fixing WordPress
    In reply to: MySql problem?
    Thread Starter mrmuff

    (@mrmuff)

    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]

    Forum: Fixing WordPress
    In reply to: MySql problem?
    Thread Starter mrmuff

    (@mrmuff)

    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

    Forum: Fixing WordPress
    In reply to: MySql problem?
    Thread Starter mrmuff

    (@mrmuff)

    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?

    Forum: Fixing WordPress
    In reply to: MySql problem?
    Thread Starter mrmuff

    (@mrmuff)

    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]

    Forum: Fixing WordPress
    In reply to: MySql problem?
    Thread Starter mrmuff

    (@mrmuff)

    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…

    Forum: Fixing WordPress
    In reply to: MySql problem?
    Thread Starter mrmuff

    (@mrmuff)

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

    Forum: Fixing WordPress
    In reply to: MySql problem?
    Thread Starter mrmuff

    (@mrmuff)

    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.

Viewing 12 replies - 1 through 12 (of 12 total)