Tag Archives: MySQL

Sudden slow-down of combination MailScanner+MailWatch=MySQL problem

It takes up to 25min for mail to pass through my mail server, which is BAD. Digging around in logs, I found that the most likely culprit was a very slow writing to MySQL DB. How to see general configuration … Continue reading

Posted in Linux | Tagged , , , | Comments Off on Sudden slow-down of combination MailScanner+MailWatch=MySQL problem

MySQL error

After mailserver craches down (electricity went out and/or any of the partitions was 100% full), after trying to use MailWatch, you may get this error : Table ‘./mailscanner/maillog’ is marked as crashed and should be repaired Here is how to … Continue reading

Posted in Linux | Tagged , | Comments Off on MySQL error

MySQL commands

Some (often used) commands for MySQL DB…. Logging into DB : # mysql -u root -p How to show colons in table named “users” : mysql> show columns from users; How to show only some fields from table “users” : … Continue reading

Posted in Linux | Tagged , | Comments Off on MySQL commands

Dump MySQL DB for MailScanner

Well, I have promised this, have I not? So, on Fedora and RHEL, with MySQL 4.1.20 (or higher version), when number of messages in DB goes over (or near) 700.000 there are some nasty side-effects; lake delay of mails because … Continue reading

Posted in Linux | Tagged , , | Comments Off on Dump MySQL DB for MailScanner