Am 15.02.2013 22:32, schrieb Honza Horak:
On 02/15/2013 3:31 PM, "Jóhann B. Guðmundsson" wrote:
> On 02/15/2013 01:50 PM, Honza Horak wrote:
>> I still see the differences between MariaDB and MySQL to be very
> Difference never the less and difference in behavior ( which mariadbs
> own benchmarking on their website proof ) which means every server
> that has been done for the mysql host has to be redone to take
> changes and features mariadb introduces.
Can you be more specific, what tweaks you mean?
the difference between theory and life
have fun if something like below hits you after
upgrade and you have not the knowledge i had to
fugure out what happens and fix the app temporary
i have seen queries going 1000 times faster after a
minor update because one bugfix introduced create temp
tables for a simple query on a 16 GB table where the next
bugfix corrected this and made a whle application useable
again - the temporary fix was downgrade or change queries
in dbmail to force a index
--- dbmail-2.2.11/dbmail-message.c 2009-02-02 15:21:55.000000000 +0100
+++ dbmail-2.2.11-patched/dbmail-message.c 2009-08-01 16:47:38.650404527 +0200
@@ -741,9 +741,10 @@
static struct DbmailMessage * _fetch_full(struct DbmailMessage *self)
char *query_template = "SELECT messageblk, is_header "
- "FROM %smessageblks "
- "WHERE physmessage_id = %llu "
- "ORDER BY messageblk_idnr";
+ "FROM %smessageblks "
+ "FORCE INDEX (physmessage_id_index) "
+ "WHERE physmessage_id = %llu "
+ "ORDER BY messageblk_idnr";
return _retrieve(self, query_template);