LogSQLPreserveFile and mysql read locks

Justin Finkelstein <[email protected]> Wed, 23 Mar 2005 17:35:38 +0000
Newsgroups gmane.comp.apache.mod-log-sql
Message-ID <[email protected]>
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?

j.
_______________________________________________
Download the latest version at http://www.outoforder.cc/projects/apache/mod_log_sql/

To unsubscribe send an e-mail to 
mod_log_sql-unsubscribe-7qY7E20V6GW73k+5HYS8LQqVMODqnSLI@public.gmane.org