Announcement

Collapse
No announcement yet.

How to handle MySQL

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] How to handle MySQL

    I've been running vBulletin for a couple of weeks now and already I received a warning about my MySQL database being flooded and it should be up to 2 Gb. What i filling it and how can I control/fix this?

  • #2
    That depends. What do you mean exactly? Please provide all relevant info.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment


    • #3
      Your account information:
      Total MySQL Database Size: 1993.29 MB
      Total MySQL Tables: 1047

      Largest MySQL Database Size: 1729.91 MB
      Largest MySQL Table Count: 236
      My vBulletin installation is "the largest". I've no clue why it's so huge. While googling for answers I found out that attachments go there (if I got it right?) but I moved them all to another directory. I'm quite new at this so I don't exactly have an idea about "all relevant info"...

      Comment


      • #4
        What is the exact message you got from your host? Have you checked the vB database and looked at the tables and total db size? What is the URL to your forums?
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment


        • #5
          Dear Lauri:

          It has come to our attention that your site is using an excessive amount of MySQL resources on your BlueHost.Com account. This is causing performance problems on your website as well as for other customers that are on this server. It can cause our servers to crash and cause additional downtime.

          Our research shows that server performance degrades when the MySQL usage is over 1000 tables and/or 3 GB on a single account or 1000 tables and/or 2 GB on a single database. In order to ensure optimal performance for your account and the others in your shared hosting environment, we request that you reduce the MySQL usage on your account to under these limits by 06/14/2011.

          Your account information:
          Total MySQL Database Size: 1993.29 MB
          Total MySQL Tables: 1047

          Largest MySQL Database Size: 1729.91 MB
          Largest MySQL Table Count: 236

          We do understand that these databases may be old or unused. There are programs/scripts that will create these automatically.
          After removing some of the MySQL content you may request a rescan of the account. If you need assistance with removing content or to help troubleshoot the reason for this problem we will be happy to assist you in this process.

          Proper maintenance of your account will ensure the best performance for your website. If you are unable to comply with these requests your account will be automatically deactivated by 06/14/2011 to maintain proper server performance. Thank you for your help in resolving this issue.


          Per conditions stated in the Terms of Service (http://www.bluehost.com/terms), this issue needs to be resolved:
          7.03. BlueHost.Com does not set arbitrary limits on the amount of disk space a Subscriber can use for the Subscriber's website, nor does BlueHost.Com charge additional fees based on an increased amount of storage used, provided the Subscriber's use of storage complies with these Terms. Please note, however, that the BlueHost.Com service is designed to host websites. BlueHost.Com does NOT provide unlimited space for online storage, backups, or archiving of electronic files, documents, log files, etc., and any such prohibited use of the Services will result in the termination of Subscriber's account, with or without notice. Accounts with a large number of files (inode count in excess of 200,000) can have an adverse affect on server performance. Similarly, accounts with an excessive number of MySQL/PostgreSQL tables (i.e., in excess of 1000 database tables) or of database size (i.e., in excess of 3GB total MySQL/PostgreSQL usage or 2GB MySQL/PostgreSQL usage in a single database) negatively affect the performance of the server. BlueHost.Com may request that the number of files/inodes, database tables, or total database usage be reduced to ensure proper performance or may terminate the Subscriber's account, with or without notice.


          Terms of Service Compliance Department
          1958 South 950 East
          Provo, UT 84606
          Phone line: (888) 401-HOST Option 5 | Fax line: 801-765-1992
          My forum: http://vbulletin.guildredemund.net/forum.phpIt's hard to check anything from the forum as it only gives me now:

          Database error
          The database has encountered a problem.

          Please try the following:
          • Load the page again by clicking the Refresh button in your web browser.
          • Open the vbulletin.guildredemund.net home page, then try to open another page.
          • Click the Back button to try another link.
          The vbulletin.guildredemund.net forum technical staff have been notified of the error, though you may contact them if the problem persists.
          We apologise for any inconvenience.

          Also - while checking Tables at CPH > Repair / Optimize Tables nothing seems to point towards this kind of usage.
          Last edited by guildredemund; Thu 9 Jun '11, 12:59am.

          Comment


          • #6
            For that database error, please right click on the page and view source. Then scroll to the bottom of the page and copy the text of the error from there.

            Regarding the database size, are you storing your attachments in the database or the filesystem?
            Vote for:

            - *Admin Settable Paid Subscription Reminder Timeframe*
            -
            *PM - Add ability to reply to originator only*
            - Add Admin ability to auto-subscribe users to specific channel(s)
            - "Quick Route" Interface...

            Comment


            • #7
              Attachment are stored separately.

              I'm also having some additional help with this so it's (hopefully) going to turn out ok. Thanks for help though!

              Comment

              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
              Working...
              X