Vbulletin 4.2.4 site getting hammered on CPU. Looks like MYSql. Advice?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Chris Tretta
    New Member
    • Jul 2004
    • 28

    Vbulletin 4.2.4 site getting hammered on CPU. Looks like MYSql. Advice?

    My VB site is getting hammered by high CPU utilization, and I was looking for some ideas. Here is what is in my system process manager:
    68.36 5.58 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/server.XXXXXXX.com.err --open-files-limit=10000 --pid-file=/var/lib/mysql/mysqld.pid
    My research hasn't turned up anything useful. Does anyone have experience with this type of an issue?
    Thanks
    Chris
  • woodmj
    Senior Member
    • Mar 2013
    • 203
    • 5.7.5

    #2
    There's a mod over at vbulletin.org that may help there. [DBTech] vB Optimise v2 (vB4).

    Comment

    • Wayne Luke
      vBulletin Technical Support Lead
      • Aug 2000
      • 73976

      #3
      Are you using MyISAM tables still? If so, convert your tables to INNODB. Upgrade your MySQL to 5.7 as well.
      Translations provided by Google.

      Wayne Luke
      The Rabid Badger - a vBulletin Cloud demonstration site.
      vBulletin 5 API

      Comment

      • Paul M
        Former Lead Developer
        vB.Com & vB.Org
        • Sep 2004
        • 9886

        #4
        Without proper analysis, and access to your systems, no one can help you other than just guesswork.
        Baby, I was born this way

        Comment

        • Chris Tretta
          New Member
          • Jul 2004
          • 28

          #5
          My tables are MyISAM. server is 5.6.35. I will move forward with your suggestions

          Comment

          • Chris Tretta
            New Member
            • Jul 2004
            • 28

            #6
            I found this list of tables to update to InnoDB. Are there any others you recommend?
            • alter table attachment engine=InnoDB;
            • alter table datastore engine=InnoDB;
            • alter table deletionlog engine=InnoDB;
            • alter table forum engine=InnoDB;
            • alter table pm engine=InnoDB;
            • alter table pmreceipt engine=InnoDB;
            • alter table pmtext engine=InnoDB;
            • alter table post engine=InnoDB;
            • alter table postparsed engine=InnoDB;
            • alter table searchcore engine=InnoDB;
            • alter table searchgroup engine=InnoDB;
            • alter table searchlog engine=InnoDB;
            • alter table sigparsed engine=InnoDB;
            • alter table subscribethread engine=InnoDB;
            • alter table thread engine=InnoDB;
            • alter table threadviews engine=InnoDB;
            • alter table user engine=InnoDB;
            • alter table usertextfield engine=InnoDB;
            Thanks
            Chris

            Comment

            • Wayne Luke
              vBulletin Technical Support Lead
              • Aug 2000
              • 73976

              #7
              Since you're using MySQL 5.6.X, you can convert every table to INNODB.
              Translations provided by Google.

              Wayne Luke
              The Rabid Badger - a vBulletin Cloud demonstration site.
              vBulletin 5 API

              Comment

              • Chris Tretta
                New Member
                • Jul 2004
                • 28

                #8
                I am running into issues. Any guidance? This is only on a couple of large - image based tables.

                Comment

                • Wayne Luke
                  vBulletin Technical Support Lead
                  • Aug 2000
                  • 73976

                  #9
                  Do as the error says and increase that log file size or store your customavatars in the filesystem under Avatars -> User Picture Storage Type.
                  Translations provided by Google.

                  Wayne Luke
                  The Rabid Badger - a vBulletin Cloud demonstration site.
                  vBulletin 5 API

                  Comment

                  Related Topics

                  Collapse

                  Working...