Thanks It would appear that MySql does table locking. Then I would like to ask the following:
We have a documents table in our Document Management System, which obviously gets used quite a lot :-). We're running stress tests on our application (which is a PHP, Apache, MySql combo) and we're finding that the database can't service requests when it comes to the documents table. The stress test approximatesw 30 users with a stress multiplier of three (basically 90 users) who both insert and query the database. Would it be reasonable to assume that when one insert occurs, MySql locks the documents table, resulting in a backlog of queries for that table? From what I've read, it would seem that SELECTS get a lower priority than INSERTS and UPDATES, meaning that if all 30 users insert into that table at the same time (given the way the stress test is structured and the environment the server will go into, this usage pattern will occur), any other select queries simply get sent to the back of the queue?? Does anyone have any suggestions here?? Thanks --- Rob ************************** Rob Cherry mailto:[EMAIL PROTECTED] +27 21 447 7440 Jam Warehouse RSA Smart Business Innovation http://www.jamwarehouse.com ************************** -----Original Message----- From: Zak Greant [mailto:[EMAIL PROTECTED]] Sent: Monday, February 17, 2003 11:10 AM To: Rob Cc: [EMAIL PROTECTED] Subject: Re: Mysql Table locking On Mon, Feb 17, 2003 at 11:00:37AM +0200, Rob wrote: > Hi all, > > Can I just check, does MySql v.3.23.52 do table locking or row locking? If > it only does table locking, are there any versions of mysql that do row > locking? Detailed in the fine manual: http://www.mysql.com/search/index.php?q=locking Cheers! -- Zak Greant <[EMAIL PROTECTED]> MySQL AB Community Advocate Personal Blog: http://zak.fooassociates.com Managing MySQL MySQL Training: Washington DC, March 19-21, 2003 Visit http://mysql.com/training for more information --------------------------------------------------------------------- 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
