Re: [Dbmail] Message body search

2014-09-15 Thread Andrea Brancatelli
I just realized that the “data” column in dbmail_mimeparts is a “blob”, thus cannot have a full text index on it. On a “test” machine I tried to convert it to long text but seems that there are some extended chars as well… after all it’s a blob, not a text. I also realized that, obviously, runn

[Dbmail] Message body search

2014-09-14 Thread Andrea Brancatelli
Hello everybody. On our setup (MySQL) any type of search on the full body of the message doesn't work because it times out, and that's pretty obvious since it has to scan about 400GB of InnoDB table with no index on it. But time has changed and now (from MySQL 5.6 on) even InnoDB has Full Te