1 adamsweb Dec 08, 2005 15:31
Okay, my blog has been turned off by my server because they tell me that there's a problem with my MySQL database. Here's the latest message:
From: MySiteSpace Support Team
Reply Time: 12/8/2005 7:28:31 AM
Reply: Hello Adam ,
We have checked your account for the domain adamsweb.us. It is found that your database is been creating heavy load on the server, we sugest you to delete unwanted record from your database adamsweb_b21 also sugest you that to optimize the database and fine query the database so that the records are featch more quickly and processed. Following is the report of it.
+-----+--------------+-----------+--------------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+--------------+-----------+--------------+---------+------+-------+------------------+
| 363 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 1435 | | |
| 366 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 1415 | | |
| 371 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 1403 | | |
| 373 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 1395 | | |
| 378 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 1354 | | |
| 379 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 1351 | | |
| 380 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 1351 | | |
| 396 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 1312 | | |
| 413 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 1288 | | |
| 420 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 1274 | | |
| 430 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 1255 | | |
| 481 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 1188 | | |
| 538 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 1102 | | |
| 570 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 1057 | | |
| 576 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 1046 | | |
| 597 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 1008 | | |
| 598 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 1001 | | |
| 600 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 992 | | |
| 609 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 983 | | |
| 631 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 945 | | |
| 642 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 928 | | |
| 643 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 926 | | |
| 646 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 921 | | |
| 658 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 897 | | |
| 665 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 887 | | |
| 679 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 858 | | |
| 682 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 847 | | |
| 694 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 833 | | |
| 712 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 805 | | |
| 728 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 783 | | |
| 743 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 761 | | |
| 763 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 735 | | |
| 767 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 730 | | |
| 772 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 726 | | |
| 788 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 694 | | |
| 793 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 689 | | |
| 805 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 660 | | |
| 810 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 651 | | |
| 811 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 650 | | |
| 815 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 632 | | |
| 817 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 627 | | |
| 818 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 621 | | |
| 819 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 620 | | |
| 825 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 608 | | |
| 828 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 582 | | |
| 830 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 571 | | |
| 837 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 541 | | |
| 841 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 532 | | |
| 848 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 497 | | |
| 849 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 493 | | |
| 850 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 483 | | |
| 852 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 481 | | |
| 854 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 460 | | |
| 857 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 451 | | |
| 858 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 447 | | |
| 868 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 387 | | |
| 871 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 374 | | |
| 878 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 342 | | |
| 899 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 200 | | |
| 904 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 151 | | |
| 919 | adamsweb_b21 | localhost | adamsweb_b21 | Sleep | 13 | | |
Is there a reasonable way I can edit my MySQL database without destroying my blog? How do I determine what's causing the problem? Or should I just switch hosting companies? I should mention that on average, my blog gets about 140 visitors per day (or it did before they started pulling this garbage.) and I've got about twelve hundred entries and to me that shouldn't cause a pull on the server.
3 adamsweb Dec 08, 2005 23:46
Apparently I installed a new version, 3 weeks before the latest came out. I'll try that and if it doesn't work, I'll dump my current provider unless someone knows how to troubleshoot this. Thanks for the suggestion.
Are you running version 0.9.1 "Dawn"? If not, upgrade to it. It should dramatically increase DB performance.