Over Loading in seconds

[TechPro]

I installed CentOS on my local server

12 GB RAM core i7

installed vbulletin and have the following problems:
1. When I start the server there are 100s of instert into queries by vbulletin which takes the load to 30 +.
2. named is unstable and keeps crashing every now and then.
3. Any tips to keep vbull stable as its a college project and needs to be on as much as possible (24/7)

I would really appreciate your help!

thanks for everything.

techpro

TechPro Reviewed by TechPro on 20th Apr 2011. Over Loading in seconds I installed CentOS on my local server 12 GB RAM core i7 installed vbulletin and have the following problems: 1. When I start the server there are 100s of instert into queries by vbulletin which takes the load to 30 +. 2. named is unstable and keeps crashing every now and then. 3. Any tips to keep vbull stable as its a college project and needs to be on as much as possible (24/7) I would really appreciate your help! Rating: 5

[Gh0st]

Something is not right if the load is that high, not really conversed with VB. Hopefully someone else can help you with this.

[vgnheart]

optimize sql, whats the size of db ?

[TechPro]

DB is that big at all , when I check mysql process list it shows be thread insert into queries taking a lot of load.

any optimizations you guys would recommend?

thanks

[Lock Down]

Try adding this to your my.cnf if it does not exist or changing the value to 1 if it does.

max_write_lock_count = 1

[pioneer_fawad]

use cache plugin

[Whoo]

As far as I remember webmin had/still has a default option to show you the running queries/the time they are running. From there you might be able to locate your issue further.

Also, fresh install and import the members/posts maybe?

[TechPro]

If this can help , get me some help from you guys

thanks for the replies!

