Database performance
Brian Ross <[email protected]>
| Newsgroups | gmane.mail.spam.greylist.user |
|---|---|
| Message-ID | <[email protected]> |
Hello, I was wondering if anyone has any performance tuning tips for the MySQL db as implemented in relaydelay. We're running the db_maintenance script regularly, expiring approximately 1.25 million rows on a nightly basis with the maintenace taking approximately 1.5 hours. During the maintenance we're turning off our mail relays because the maintenance is so disk intensive that it causes relaydelay to slow down to the point of hitting the milter time out values (yes - I suppose I could look at altering those in the sendmail.cf). Any thoughts on optimization would be appreciated. -Brian +-------------+--------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+----------------+---------+ | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +-------------+--------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+----------------+---------+ | dns_name | MyISAM | Dynamic | 11463906 | 57 | 654696476 | 4294967295 | 260299776 | 0 | NULL | 2003-07-09 16:00:24 | 2006-01-04 22:44:01 | NULL | | | | mail_log | MyISAM | Dynamic | 0 | 0 | 0 | 4294967295 | 1024 | 0 | 1 | 2003-07-09 16:00:24 | 2003-07-09 16:00:24 | NULL | | | | relayreport | MyISAM | Dynamic | 21424674 | 118 | 2535895056 | 4294967295 | 994676736 | 0 | 372929009 | 2003-12-07 01:05:17 | 2006-01-04 21:07:35 | NULL | | | | relaytofrom | MyISAM | Dynamic | 3248361 | 131 | 426743244 | 4294967295 | 126875648 | 0 | 372993269 | 2003-07-09 16:00:24 | 2006-01-04 22:44:15 | 2006-01-04 21:34:26 | | | +-------------+--------+------------+----------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+---------------------+----------------+---------+ 4 rows in set (0.01 sec)