Ken D'Ambrosio wrote: >> How much data are you searching through? (how big is your dbmail db?) >> > > Roughly 100 GB; it's got 750K messages or so. > > >> How much ram does the db server have? >> > > 2 GB You're i/o bound. How is the data stored? single disk? raid 5? etc..? Speed the of the disks? Do you have a single array with the os/logs and dbs all together?
You'll need to add a lot more ram (and allocate more to mysql) and more faster disks to make access to it faster. Also consider separating the i/o types - sequential from random to dedicated arrays. hth, S _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
