Versioner sammenlignet

Nøgle

  • Linjen blev tilføjet.
  • Denne linje blev fjernet.
  • Formatering blev ændret.

...

Kodeblok
titlemy.cnf
[mysqld]
transaction-isolation = READ-COMMITTED
log-bin=mysql-bin
binlog_format=row
default-table-type=innodb
default-storage-engine=innodb
max_allowed_packet=32M64M

[mysql]
default-character-set=utf8

 
[mysqldump]
max_allowed_packet=64M

Notice that max_allowed_packed=64M, where as this link says 32M, I have seen Gliffy updates fail with 32M

On large installations or where indexes are huge, changing innodb_lock_wait_timeout can be an option (Ref: JIRAKB)

...