Announcement

Collapse
No announcement yet.

vb_mailqueue has 6 gb!

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

  • [Forum] vb_mailqueue has 6 gb!

    vb_mailqueue on my forum has a size of 6.44 GB!!

    why so big? is any way to clean it and decrease the size?
    vBulletin Services I offer: www.Todo10.com
    Technical vB/Server/Hosting support Service also!

  • #2
    Wow. Is your mail getting sent? Part of the sending process is to then delete it from the table after it is sent (see class_mail.php).

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment


    • #3
      Originally posted by cloferba View Post
      is any way to clean it and decrease the size?
      I assume the only way would be to use phpmyadmin to 'empty' the table. As Lynne pointed out there is a problem why the rows are not truncated after the email is sent. I would re-upload class_mail.php as it might have been an incomplete upload and would explain why it's not working correctly.

      Are email being sent?

      Comment


      • #4
        yes, mails are sended...

        i forget to say im using this mod:
        http://www.vbulletin.org/forum/showt...ht=mail&page=4

        Cron based e-mail sending

        but the author told me next:
        I have no idea why your table is so big.
        i dont mind if i must remove this mod, all what i want is make backups easier and dont have too many gb!

        andy said:
        I assume the only way would be to use phpmyadmin to 'empty' the table. As Lynne pointed out there is a problem why the rows are not truncated after the email is sent. I would re-upload class_mail.php as it might have been an incomplete upload and would explain why it's not working correctly.
        im scared about edit tables :S
        any guide to "noob" people?
        vBulletin Services I offer: www.Todo10.com
        Technical vB/Server/Hosting support Service also!

        Comment


        • #5
          Originally posted by cloferba View Post
          im scared about edit tables :S
          any guide to "noob" people?
          Do you have phpmyadmin? If you do, you can create a new database from a backup and practice on that.

          Comment


          • #6
            all right, but i dont know how to empty a table....can this make errors on the forum?

            im using phpmyadmin
            Last edited by cloferba; Thu 29 Apr '10, 10:48am.
            vBulletin Services I offer: www.Todo10.com
            Technical vB/Server/Hosting support Service also!

            Comment


            • #7
              If you're using InnoDB tables, use drop+create instead of truncate/delete - the latter is extremely slow on large tables such as yours.

              On MyISAM, truncate should be more or less instant.
              vB4 SuperCharged
              http://www.gamingmasters.co.uk

              Comment


              • #8
                Originally posted by Darkimmortal View Post
                If you're using InnoDB tables, use drop+create instead of truncate/delete - the latter is extremely slow on large tables such as yours.

                On MyISAM, truncate should be more or less instant.
                im using phpmyadmin =(
                vBulletin Services I offer: www.Todo10.com
                Technical vB/Server/Hosting support Service also!

                Comment


                • #9
                  Originally posted by cloferba View Post
                  all right, but i dont know how to empty a table....can this make errors on the forum?

                  im using phpmyadmin
                  Sounds like you need to learn the very basics first. It's very important to know things like how to properly backup and restore should anything go wrong. You might like to ask assistance from your web hosing company?

                  Comment


                  • #10
                    im using mysqldumper to make backups and restores...

                    i will try to (delete?) all from mailqueue table
                    vBulletin Services I offer: www.Todo10.com
                    Technical vB/Server/Hosting support Service also!

                    Comment

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