How to avoid LOCK TABLE in MariaDB

Any and all non-support discussions

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

How to avoid LOCK TABLE in MariaDB

Postby macaruchi » Thu Nov 17, 2016 12:58 pm

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!
*------------------
ViciBox 7.0.4 | Version:2.14-704a | SVN Version: 3078| DB Schema Version:1566| BUILD: 190312-0928 | 2 Processors 8 Core | 32 GB Ram | 1 Tera HD
macaruchi
 
Posts: 131
Joined: Wed Sep 21, 2016 8:11 pm

Re: How to avoid LOCK TABLE in MariaDB

Postby mflorell » Thu Nov 17, 2016 2:37 pm

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
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: How to avoid LOCK TABLE in MariaDB

Postby macaruchi » Thu Nov 17, 2016 3:51 pm

- 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
*------------------
ViciBox 7.0.4 | Version:2.14-704a | SVN Version: 3078| DB Schema Version:1566| BUILD: 190312-0928 | 2 Processors 8 Core | 32 GB Ram | 1 Tera HD
macaruchi
 
Posts: 131
Joined: Wed Sep 21, 2016 8:11 pm

Re: How to avoid LOCK TABLE in MariaDB

Postby mflorell » Thu Nov 17, 2016 4:14 pm

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?
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: How to avoid LOCK TABLE in MariaDB

Postby macaruchi » Thu Nov 17, 2016 4:39 pm

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
*------------------
ViciBox 7.0.4 | Version:2.14-704a | SVN Version: 3078| DB Schema Version:1566| BUILD: 190312-0928 | 2 Processors 8 Core | 32 GB Ram | 1 Tera HD
macaruchi
 
Posts: 131
Joined: Wed Sep 21, 2016 8:11 pm

Re: How to avoid LOCK TABLE in MariaDB

Postby mflorell » Thu Nov 17, 2016 8:10 pm

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.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: How to avoid LOCK TABLE in MariaDB

Postby macaruchi » Fri Nov 18, 2016 5:40 pm

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
*------------------
ViciBox 7.0.4 | Version:2.14-704a | SVN Version: 3078| DB Schema Version:1566| BUILD: 190312-0928 | 2 Processors 8 Core | 32 GB Ram | 1 Tera HD
macaruchi
 
Posts: 131
Joined: Wed Sep 21, 2016 8:11 pm


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 29 guests