I recently switched to InnoDB & persistent connections from PHP. Lately I've been getting these errors "Lock wait timeout exceeded; Try restarting transaction" on an UPDATE on table. The system is in development so there is at most one other user ( a back end Perl script).
When I switched PHP back to non-persistent connections I stopped getting that error. How does one use persistent PHP connections & InnoDB to avoid this error ? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
