[Mod_log_sql] LogSQLPreserveFile and mysql read locks

Justin Finkelstein comingupslowly at gmail.com
Wed Mar 23 12:35:38 EST 2005

Hi kids

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.

Any suggestions?


More information about the Mod_log_sql mailing list