Waiting for table lock

Any and all non-support discussions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Waiting for table lock

Postby liigi » Mon Aug 27, 2018 2:05 pm

hello guys I come to you with this topic, which has already been touched several times but I would like to analyze my case in specific

This is my vicibox clusster Version: 2.12b0.5
SVN Version: 2578
DB Schema Version: 1464

1DB (E5-2603 v3 X2 62GB RAM RAID 10 SSD DISK)
1WEB
10 TELEPHONY SERVER

I have worked with my systems for a while without problem, however due to an increase number of agents I have been presenting problems of slowness, everything points to the BD . when reviewing the bd I see many waiting for table lock(91% of total querys) for the table live_gents . how could I improve the performance of my BD ?,.buying a MEGARAID card for now is not in my finances (for now) , i do a memory but this dosent work ,maybe make query cache adjustments?
liigi
 
Posts: 70
Joined: Wed Jul 13, 2016 4:39 pm

Re: Waiting for table lock

Postby mflorell » Mon Aug 27, 2018 4:24 pm

What tables are locking?
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Waiting for table lock

Postby liigi » Mon Sep 10, 2018 1:32 pm

sorry for the delay , the table is vicidial_live_agents
liigi
 
Posts: 70
Joined: Wed Jul 13, 2016 4:39 pm

Re: Waiting for table lock

Postby mflorell » Mon Sep 10, 2018 10:27 pm

You can try changing that to a MEMORY type table if you first change the TEXT fields to smaller VARCHAR fields.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: Waiting for table lock

Postby liigi » Tue Sep 11, 2018 8:34 am

I will try, thank you very much XD
liigi
 
Posts: 70
Joined: Wed Jul 13, 2016 4:39 pm

Re: Waiting for table lock

Postby liigi » Fri Sep 14, 2018 2:43 pm

Well I have seen a remarkable improvement, passing about 400 process pending the unlocking of the table to about 100 process

i do some changes

-Change the vicidial_agent_live table engine to memory
-Ajust the memory cache to 8 Mb (i try with 16, 32 MB and only worsen the results, default was 64mb)
-Ajust table_open_cache to =4096
-Do a optimize tables
liigi
 
Posts: 70
Joined: Wed Jul 13, 2016 4:39 pm

Re: Waiting for table lock

Postby mflorell » Sat Sep 15, 2018 6:44 am

Thanks for the postback!
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 69 guests