Re: Database performance
Jose Marcio Martins da Cruz <[email protected]>
| Newsgroups | gmane.mail.spam.greylist.user |
|---|---|
| Message-ID | <[email protected]> |
Hello, Brian Ross said his database has around 1.2 million rows. Wayne database has around 4 million rows. May I have an idea of what trafic level are you handling ? (number or users or number of connections or messages a day) Thanks Jose-Marcio Wayne Walker wrote: > Follow Evan's advice, but also add indexes to the tables. This greatly > improved the maintenance script run time for me. > > BE WARNED! Adding the indexes will slam your mysql server for a LONG > TIME (I had 4 million rows in each table (maintenance db hadn't been > run in a long time) and it took about 15 minutes PER INDEX). > > Once I added the indexes, it still took a long time to run, but the > system was usable during the maintenance db run (it was NOT usable > before (load would hit 30's and 40's). > > > On Wed, Jan 04, 2006 at 11:05:06PM -0800, Brian Ross wrote: > >>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 >> >> -- --------------------------------------------------------------- Jose Marcio MARTINS DA CRUZ Tel. :(33) 01.40.51.93.41 Ecole des Mines de Paris http://j-chkmail.ensmp.fr 60, bd Saint Michel http://www.ensmp.fr/~martins 75272 - PARIS CEDEX 06 mailto:[email protected]