Alan Hicks wrote: > Bernard Johnson wrote: >> Bernard Johnson wrote: >>> I (and other people I know) have been using VersaMail on a Treo with >>> dbmail. For the past year (on different versions of VersaMail and >>> different versions of dbmail), things have worked great. >>> >>> Then, a few weeks ago, when trying to synchronize with the IMAP server, >>> I get a "Getting Message x of y" (where x is 1577 - y). Here it just >>> hangs until I get a "Time Out" message on the Treo. It always hangs on >>> the very same message. >> >> Well, since I didn't get a single comment regarding the logs I posted, >> I'll assume that it's not a dbmail problem. First thing next week, I'm >> going to archive a lot of mail off which I expect will fix this problem. >> >> If anyone takes a second look and thinks there is a problem, let me know >> ASAP before I destroy the ability to reproduce it. >> > > I had a similar problem a year or so ago using an earlier version where > a mail folder failed to synchronize, the problem turned out to be I had > not run the dbmail-util clean-up routines in some months that that was > stressing out the mysql database. After running the clean-up routines > it appeared that there was considerable fragmentation of the database so > 'ALTER TABLE tbl_name ENGINE=INNODB' for each table cured the problem, > the dbmail_messageblks table takes a long time to run (over 20 mins for > my setup) so I only do it every 6 months or so. Since the upgrade to > 2.2 I have had very good stability and better performance.
I run dbmail-util nightly to clean up the database. It is possible that it's extremely fragmented though, although I wouldn't expect that to be a problem (maybe performance, but not other). In any event, I'll give that a try before I otherwise start archiving off email. _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
