InnoDB table lock status
I'am working with MySQL 3.23.51-Max in a linux box and Visual Fox and Delphi in a WinXP box, mostly using InnoDB tables. Is there a way to know wich rows are lockedin a table? is there a function that returns if a row is locked, or the rows locked in a table? It can be done with a UDF? My question is due that, as you know, the InnoDB tables makes loking at row level and in the context of a transaction, so if someone has locked the row that I'm tring to read or lock, my program freezes until the rows are released. I worked arround this situation setting the value of innodb_lock_wait_timeout to 5, more or less, so my program doesn't freezes and a warnig is raised, then I can assume that the row is locked, but can't be sure that this is the real reason of the warnig. Thanks in advance, Patricio. - 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
InnoDB table lock status
I'am working with MySQL 3.23.51-Max in a linux box and Visual Fox and Delphi in a WinXP box, mostly using InnoDB tables. Is there a way to know wich rows are lockedin a table? is there a function that returns if a row is locked, or the rows locked in a table? It can be done with a UDF? My question is due that, as you know, the InnoDB tables makes loking at row level and in the context of a transaction, so if someone has locked the row that I'm tring to read or lock, my program freezes until the rows are released. I worked arround this situation setting the value of innodb_lock_wait_timeout to 5, more or less, so my program doesn't freezes and a warnig is raised, then I can assume that the row is locked, but can't be sure that this is the real reason of the warnig. Thanks in advance, Patricio. - 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
InnoDB table lock status
I'am working with MySQL 3.23.51-Max in a linux box and Visual Fox and Delphi in a WinXP box, mostly using InnoDB tables. Is there a way to know wich rows are lockedin a table? is there a function that returns if a row is locked, or the rows locked in a table? It can be done with a UDF? My question is due that, as you know, the InnoDB tables makes loking at row level and in the context of a transaction, so if someone has locked the row that I'm tring to read or lock, my program freezes until the rows are released. I worked arround this situation setting the value of innodb_lock_wait_timeout to 5, more or less, so my program doesn't freezes and a warnig is raised, then I can assume that the row is locked, but can't be sure that this is the real reason of the warnig. Thanks in advance, Patricio. - 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
[OT] I apologise
Please forgive me for sending more than a copy of my request , [MySQL] InnoDB Lock status. That's becouse every time I send it, I receive a mail that says that address to wich I am sending my message does'nt exists, and I'm not receiving messages anymore, don't know why. I realized this reading the mailing list web site, there are my posts and others posts. Regards, Patricio - 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
[MySQL] InnoDB Lock status
I'am working with MySQL 3.23.51-Max in a linux box and Visual Fox and Delphi in a WinXP box, mostly using InnoDB tables. Is there a way to know wich rows are lockedin a table? is there a function that returns if a row is locked, or the rows locked in a table? It can be done with a UDF? My question is due that, as you know, the InnoDB tables makes loking at row level and in the context of a transaction, so if someone has locked the row that I'm tring to read or lock, my program freezes until the rows are released. I worked arround this situation setting the value of innodb_lock_wait_timeout to 5, more or less, so my program doesn't freezes and a warnig is raised, then I can assume that the row is locked, but can't be sure that this is the real reason of the warnig. Thanks in advance, Patricio. - 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
[MySQL] Lock status
I'am working with MySQL 3.23.51-Max in a linux box and Visual Fox and Delphi in a WinXP box, mostly using InnoDB tables. Is there a way to know wich rows are lockedin a table? is there a function that returns if a row is locked, or the rows locked in a table? It can be done with a UDF? My question is due that, as you know, the InnoDB tables makes loking at row level and in the context of a transaction, so if someone has locked the row that I'm tring to read or lock, my program freezes until the rows are released. I worked arround this situation setting the value of innodb_lock_wait_timeout to 5, more or less, so my program doesn't freezes and a warnig is raised, then I can assume that the row is locked, but can't be sure that this is the real reason of the warnig. Thanks in advance, Patricio. - 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
[mysql] Lock status
I'am working with MySQL 3.23.51-Max in a linux box and Visual Fox and Delphi in a WinXP box, mostly using InnoDB tables. Is there a way to know wich rows are lockedin a table? is there a function that returns if a row is locked, or the rows locked in a table? It can be done with a UDF? My question is due that, as you know, the InnoDB tables makes loking at row level and in the context of a transaction, so if someone has locked the row that I'm tring to read or lock, my program freezes until the rows are released. I worked arround this situation setting the value of innodb_lock_wait_timeout to 5, more or less, so my program doesn't freezes and a warnig is raised, then I can assume that the row is locked, but can't be sure that this is the real reason of the warnig. Thanks in advance, Patricio. - 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
[mysql] Lock status
I'am working with MySQL 3.23.51-Max in a linux box and Visual Fox and Delphi in a WinXP box, mostly using InnoDB tables. Is there a way to know wich rows are lockedin a table? is there a function that returns if a row is locked, or the rows locked in a table? It can be done with a UDF? My question is due that, as you know, the InnoDB tables makes loking at row level and in the context of a transaction, so if someone has locked the row that I'm tring to read or lock, my program freezes until the rows are released. I worked arround this situation setting the value of innodb_lock_wait_timeout to 5, more or less, so my program doesn't freezes and a warnig is raised, then I can assume that the row is locked, but can't be sure that this is the real reason of the warnig. Thanks in advance, Patricio. - 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
Fw: MySQL Delphi 6
Thanks to all you for helping me, I still can't connect, but now i know that it is an issue of the delphi. I'll keep trying and researching. Patricio - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, November 20, 2002 1:07 AM Subject: RE: MySQL Delphi 6 You can download winzeos for delphi I use it when connecting to MySQL Try searching it in google R.B.Roa Traffic Management Engineer PhilCom Corporation Tel. No. (Office) (088) 858-1028 (Home) (088) 858-8889 Mobile No. (63) (919-3085267) -Original Message- From: Patricio Díaz G. [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 1:34 PM To: [EMAIL PROTECTED] Subject: MySQL Delphi 6 Can somebody help me with Delphi 6 and MySQL? I'm using Delphi en a WinXP box and the MySQL server in a Linux box. I am having trouble connecting to the server with the CLX/dbExpress TSQLConnection component. Please, if somebody can help me, let me know and I'll explain the whole situation. Regards, Patricio - 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 - 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
MySQL Delphi 6
Can somebody help me with Delphi 6 and MySQL? I'm using Delphi en a WinXP box and the MySQL server in a Linux box. I am having trouble connecting to the server with the CLX/dbExpress TSQLConnection component. Please, if somebody can help me, let me know and I'll explain the whole situation. Regards, Patricio - 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
MySQL Delphi 6
Can somebody help me with Delphi 6 and MySQL? I'm using Delphi en a WinXP box and the MySQL server in a Linux box. I am having trouble connecting to the server with the CLX/dbExpress TSQLConnection component. Please, if somebody can help me, let me know and I'll explain the whole situation. Regards, Patricio - 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