Announcement

Collapse
No announcement yet.

vb_mailqueue has 6 gb!

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

  • cloferba
    replied
    im using mysqldumper to make backups and restores...

    i will try to (delete?) all from mailqueue table

    Leave a comment:


  • Andy
    replied
    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?

    Leave a comment:


  • cloferba
    replied
    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 =(

    Leave a comment:


  • Darkimmortal
    replied
    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.

    Leave a comment:


  • cloferba
    replied
    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.

    Leave a comment:


  • Andy
    replied
    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.

    Leave a comment:


  • cloferba
    replied
    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?

    Leave a comment:


  • Andy
    replied
    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?

    Leave a comment:


  • Lynne
    replied
    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).

    Leave a comment:


  • cloferba
    started a topic [Forum] vb_mailqueue has 6 gb!

    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?
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X