Title: mrmuff's Replies | WordPress.org --- # mrmuff [ ](https://wordpress.org/support/users/mrmuff/) * [Profile](https://wordpress.org/support/users/mrmuff/) * [Topics Started](https://wordpress.org/support/users/mrmuff/topics/) * [Replies Created](https://wordpress.org/support/users/mrmuff/replies/) * [Reviews Written](https://wordpress.org/support/users/mrmuff/reviews/) * [Topics Replied To](https://wordpress.org/support/users/mrmuff/replied-to/) * [Engagements](https://wordpress.org/support/users/mrmuff/engagements/) * [Favorites](https://wordpress.org/support/users/mrmuff/favorites/) Search replies: ## Forum Replies Created Viewing 12 replies - 1 through 12 (of 12 total) * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [MySql problem?](https://wordpress.org/support/topic/mysql-problem-1-2-3/) * Thread Starter [mrmuff](https://wordpress.org/support/users/mrmuff/) * (@mrmuff) * [20 years, 7 months ago](https://wordpress.org/support/topic/mysql-problem-1-2-3/page/2/#post-269927) * 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](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [MySql problem?](https://wordpress.org/support/topic/mysql-problem-1-2-3/) * Thread Starter [mrmuff](https://wordpress.org/support/users/mrmuff/) * (@mrmuff) * [20 years, 7 months ago](https://wordpress.org/support/topic/mysql-problem-1-2-3/page/2/#post-269790) * 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](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [MySql problem?](https://wordpress.org/support/topic/mysql-problem-1-2-3/) * Thread Starter [mrmuff](https://wordpress.org/support/users/mrmuff/) * (@mrmuff) * [20 years, 7 months ago](https://wordpress.org/support/topic/mysql-problem-1-2-3/page/2/#post-269780) * … is my stupid habbit, sorry about that! * POOLS – [http://www.lesterchan.net/portfolio/programming.php](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](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [MySql problem?](https://wordpress.org/support/topic/mysql-problem-1-2-3/) * Thread Starter [mrmuff](https://wordpress.org/support/users/mrmuff/) * (@mrmuff) * [20 years, 7 months ago](https://wordpress.org/support/topic/mysql-problem-1-2-3/#post-269777) * 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](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [MySql problem?](https://wordpress.org/support/topic/mysql-problem-1-2-3/) * Thread Starter [mrmuff](https://wordpress.org/support/users/mrmuff/) * (@mrmuff) * [20 years, 7 months ago](https://wordpress.org/support/topic/mysql-problem-1-2-3/#post-269775) * Active plugins: pools, RSS fetched link list… * Forum: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [MySql problem?](https://wordpress.org/support/topic/mysql-problem-1-2-3/) * Thread Starter [mrmuff](https://wordpress.org/support/users/mrmuff/) * (@mrmuff) * [20 years, 7 months ago](https://wordpress.org/support/topic/mysql-problem-1-2-3/#post-269770) * 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](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [MySql problem?](https://wordpress.org/support/topic/mysql-problem-1-2-3/) * Thread Starter [mrmuff](https://wordpress.org/support/users/mrmuff/) * (@mrmuff) * [20 years, 7 months ago](https://wordpress.org/support/topic/mysql-problem-1-2-3/#post-269767) * 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](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [MySql problem?](https://wordpress.org/support/topic/mysql-problem-1-2-3/) * Thread Starter [mrmuff](https://wordpress.org/support/users/mrmuff/) * (@mrmuff) * [20 years, 7 months ago](https://wordpress.org/support/topic/mysql-problem-1-2-3/#post-269765) * 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](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [MySql problem?](https://wordpress.org/support/topic/mysql-problem-1-2-3/) * Thread Starter [mrmuff](https://wordpress.org/support/users/mrmuff/) * (@mrmuff) * [20 years, 7 months ago](https://wordpress.org/support/topic/mysql-problem-1-2-3/#post-269762) * 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](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [MySql problem?](https://wordpress.org/support/topic/mysql-problem-1-2-3/) * Thread Starter [mrmuff](https://wordpress.org/support/users/mrmuff/) * (@mrmuff) * [20 years, 7 months ago](https://wordpress.org/support/topic/mysql-problem-1-2-3/#post-269760) * 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](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [MySql problem?](https://wordpress.org/support/topic/mysql-problem-1-2-3/) * Thread Starter [mrmuff](https://wordpress.org/support/users/mrmuff/) * (@mrmuff) * [20 years, 7 months ago](https://wordpress.org/support/topic/mysql-problem-1-2-3/#post-269750) * 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](https://wordpress.org/support/forum/how-to-and-troubleshooting/) In reply to: [MySql problem?](https://wordpress.org/support/topic/mysql-problem-1-2-3/) * Thread Starter [mrmuff](https://wordpress.org/support/users/mrmuff/) * (@mrmuff) * [20 years, 7 months ago](https://wordpress.org/support/topic/mysql-problem-1-2-3/#post-269749) * Link: [http://www.purebeautyblog.com/](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)