[Mod_log_sql] LogSQLPreserveFile and mysql read locks
comingupslowly at gmail.com
Wed Mar 23 12:35:38 EST 2005
I've been using mod_log_sql 1.18 and apache 1.3.x for a while now, and
I've come across a problem:
When I issue the mysql command FLUSH TABLES WITH READ LOCK, all of my
web sites stop responding.
I think this is because mod_log_sql is trying to send data to the
locked tables and, as it can't, is forcing the apache process to
lock/wait (or whatever this is called).
I've set up a LogSQLPreserveFile config entry, but I don't think this
is the problem; I think there may need to be an INSERT DELAYED
equivalent somewhere, but I'm being dense and can't find it.
More information about the Mod_log_sql