How can I go about getting information about lock information? I looked at the InnoDB status screen but it doesnt say a whole lot. Im getting alot of problems with lock wait timeouts. What I want to know is, what is obtaining the locks, what user is obtaining the locks and with what query/update/insert statement. I also had alot of problems with deadlocks but that is solved now. This all came up because I had to fork() and have many children update the database at the same time. I searched the web alot for examples of how to do DB interactions while forking but I didn't find much information/examples. Any advice is welcome.
Thanks
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]