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