Hello all I am migrating from
Debian Squeeze 6.0.8 32 bit Dbmail 2.2.11 Mysql 5.1.72-2 to Debian Wheezy 7.3 64 bit Dbmail 3.1.9 (snapshot) Mariadb 5.5.34+maria-1~wheezy I am getting following warning from mysql/mariadb in my syslog: Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. UPDATE IGNORE is unsafe because the order in which rows are updated determines which (if any) rows are ignored. This or der cannot be predicted and may differ on master and the slave. Statement: UPDATE IGNORE dbmail_mailboxes SET seq=seq+1 WHERE mailbox_idnr=2 If I put option binlog-format=MIXED into my.cnf, warning goes away. Is it a good idea to use mixed binlog format in this case? Are there any hidden drawbacks? I am planing to have a slave server in future. I searched this mail list and did not find the answer. Another question, I found in mariadb documentation description [1] of the "dynamic" storage format, which "contain records of a variable length, resulting in more efficient data storage than compact or redundant, especially for tables containing BLOBs, although less than the compressed format" [1] https://mariadb.com/kb/en/xtradbinnodb-storage-formats/ Would it be good idea to use dynamic storage format for the dbmail_mimeparts table? -- Best regards, Sergey Spiridonov _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
