WordPress website going down. Is the database the issue?
-
Hi there,
I have a website with more than 10,000 visitors daily and more than 10,000 articles.
SQL database is less than 300MB. I am on a VPS server with wiredtree.
Lately the site is going down with an error establishing connection to the database.
My hosting reviewed the case and send me the following saying there was process copying to TMP.
Can someone help out?
| 13362 | joandaje_wiki | localhost | joandaje_wikinet | Query | 1 | Copying to tmp table | SELECT id, post_title, post_status, guid, COUNT(comment_post_ID) AS post_comment_count FROM wp_posts | [root@wikitonserver ~]# mysqladmin proc +-------+---------------+-----------+------------------+----------------+------+--------------------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+---------------+-----------+------------------+----------------+------+--------------------+------------------+ | 577 | eximstats | localhost | eximstats | Sleep | 28 | | | | 579 | DELAYED | localhost | eximstats | Delayed insert | 29 | Waiting for INSERT | | | 580 | DELAYED | localhost | eximstats | Delayed insert | 28 | Waiting for INSERT | | | 6730 | leechprotect | localhost | leechprotect | Sleep | 1246 | | | | 7371 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 1117 | | | | 8662 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 864 | | | | 8892 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 819 | | | | 9064 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 783 | | | | 9361 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 723 | | | | 9469 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 701 | | | | 9493 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 695 | | | | 9649 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 664 | | | | 9651 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 664 | | | | 9703 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 653 | | | | 9732 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 0 | | | | 11589 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 285 | | | | 12475 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 100 | | | | 12542 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 84 | | | | 12560 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 79 | | | | 12585 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 74 | | | | 12615 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 67 | | | | 12616 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 66 | | | | 12637 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 62 | | | | 12640 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 61 | | | | 12639 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 61 | | | | 12642 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 62 | | | | 12645 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 62 | | | | 12646 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 61 | | | | 12696 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 46 | | | | 12697 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 47 | | | | 12702 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 46 | | | | 12703 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 0 | | | | 12706 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 46 | | | | 12707 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 45 | | | | 12708 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 45 | | | | 12709 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 45 | | | | 12711 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 44 | | | | 12715 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 44 | | | | 12724 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 41 | | | | 12725 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 41 | | | | 12733 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 37 | | | | 12739 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 36 | | | | 12772 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 31 | | | | 12780 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 29 | | | | 12806 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 24 | | | | 12808 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 24 | | | | 12813 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 23 | | | | 12837 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 18 | | | | 12852 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 17 | | | | 12858 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 12 | | | | 12862 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 12 | | | | 12870 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 12 | | | | 12882 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 8 | | | | 12883 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 8 | | | | 12885 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 8 | | | | 12897 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 7 | | | | 12906 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 2 | | | | 12907 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 1 | | | | 12908 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 3 | | | | 12910 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 2 | | | | 12911 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 3 | | | | 12909 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 3 | | | | 12913 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 1 | | | | 12924 | joandaje_wiki | localhost | joandaje_wikinet | Sleep | 1 | | | | 12930 | root | localhost | | Query | 0 | | show processlist | +-------+---------------+-----------+------------------+----------------+------+--------------------+------------------+ PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 1698 mysql 15 0 679m 135m 4328 R 22.8 4.4 5:42.18 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/ 5694 joandaje 15 0 176m 29m 21m S 17.2 1.0 0:00.52 /usr/bin/php /home/joandaje/public_html/wikiton.net/index.php 32538 joandaje 15 0 176m 30m 21m S 13.9 1.0 0:00.72 /usr/bin/php /home/joandaje/public_html/wikiton.net/index.php 5238 joandaje 15 0 176m 30m 21m R 9.6 1.0 0:00.60 /usr/bin/php /home/joandaje/public_html/wikiton.net/index.php 5696 joandaje 17 0 174m 14m 7928 R 3.0 0.5 0:00.09 /usr/bin/php /home/joandaje/public_html/wikiton.net/index.php 5697 joandaje 18 0 175m 14m 7928 R 3.0 0.5 0:00.09 /usr/bin/php /home/joandaje/public_html/wikiton.net/index.php 5695 joandaje 16 0 173m 12m 7672 R 2.3 0.4 0:00.07 /usr/bin/php /home/joandaje/public_html/wikiton.net/index.php 5698 joandaje 17 0 173m 10m 5884 R 1.6 0.3 0:00.05 /usr/bin/php /home/joandaje/public_html/wikiton.net/index.php 5699 joandaje 17 0 173m 12m 7260 S 1.6 0.4 0:00.05 /usr/bin/php /home/joandaje/public_html/wikiton.net/index.php 5700 joandaje 17 0 173m 11m 6188 R 1.6 0.4 0:00.05 /usr/bin/php /home/joandaje/public_html/wikiton.net/index.php 5701 joandaje 17 0 173m 12m 7260 S 1.6 0.4 0:00.05 /usr/bin/php /home/joandaje/public_html/wikiton.net/index.php 5703 joandaje 17 0 173m 10m 5932 R 1.3 0.4 0:00.04 /usr/bin/php /home/joandaje/public_html/wikiton.net/index.php 5702 joandaje 17 0 27408 7236 4204 R 0.7 0.2 0:00.02 /usr/bin/php /home/joandaje/public_html/wikiton.net/index.php
- The topic ‘WordPress website going down. Is the database the issue?’ is closed to new replies.