to reply to mysqlf and try to explain it more * nobody than the developer knows the scheme better
* it's hard to verify this all manually i had a hard time before upgrade to dbmail3 making sure all the keys as example in the dbmail2 database has the same names and keys to not fail alter / drop key * if you find out that keys could be optimized or are useless and writing the code on the server side this is the perfect moment to manifest this internally and maintain at the same time a function which verifies the complete scheme * apply it blindly and automatically may be dangerous * *but* if dbmail would have a function which generates hardly recommended scheme / key changes this function could be called at startup, spit the recommended changes to the syslog so the admin is aware of it and as we are here a hint in the log "you should call dbmail-util --fix-scheme" and dbmail-util using the same code and execute the queries should be easy keep in mind that also no longer needed keys have impact on write-performance of the db-server, missing ones on the overall performance and not optimized ones for the real queries in case of mysqld are there but useless maintain this within dbmail could have a big impact in user expierience as well as performance over years Am 19.06.2013 13:02, schrieb Reindl Harald (mobile): > Uhm wouldn't it not be a good idea at least verify the scheme and spit out a > big fat warning to the syslog and in general give dbmail-util a switch to > apply scheme changes which should be called after any dbmail update instead > deal with SQL dumps? > > -------- Original-Nachricht -------- > Von: Paul J Stevens <[email protected]> > Gesendet: Wed Jun 19 09:54:14 MESZ 2013 > An: DBMail mailinglist <[email protected]> > Betreff: Re: [Dbmail] IDLE Command > > On 06/18/2013 01:43 PM, Reindl Harald wrote: > >> below the full query and the debug-log with maksed db-password >> maybe you can guess what roundcube mail does not like with it too > > Ok, found it. You need to apply > > sql/mysql/3_0_2-3_0_3.mysql > > since a view was updated to fix sort
signature.asc
Description: OpenPGP digital signature
_______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