+--------+--------------+-----------+--------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| Id     | User         | Host      | db           | Command | Time |  State        |  Info                                                                                                  |
+--------+--------------+-----------+--------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| 280379 | da_admin     | localhost | NULL         | Query   |    0 |  NULL         | show  processlist                                                                                      |
| 289081 | warez_forum1 | localhost | warez_forum | Query   |   10 |  Sending data | SELECT user.*,usertextfield.*,userfield.*, user.userid,  options,
                        IF(displaygroupid=0, user.usergr |
| 289087 | warez_forum1 | localhost | warez_forum | Query   |   10 | Locked       | UPDATE vb_user
                                                SET
                                                        lastvisit = lastactivity,
                                                        lastactivity = 1303444589
                                                WH |
| 289094 | warez_forum1 | localhost | warez_forum | Query   |    9 | Locked       | UPDATE vb_user AS user
                        SET lastpost = 1303444590
                        WHERE userid = 197726
                                AND lastpost < 130 |
| 289102 | warez_forum1 | localhost | warez_forum | Query   |    7 |  Sending data | SELECT user.*,usertextfield.*,userfield.*, user.userid,  options,
                        IF(displaygroupid=0, user.usergr |
| 289104 | warez_forum1 | localhost | warez_forum | Query   |    7 | Locked       | UPDATE vb_user
                                                SET lastactivity = 1303444592
                                                WHERE userid = 340284                      |
| 289107 | warez_forum1 | localhost | warez_forum | Query   |    5 | Locked       | UPDATE vb_user
                                                SET lastactivity = 1303444593
                                                WHERE userid = 211278                      |
| 289108 | warez_forum1 | localhost | warez_forum | Query   |    6 | Locked       | UPDATE vb_user
                                                SET lastactivity = 1303444593
                                                WHERE userid = 305049                      |
| 289112 | warez_forum1 | localhost | warez_forum | Query   |    5 | Locked       | UPDATE vb_user
                                                SET lastactivity = 1303444594
                                                WHERE userid = 360887                      |
| 289115 | warez_forum1 | localhost | warez_forum | Query   |    5 | Locked       | UPDATE vb_user
                                                SET lastactivity = 1303444594
                                                WHERE userid = 81681                       |
| 289121 | warez_forum1 | localhost | warez_forum | Query   |    2 | Locked       | UPDATE vb_user AS user
                        SET lastpost = 1303444595
                        WHERE userid = 384364
                                AND lastpost < 130 |
| 289122 | warez_forum1 | localhost | warez_forum | Query   |    4 |  Sending data | SELECT user.*,usertextfield.*,userfield.*, user.userid,  options,
                        IF(displaygroupid=0, user.usergr |
| 289126 | warez_forum1 | localhost | warez_forum | Query   |    3 | Locked       | UPDATE vb_user
                                                SET lastactivity = 1303444595
                                                WHERE userid = 366928                      |
| 289129 | warez_forum1 | localhost | warez_forum | Query   |    3 | Locked       | UPDATE vb_user
                                                SET lastactivity = 1303444596
                                                WHERE userid = 212993                      |
| 289131 | warez_forum1 | localhost | warez_forum | Query   |    3 | Locked       | UPDATE vb_user
                                                SET lastactivity = 1303444596
                                                WHERE userid = 366928
| 289133 | warez_forum1 | localhost | warez_forum | Query   |    3 | Locked
                                                SET lastactivity = 1303444596
                                                WHERE userid = 376324
| 289138 | warez_forum1 | localhost | warez_forum | Query   |    2 | Locked
                                                SET lastactivity = 1303444597
                                                WHERE userid = 143178
| 289140 | warez_forum1 | localhost | warez_forum | Query   |    2 | Locked
                                                SET lastactivity = 1303444597
                                                WHERE userid = 224736
| 289143 | warez_forum1 | localhost | warez_forum | Query   |    0 | Locked
                                                SET lastactivity = 1303444598
                                                WHERE userid = 172187
| 289154 | warez_forum1 | localhost | warez_forum | Sleep   |    0  |                                                                                                                      |
| 289155 | warez_forum1 | localhost | warez_forum | Sleep   |    0  |                                                                                                                      |
+--------+--------------+-----------+--------------+---------+------+----------                                                                                        --------------------+

[TechPro]

Another one under increasing loads:

+------+--------------+-----------+--------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
| Id   | User         | Host      | db           | Command | Time | State          | Info                                                                                                 |
+------+--------------+-----------+--------------+---------+------+----------------+------------------------------------------------------------------------------------------------------+
|  110 | warez_forum1 | localhost | warez_forum | Query   |  316 | Locked         | UPDATE vb_thread SET firstpostid = 4032224, lastpostid = 4032224 WHERE threadid = 2818629           |
|  278 | warez_forum1 | localhost | warez_forum | Query   |  315 | Sorting result | SELECT  thread.threadid,
                        thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpost |
|  284 | warez_forum1 | localhost | warez_forum | Query   |  315 | Sorting result | SELECT  thread.threadid,
                        thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpost |
|  307 | warez_forum1 | localhost | warez_forum | Query   |  313 | Sorting result | SELECT  thread.threadid,
                        thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpost |
|  319 | warez_forum1 | localhost | warez_forum | Query   |  309 | Sorting result | SELECT  thread.threadid,
                        thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpost |
|  391 | warez_forum1 | localhost | warez_forum | Query   |  292 | Sending data   | SELECT  thread.threadid,
                        thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpost |
|  823 | warez_forum1 | localhost | warez_forum | Query   |  202 | Sending data   | SELECT  thread.threadid,
                        thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpost |
|  907 | warez_forum1 | localhost | warez_forum | Query   |  187 | Locked         | INSERT INTO vb_thread
        (prefixid, postusername, postuserid, title, iconid, visible, forumid, datel |
| 1217 | warez_forum1 | localhost | warez_forum | Query   |  139 | Sorting result | SELECT  thread.threadid,
                        thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpost |
| 1263 | warez_forum1 | localhost | warez_forum | Query   |  135 | Sending data   | SELECT COUNT(*) AS threads,
          (
           SELECT COUNT(*) AS newthread
           FROM vb_thread AS thread
            |
| 1272 | warez_forum1 | localhost | warez_forum | Query   |  134 | Sorting result | SELECT  thread.threadid,
                        thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpost |
| 1307 | warez_forum1 | localhost | warez_forum | Query   |  130 | Sorting result | SELECT  thread.threadid,
                        thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpost |
| 1321 | warez_forum1 | localhost | warez_forum | Query   |  129 | Sorting result | SELECT  thread.threadid,
                        thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpost |
| 1340 | warez_forum1 | localhost | warez_forum | Query   |  126 | Sending data   | SELECT COUNT(*) AS threads,
          (
           SELECT COUNT(*) AS newthread
           FROM vb_thread AS thread
            |
| 1356 | warez_forum1 | localhost | warez_forum | Query   |  124 | Locked         | UPDATE vb_thread SET
        keywords = 'episode, [480p], [720p], kakaru, hashi, hoshizora, taste, cheese |
| 1503 | warez_forum1 | localhost | warez_forum | Query   |  103 | Sorting result | SELECT threadid, title, prefixid, lastpost, replycount
                        FROM vb_thread AS thread
                        WHERE forumid |
| 1787 | warez_forum1 | localhost | warez_forum | Query   |   57 | Sending data   | SELECT COUNT(*) AS threads,
          (
           SELECT COUNT(*) AS newthread
           FROM vb_thread AS thread
            |
| 1796 | warez_forum1 | localhost | warez_forum | Query   |   55 | Sending data   | SELECT COUNT(*) AS threads,
          (
           SELECT COUNT(*) AS newthread
           FROM vb_thread AS thread
            |
| 1855 | warez_forum1 | localhost | warez_forum | Query   |   43 | Locked
        (prefixid, postusername, postuserid, title, iconid, visible, forumid, d
| 1954 | warez_forum1 | localhost | warez_forum | Query   |   23 | Sorting res
                        FROM vb_thread AS thread
                        WHERE forumid |
| 1956 | warez_forum1 | localhost | warez_forum | Query   |   21 | Locked
        (prefixid, postusername, postuserid, title, iconid, visible, forumid, d
| 2045 | warez_forum1 | localhost | warez_forum | Query   |    4 | Sending dat
          (
           SELECT COUNT(*) AS newthread
           FROM vb_thread AS thread
            |
| 2064 | da_admin     | localhost | NULL         | Query   |    0 | NULL                                                                                                                  |
+------+--------------+-----------+--------------+---------+------+------------                                                                                       --------------------+

[Lock Down]

Did you even try what I suggested?

If yes , show us the mysql variable settings as they are now.