Page 1 of 1
How to avoid LOCK TABLE in MariaDB
Posted:
Thu Nov 17, 2016 12:58 pmby 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!
Re: How to avoid LOCK TABLE in MariaDB
Posted:
Thu Nov 17, 2016 2:37 pmby 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
Re: How to avoid LOCK TABLE in MariaDB
Posted:
Thu Nov 17, 2016 3:51 pmby 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
Re: How to avoid LOCK TABLE in MariaDB
Posted:
Thu Nov 17, 2016 4:14 pmby 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?
Re: How to avoid LOCK TABLE in MariaDB
Posted:
Thu Nov 17, 2016 4:39 pmby 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
Re: How to avoid LOCK TABLE in MariaDB
Posted:
Thu Nov 17, 2016 8:10 pmby 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.
Re: How to avoid LOCK TABLE in MariaDB
Posted:
Fri Nov 18, 2016 5:40 pmby 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