I have a similar question.
I'm using InnoDb table type (ver 3.23.53), according to the web side, it does a row level locking. Does this mean that I don't need to do any table locking during the Update/Delete/Insert queries?? How do I test it that It really doing the locking (other than take you word ;-) )
Thanks
VInita
Stephen Aichele wrote:
Hello. MySQL newbie here.
I've managed to build my first web database using MySQL and accessing
it with Python CGI scripts. I only have two tables going, and not
many columns per table, but I'm suspecting that there will be many
calls to INSERT, UPDATE, and SELECT.
So my question is this: do I need to use explicit locking to make
this work well in a web environment? Or will the implicit locking of
MySQL handle all the dirty work?
thanks.
Stephen
---------------------------------------------------------------------
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
