[Dbmail-dev] Currupted attachments

2009-09-14 Thread Jorge Bastos
Howdy, Paul, Sometimes I have corrupted attachments. When this happen, I as the sender to send it again and it works OK. This is something that never happened to be, just now when moved to = 2.3.6. I'm going to send to your private email the raw message for you to analyze. I'd like you

Re: [Dbmail] IMAP quick resync?

2009-09-14 Thread Jonathan Feally
Shane, Briefly looking at the two RFC's, i think we could do this, but it will take some work. This would have to go into the 2.3.x branch. What client are you using that is supposed to support CONDSTORE and QRESYNC? Paul, I think we can add a modseq bigint to the messages table. This value

Re: [Dbmail] MySQL tweaks?

2009-09-14 Thread Ken D'Ambrosio
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 How much ram is allocated to the db software? How do I check? Are you running MySQL or Postgres? or something else? MySQL If

[Dbmail] MySQL tweaks?

2009-09-14 Thread Ken D'Ambrosio
Hey, all. I've got a bajillion e-mails in my e-mail. (I'm using dbmail for archiving.) I don't care about disk space -- I've got it to throw away. But searches take close to 5+ minutes. Any clues on indexing, etc., that might be appropriate? -Ken -- This message has been scanned for

Re: [Dbmail] MySQL tweaks?

2009-09-14 Thread Simon Gray
Ken D'Ambrosio wrote: Hey, all. I've got a bajillion e-mails in my e-mail. (I'm using dbmail for archiving.) I don't care about disk space -- I've got it to throw away. But searches take close to 5+ minutes. Any clues on indexing, etc., that might be appropriate? -Ken How much

Re: [Dbmail] MySQL tweaks?

2009-09-14 Thread Jonathan Feally
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. You need to clean and optimize your tables. With a quick calc, that would put you at about 140MB/message. Are you on 2.2.x or 2.3.x? You should

[Dbmail] IMAP quick resync?

2009-09-14 Thread Shane Kerr
Hello, Can any of the developers give any indication of how painful it would be to add support for quick synchronization? http://www.rfc-archive.org/getrfc.php?rfc=4551 http://www.rfc-archive.org/getrfc.php?rfc=5162 I'm not asking for a feature (although it would be nice), but rather a sense of

Re: [Dbmail] IMAP quick resync?

2009-09-14 Thread tabris
Jonathan Feally wrote: Shane, Briefly looking at the two RFC's, i think we could do this, but it will take some work. This would have to go into the 2.3.x branch. What client are you using that is supposed to support CONDSTORE and QRESYNC? Paul, I think we can add a modseq bigint to the

Re: [Dbmail] IMAP quick resync?

2009-09-14 Thread Shane Kerr
Jon, I'm actually working on a Python client to do more-or-less intelligent backups of IMAP mailboxes. (Yes I know this already exists in various forms, but I want something that maintains multiple versions of mailbox for historical reasons, and yet also takes a minimum of space. My current

Re: [Dbmail] MySQL tweaks?

2009-09-14 Thread Ken D'Ambrosio
Thanks for all the pointers! Though I'm afraid your sliderule* dropped a decimal: 1*10^11 / 7.5*10^5 = 13., or 13K/message. I'm running 2.2.9 (Ubuntu package). I'll kick the tires and see what happens. Again, thanks! -Ken * Use of term sliderule not intended as a pejorative, but,

Re: [Dbmail] MySQL tweaks?

2009-09-14 Thread Jonathan Feally
Ok - but your sliderule is bent too. 139KB/message looks more correct. I must have had too many 1024's in there to the first time. Ken D'Ambrosio wrote: Thanks for all the pointers! Though I'm afraid your sliderule* dropped a decimal: 1*10^11 / 7.5*10^5 = 13., or 13K/message. I'm