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?

posted at: 15:04 | path: /mysql | permanent link to this entry
    #1 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: