How to avoid LOCK TABLE in MariaDB

[macaruchi]

Hi!
I am having a few problem with LOCK table using MyISAM. There is any guidance for better the behaviour with lock table in MyIsam tables?

I am using ViciBOx and I have 4 days having problems of Lock using MariaDB any help or cluee will be appreciate.

Thks!

[mflorell]

Please give more details on your system:
- hardware(including RAID controller, drives, CPU and RAM)
- number of agents
- number of phone lines
- kind of call handling

[macaruchi]

- hardware(including RAID controller, drives, CPU and RAM)
Power 8GB Ram , 8 nucleos
4.1.20-11-default #1 SMP PREEMPT Fri Mar 18 14:42:07 UTC 2016 (0a392b2) x86_64 x86_64 x86_64 GNU/Linux
vicibox7:~ # lscpu
Architecture: x86_64
CPU op-mode(s): 32-bit, 64-bit
Byte Order: Little Endian
CPU(s): 8
On-line CPU(s) list: 0-7
Thread(s) per core: 1
Core(s) per socket: 4
Socket(s): 2
NUMA node(s): 1
Vendor ID: GenuineIntel
CPU family: 6
Model: 23
Model name: Intel(R) Xeon(R) CPU L5420 @ 2.50GHz
Stepping: 6
CPU MHz: 2003.000
CPU max MHz: 2499.0000
CPU min MHz: 2003.0000
BogoMIPS: 5000.22
Virtualization: VT-x
L1d cache: 32K
L1i cache: 32K
L2 cache: 6144K
NUMA node0 CPU(s): 0-7


- number of agents
5
- number of phone lines
120
- kind of call handling
outbound campaign

ViciBox v.7.0.3-160505

[mflorell]

What brand and model of RAID controller?

What brand and model hard drives?

How many leads in vicidial_list?

Have you enabled the archiving process in the crontab?

Do you have slow query logging enabled in MariaDB?

What specific tables are locking?

[macaruchi]

What brand and model of RAID controller?
None. SATA Disk 2Tera

What brand and model hard drives?
SATA

How many leads in vicidial_list?
8000

Have you enabled the archiving process in the crontab?
- Yes
Do you have slow query logging enabled in MariaDB?
- Yes

What specific tables are locking?
-vicidial_campaign

[mflorell]

That doesn't make any sense at all, the vicidial_campaigns table is tiny, and shouldn't ever be in a locked state.

Please post the query from the slow query log that shows this.

[macaruchi]

I thougth the same , that table is so tiny but happened ... I dont have the query now but I have kept monitoring the database. Really, it is weird behaviour with this table. I had twice this situation even reboot the server before continue