Hello.
Use SHOW PROCESSLIST and slow-query log to catch the query which locks tables for a long time. Upgrade to 4.1.13. If you use MyISAM, think about moving towards InnoDB. Aaron <[EMAIL PROTECTED]> wrote: > Hi all , > > I have been experiencing intermittent locking issues with MYSQL. It > appears that sometimes a query will lock reliease its lock, and is > causing other queries to wait and wait until the connection limit is > reached and i am locked out of the database. Has anyone ever had > anything like this happen? > > The setup: > Redhat 9.0 , Kernel 2,4,20-8smp > mysql-standard-4.1.7-pc-linux-i686-icc-glibc23 > MyISAM Tables (And unless InnoDB can support fulltext or some other > equivalent , migrating isnt an option at present) > ext2fs > > Our Datbase Activity: > We have a somewhat active website. > Things run fairly smoothly for the most part , although we do have some > slow queries from time to time. > We have far more selects than updates , but updates are still reasonably > active. > Frequently , an update will get locked while a slower query is running. > Sometimes we can experience a large backup waiting for a slow query , > but typically everything sorts out once the slow query finishes. > Rarely , however , a query will be in a "locked" state and will not let > go of its lock. Subsequent updates lock , and subsequent selects lock. > Eventually , if the above has happened , the connection table will fill up. > > We dont have any scripts that explicitly LOCK TABLES , aside from our > backup script which uses mysqlhotcopy. > Is it possible that the mysqlhotcopy LOCK TABLES could interfere with > the locking from the website activity? > > I apologise for the vagueness of this request , I really dont know what > direction would be best to further diagnose this. > If you have any advice , it would be greatly appreciated. > > thanks for your time! > Aaron > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]