Waiting for table lock

[liigi]

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?

[mflorell]

What tables are locking?

[liigi]

sorry for the delay , the table is vicidial_live_agents

[mflorell]

You can try changing that to a MEMORY type table if you first change the TEXT fields to smaller VARCHAR fields.

[liigi]

I will try, thank you very much XD

[liigi]

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

[mflorell]

Thanks for the postback!