ziva Posted November 5, 2014 Share Posted November 5, 2014 Dear, Today i have a problem that my WHMCS run SQL query very slow and give state "Waiting for table level lock". Can anyone help me to find what causing this ? FYI we already using INNODB engine on Mysql but still the query run slowly. Thanks. - - - Updated - - - One thing, because of this our WHMCS portal run very slowly when our client trying opened a ticket. - - - Updated - - - One thing, because of this our WHMCS portal run very slowly when our client trying opened a ticket. 0 Quote Link to comment Share on other sites More sharing options...
durangod Posted November 5, 2014 Share Posted November 5, 2014 describe your sever stats please. server, type, mem, os, and all versions please. 0 Quote Link to comment Share on other sites More sharing options...
ziva Posted November 5, 2014 Author Share Posted November 5, 2014 Hi, server spesification : -processor : Version: Intel® Xeon® CPU E5-2620 v2 @ 2.10GHz -motherboard: supermicro -mem: 64G -hdd: radi1(main sistem), raid10(database, using zfs) -os: debian 7.6 -mysql: 5.5 Please help us because of this our client have to wait for quote long enough about 3-5minutes just for opened a ticket on whmcs Thanks - - - Updated - - - Hi, server spesification : -processor : Version: Intel® Xeon® CPU E5-2620 v2 @ 2.10GHz -motherboard: supermicro -mem: 64G -hdd: radi1(main sistem), raid10(database, using zfs) -os: debian 7.6 -mysql: 5.5 Please help us because of this our client have to wait for quote long enough about 3-5minutes just for opened a ticket on whmcs Thanks 0 Quote Link to comment Share on other sites More sharing options...
durangod Posted November 5, 2014 Share Posted November 5, 2014 have you ask them or have you done a traceroute yourself? what version of php? is this "Waiting for table level lock" the only thing that makes you think its mysql issue or do you have other data. 0 Quote Link to comment Share on other sites More sharing options...
ziva Posted November 5, 2014 Author Share Posted November 5, 2014 not yet, but how to check this or traceroute this ? My php version is 5.3. - - - Updated - - - not yet, but how to check this or traceroute this ? My php version is 5.3. 0 Quote Link to comment Share on other sites More sharing options...
ziva Posted November 5, 2014 Author Share Posted November 5, 2014 This problem has been fix by giving an index on one table. I thinks this query more faster than usually now. Thanks - - - Updated - - - This problem has been fix by giving an index on one table. I thinks this query more faster than usually now. Thanks 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.