The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

mysqp problem with locked tabled

Discussion in 'General Discussion' started by dropby23, Dec 3, 2005.

  1. dropby23

    dropby23 Well-Known Member

    Joined:
    Jan 16, 2005
    Messages:
    155
    Likes Received:
    0
    Trophy Points:
    16
    we have some problems with locked tables
    Code:
     708722 | apotokyo_apotoky | localhost | apotokyo_forum       | Query   | 1031 | Locked         | INSERT INTO smf_log_errors
    			(ID_MEMBER, logTime, IP, url, message, session)
    		VALUES (77, 11336347 |
    | 708871 | apotokyo_apotoky | localhost | apotokyo_forum       | Query   | 969  | Locked         | INSERT INTO smf_log_errors
    			(ID_MEMBER, logTime, IP, url, message, session)
    		VALUES (229, 1133634 |
    | 709037 | apotokyo_apotoky | localhost | apotokyo_forum       | Query   | 908  | Locked         | INSERT INTO smf_log_errors
    			(ID_MEMBER, logTime, IP, url, message, session)
    		VALUES (77, 11336348 |
    | 709237 | apotokyo_apotoky | localhost | apotokyo_forum       | Query   | 824  | Locked         | INSERT INTO smf_log_errors
    			(ID_MEMBER, logTime, IP, url, message, session)
    		VALUES (77, 11336349 
    some querys get locked and they start to consume alot of cpu is there a wat to bypass that locked querys or prevent them from getting locked
     
  2. dropby23

    dropby23 Well-Known Member

    Joined:
    Jan 16, 2005
    Messages:
    155
    Likes Received:
    0
    Trophy Points:
    16
    another example
    Code:
    | 1116 | forumpay       | localhost | forumpay_paylasforum | Query   | 1274 | Locked | INSERT INTO threadviews (threadid)
    		VALUES (5915) |
    | 1228 | forumpay       | localhost | forumpay_paylasforum | Query   | 1226 | Locked | INSERT INTO threadviews (threadid)
    		VALUES (5915) |
    | 1237 | forumpay       | localhost | forumpay_paylasforum | Query   | 1220 | Locked | INSERT INTO threadviews (threadid)
    		VALUES (5914) |
    | 1244 | forumpay       | localhost | forumpay_paylasforum | Query   | 1214 | Locked | INSERT INTO threadviews (threadid)
    		VALUES (5911) |
    | 1249 | forumpay       | localhost | forumpay_paylasforum | Query   | 1212 | Locked | INSERT INTO threadviews (threadid)
    		VALUES (5910) |
    | 1265 | forumpay       | localhost | forumpay_paylasforum | Query   | 1206 | Locked | INSERT INTO threadviews (threadid)
    		VALUES (5908) |
    | 1309 | forumpay       | localhost | forumpay_paylasforum | Query   | 1182 | Locked | INSERT INTO threadviews (threadid)
    		VALUES (5915) |
    | 1408 | forumpay       | localhost | forumpay_paylasforum | Query   | 1141 | Locked | INSERT INTO threadviews (threadid)
    		VALUES (5915) |
    | 1409 | forumpay       | localhost | forumpay_paylasforum | Query   | 1144 | Locked | INSERT INTO threadviews (threadid)
    		VALUES (5911) |
    | 1411 | forumpay       | localhost | forumpay_paylasforum | Query   | 1144 | Locked | INSERT INTO threadviews (threadid)
    		VALUES (5910) |
    | 1430 | forumpay       | localhost | forumpay_paylasforum | Query   | 1132 | Locked | INSERT INTO threadviews (threadid)
    		VALUES (5915) |
    | 1434 | forumpay       | localhost | forumpay_paylasforum | Query   | 1131 | Locked | INSERT INTO threadviews (threadid)
    		VALUES (5910) |
    | 1435 | forumpay       | localhost | forumpay_paylasforum | Query   | 1133 | Locked | INSERT INTO threadviews (threadid)
    		VALUES (5911) |
    | 1515 | forumpay       | localhost | forumpay_paylasforum | Query   | 1105 | Locked | INSERT INTO threadviews (threadid)
    		VALUES (5890) |
    | 1957 | forumpay       | localhost | forumpay_paylasforum | Query   | 930  | Locked | INSERT INTO threadviews (threadid)
    		VALUES (5867) |
    | 2147 | forumpay       | localhost | forumpay_paylasforum | Query   | 862  | Locked | INSERT INTO threadviews (threadid)
    		VALUES (4881) |
    | 2249 | forumpay       | localhost | forumpay_paylasforum | Query   | 824  | Locked | INSERT INTO threadviews (threadid)
    		VALUES (4881) |
    | 2271 | forumpay       | localhost | forumpay_paylasforum | Query   | 817  | Locked | INSERT INTO threadviews (threadid)
    		VALUES (4881) |
    | 2340 | forumpay       | localhost | f
     
Loading...

Share This Page