It is not a hugh deal as a bigint(21) column can hold something like |9223372036854775807 messages. The cause of this is the way that messages are delivered. They are first delivered to _...@!internal_delivery_user!@__ to create all of the physical message and cache entries. Then, for each recipient, a 2nd, 3rd, ... entry is made in dbmail_messages pointing to the same physical message. Once a message pointer has been created for each recipient, the original message pointer created during delivery is deleted. This process is to make sure we only store on copy of the message, even if the message was sent to all 100 users on your system at the same time. This process works for messages with multiple recipients. The next place we could reduce storage of messages twice, is where your MTA delivers the same message one time per recipient. This is where the dbmail_partlists and dbmail_mimeparts tables came to be in 2.3.x. These tables also help in cases where identical attachments are are received or stored in sent messages. We would only store that 1 mb attachment once, vs. 200 times for some sales guy that emails that promo pdf out to each of his contacts individually.
-Jon| Uwe Kiewel wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi, > > just a question of understanding: :-) > Why is lmtpd increasing the message id by 2? > > Thanks, > Uwe > > Apr 20 22:04:36 dedi0031 dbmail/lmtpd[10206]: [0x8052960] > Notice:[message] sort_deliver_to_mailbox(+2200): message id=10448, > size=6289 is inserted > Apr 20 22:04:44 dedi0031 dbmail/lmtpd[10206]: [0x8052960] > Notice:[message] sort_deliver_to_mailbox(+2200): message id=10450, > size=5241 is inserted > Apr 20 22:05:05 dedi0031 dbmail/lmtpd[10206]: [0x8052960] > Notice:[message] sort_deliver_to_mailbox(+2200): message id=10452, > size=4353 is inserted > Apr 20 22:05:17 dedi0031 dbmail/lmtpd[10206]: [0x8052960] > Notice:[message] sort_deliver_to_mailbox(+2200): message id=10454, > size=2840 is inserted > Apr 20 22:06:05 dedi0031 dbmail/lmtpd[13443]: [0x8052960] > Notice:[message] sort_deliver_to_mailbox(+2200): message id=10456, > size=5043 is inserted > Apr 20 22:06:22 dedi0031 dbmail/lmtpd[13443]: [0x8052960] > Notice:[message] sort_deliver_to_mailbox(+2200): message id=10458, > size=2201 is inserted > Apr 20 22:07:02 dedi0031 dbmail/lmtpd[13443]: [0x8052960] > Notice:[message] sort_deliver_to_mailbox(+2200): message id=10460, > size=6349 is inserted > Apr 20 22:07:39 dedi0031 dbmail/lmtpd[13443]: [0x8052960] > Notice:[message] sort_deliver_to_mailbox(+2200): message id=10462, > size=4792 is inserted > Apr 20 22:07:46 dedi0031 dbmail/lmtpd[13443]: [0x8052960] > Notice:[message] sort_deliver_to_mailbox(+2200): message id=10464, > size=3127 is inserted > Apr 20 22:08:33 dedi0031 dbmail/lmtpd[13443]: [0x8052960] > Notice:[message] sort_deliver_to_mailbox(+2200): message id=10466, > size=2651 is inserted > Apr 20 22:08:43 dedi0031 dbmail/lmtpd[13443]: [0x8052960] > Notice:[message] sort_deliver_to_mailbox(+2200): message id=10468, > size=3048 is inserted > Apr 20 22:08:50 dedi0031 dbmail/lmtpd[13443]: [0x8052960] > Notice:[message] sort_deliver_to_mailbox(+2200): message id=10470, > size=3243 is inserted > Apr 20 22:11:07 dedi0031 dbmail/lmtpd[13443]: [0x8052960] > Notice:[message] sort_deliver_to_mailbox(+2200): message id=10472, > size=4955 is inserted > Apr 20 22:12:14 dedi0031 dbmail/lmtpd[13443]: [0x8052960] > Notice:[message] sort_deliver_to_mailbox(+2200): message id=10474, > size=2958 is inserted > Apr 20 22:12:38 dedi0031 dbmail/lmtpd[13443]: [0x8052960] > Notice:[message] sort_deliver_to_mailbox(+2200): message id=10476, > size=5041 is inserted > Apr 20 22:12:50 dedi0031 dbmail/lmtpd[13443]: [0x8052960] > Notice:[message] sort_deliver_to_mailbox(+2200): message id=10478, > size=6899 is inserted > Apr 20 22:13:03 dedi0031 dbmail/lmtpd[13443]: [0x8052960] > Notice:[message] sort_deliver_to_mailbox(+2200): message id=10480, > size=5508 is inserted > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v2.0.9 (GNU/Linux) > Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org > > iQIcBAEBAgAGBQJJ7NhMAAoJEEJXG7BUuynntCoQAMHEBbCUd/N7iShJqvg+IrM/ > nA5oFtovZ4zgrxds4fDOHpvettH3z7Hzr6b0817sMrr8eYqKIRRNs60H/b5DYmHh > dc8aohrF+wIZCCOScyDZwc9Rti3Dk4sp0PGN6nwHuHWoBU+cnAe2RoDjLSSmRl7p > zFDiiZok++Rv5CsaJgcHpxDh/dJuEdIcOOHdfjMnDF3c9dMET72Ay48Bb+QypJtP > gecIPBHV2+6Bec34AQ+htrTh+Mem1lMJntfRSFZc9bvBAwFrjSzWmHT0qhJB6pxT > 9yOnaOQae3XUdiifpLAppW+SnVpsCeBh7CCvi71uqNybuRkHWgV8GOtxRcxv/jyB > yT2qxNz6zy6btXOlnewqgS8pitdTBWe1KX31XXnp9X5ipfypApv7ShQlb3jAgSQg > emqLuVbuWMW0NLCcMsLh+3NajSxCbi8GnrLGgAVa5BM+Av9gHQur0AceF5tyJcNm > AzAP0/clcHcEUaQ3jVM8O6zMcZmn5st8Mxzoi2DZMPjIiDXn6zjxqgdnHHYFq+wS > 75HsRewI/TlrUnB1Tttsxk7Fl+kqyVNkjY+yD1mzksL3tsbOrzB1SP7prJrku7Md > 83vvB2/egKWoac8hIu6vvZXESVfqUQdxafHM55f2Zscb0VkIJLFfe2YRPCsfdSpV > bHNRQaXED1P/y2elaYzc > =poS8 > -----END PGP SIGNATURE----- > _______________________________________________ > Dbmail-dev mailing list > Dbmail-dev@dbmail.org > http://mailman-new.icns.fastxs.net/cgi-bin/mailman/listinfo/dbmail-dev > > -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://mailman-new.icns.fastxs.net/cgi-bin/mailman/listinfo/dbmail-dev