Tables locked

Discussion in 'MySQL' started by ASTRAPI, Feb 3, 2010.

0
  1. #1
    Hello

    How can i check which tables are locked when i have a lot of traffic?

    Or i can view that info anytime from a log?

    I use Mysql myisam and cpanel with phpmyadmin.

    Thank you
     
    ASTRAPI, Feb 3, 2010 IP
  2. clinton

    clinton Well-Known Member

    Messages:
    2,166
    Likes Received:
    44
    Best Answers:
    0
    Trophy Points:
    110
    #2
    don't the tables unlock as soon as the mySQL query is completed?
     
    clinton, Feb 4, 2010 IP
  3. ASTRAPI

    ASTRAPI Guest

    Messages:
    500
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    I think yes but until unlock it can take long time and the forum is very slow for a long time.
     
    Last edited: Feb 4, 2010
    ASTRAPI, Feb 4, 2010 IP
  4. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #4
    Identify the queries which are taking time to execute and optimize them.
     
    mwasif, Feb 5, 2010 IP