I have been using DBMA to administer DBMail v2.2.10
On the home page of DBMA web interface, it displays only the top part of the
page.
I discovered the issue was due to a slow query in MySQL, after checking the
slow-query-log in MySQL.
The slow query is:
SELECT COUNT(*) FROM dbmail_messageblks;
Michael Monnerie wrote:
The question is: Why is MySQL so stupid not to use the index? That
should be done automatically by the DBMS, that's its job. I would oppose
against changing the query just because MySQL has a bug. Maybe you use a
version that's known to be instable?
I am using MySQL
Wallace Tan wrote:
I am using MySQL v5.0.77
MySQL IS using PRIMARY index for the slow query.
However, after reading comment 19 at:
http://www.mysqlperformanceblog.com/2006/12/01/count-for-innodb-tables/
I got the idea to use another index for the COUNT.
Any MySQL experts can explain
Michael Monnerie wrote:
On Freitag 03 April 2009 Wallace Tan wrote:
select count(1) from t1;
That would have been my next question. I've spoken once to Paul, because
dbmail uses lots of count(*), but PostgreSQL optimizes this out. Now it
seems MySQL would have a performance boost using
Michael Monnerie wrote:
On Freitag 03 April 2009 Wallace Tan wrote:
select count(1) from t1;
That would have been my next question. I've spoken once to Paul, because
dbmail uses lots of count(*), but PostgreSQL optimizes this out. Now it
seems MySQL would have a performance boost using
Hi Paul,
Sorry, I failed to mention that I have upgraded from v2.2.5 to v2.2.7 on my
first post.
I thought it could be the problem with the latest version, so I downgraded from
v2.2.7 back to v2.2.5.
The other reason is, I had to restart dbmail-imapd (v2.2.7) process a few times
due to IMAP
I have re-installed v2.2.7 and test on both v2.2.5 and v2.2.7 using:
cat email.eml | /usr/local/sbin/dbmail-smtp -d [EMAIL PROTECTED]
Both versions truncates the message body with lines starting with From
It works when there is a space before From, i.e. From
-- NOT-WORKING: email.eml
From
been reported since before dbmail 2.0 (it was a problem for early
versions of dbmail-lmtpd, iirc).
Aleksander Kamenik wrote:
Wallace Tan wrote:
I have installed dbmail-2.2.7 with exim 4.63
Message body is truncated before line starting with From
I can receive emails except for emails
at least
we know exim delivers the message to dspam successfully.
Wallace Tan wrote:
command = /usr/local/sbin/dbmail-smtp -d [EMAIL PROTECTED]
You could take the message with headers and everything and try to feed
it to dbmail-smtp the same way exim does, then you'll know for sure
whether
I have installed dbmail-2.2.7 with exim 4.63
Message body is truncated before line starting with From
I can receive emails except for emails with message body starting with From
This truncates the entire message body.
Anyone have this problem?
Is this a bug or is it a configuration setting
10 matches
Mail list logo