cope with deadlock

hi, From this url: http://dev.mysql.com/doc/refman/5.5/en/innodb-deadlocks.html , mysql says "If you are using locking reads (|SELECT ... FOR UPDATE| or|SELECT ... LOCK IN SHARE MODE|), try using a lower isolation level such as|READ COMM

Re: setting max_allowed_packet dynamically problem

You can find which my.cnf your server is reading by using : mysql --help which displays something like this: Default options are read from the following files in the given order: C:\Windows\my.ini C:\Windows\my.cnf C:\my.ini C:\my.cnf D:\Program Files\MySQL\M ySQL Server 5.5\my.ini D:\Program F

Re: how to understand seconds_behind_master

On 10/28/2011 3:38 PM, jiangwen jiang wrote: Hi, all: I am confusing with seconds_behind_master, in mysql manual, it says: In essence, this field measures the time difference in seconds between the slave SQL thread and the slave I/O thread. how to understand this description: 1. seconds_behinds