Reducing the MySQL query lock timeout?

    Apart from sniping the queries, is there any other way to reduce the amount of time that a query will wait before giving up on getting access to a locked table?

    Tags for this post: mysql(S)

posted at: 08:04 | path: /mysql | permanent link to this entry




    Sara

    What version of mysql? table_lock_wait_timeout is a configurable variable in mysql 5.0 I don't know of anything similar in 4.0/4.1, though you might be able to backport from 5.0.

    Add a comment to this post:

    Your name:

    Your email: Email me new comments on this post
      (Your email will not be published on this site, and will only be used to contact you directly with a reply to your comment if needed. Oh, and we'll use it to send you new comments on this post it you selected that checkbox.)


    Your website:

    Comments:


    Because of excessive load, this site is generated statically every several hours. Therefore, your comment may take some time to appear here. Unless you get an error message when you click the select button below, then all is normal and the comment will appear in due course.