InnoDB: Lock wait timeout exceeded from all programs after errorand backout

2002-07-24 Thread Charley Collins
saction in the way: set AUTOCOMMIT=0: BEGIN; update .; ... ... COMMIT; set AUTOCOMMIT=1; or ROLLBACK; set AUTOCOMMIT=1; If someone has an idea what happens here, please answer! Greetings Charley - Before posting, pl

incrementing a non auto_increment column on insert

2001-12-30 Thread Charley L. Tiggs
How can I accomplish this? Charley - 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 PROTEC

Newbie trying to optimizing a join search

2001-12-28 Thread Charley L. Tiggs
it's own index, product number, store, class, designer, and title are inside an index called index_product. In prodcat, product number, category, and subcategory are part of an index called index_category. Thanks in advance for your attention and time. Charley --

RE: InnoDB and Multithread

2001-08-12 Thread CHARLEY
Yes, I am!!! -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Monday, August 13, 2001 1:13 PM To: ¨öEA©¡¨¬¢¬ Cc: '[EMAIL PROTECTED]' Subject: Re: InnoDB and Multithread On Mon, Aug 13, 2001 at 01:03:38PM +0900, ½ÉÃæº¸ wrote: > > Hi, everyone. > I CREATE TABLE foo