MYSQL Issue

[prosenjit2009]

HP ProLiant DL160 G5

Server type- ProLiant DL160 G5
32 GB RAM
8 Core CPU
CPU TYPE-XEON 3.0
VERSION: 2.14-703a
BUILD: 190311-2153
SVN version :3073
DB Schema Version:1565
ASTERISK VERSION-11.25.3
INSTALLER VERSION-8.0.1
No PRI/SANGOMA
No Extra Software or hardware.



I have a serious issue now. i have 35 agents making out bound ratio dialing. everything was fine since yesterday. Today after couple of hour,s I suddenly found have huge load on database.I got to see almost 300 query in ques. as results slow loading , agent going in pause automatically. i have check in TOP command. all seems normal.

https://ibb.co/3c29k06. I am attaching the image. Last week i upgrade my svn. is this related withat that ?

pls. help me out .

[omarrodriguezt]

Hello,
You have a table locked or corrupted.
Try:
SHOW OPEN TABLES WHERE In_use > 0

also
mysqlcheck -u root -p --auto-repair -c -o --all-databases

[williamconley]

1) This is a support request, not a "general discussion". moving to the appropriate board.

2) "Last week i upgrade my svn." Upgrading the files in /usr/src/astguiclient/trunk (which is the svn location) has no effect on the running system. However, upgrading the DB and installing the scripts definitely does have an effect. So it would be very useful if you would be a bit more specific. Did you follow the instructions in the UPGRADE document in that folder and perform a full system upgrade to that version of SVN? Or did you just run the install.pl script? Or did you just upgrade the DB?

3) Image doesn't load.

[prosenjit2009]

Hello William,

I followed the procedure as described in upgrade documents.And i am upgrading DB and and svn more than year and never faced any issue. I have 15GB database but dont,t archive on regular basis.

pls. suggest further.
I am attaching that image again.

https://imgur.com/ysoXmJB

[prosenjit2009]

Hello,
You have a table locked or corrupted.
Try:
SHOW OPEN TABLES WHERE In_use > 0

also
mysqlcheck -u root -p --auto-repair -c -o --all-databases

I already repaired the DB. and archived all backdated tables. lets see today.

[williamconley]

you showed a list where half were idle and half were waiting for lock. But that was only some of the list and obviously if those are waiting for the locked table, there's a query up there somewhere that is locking those tables. That's the query you want to discuss. The one at the front of the pack.

You're like the cop at the back end of a traffic jam: You need to get to the front of that line to see the actual participants in the accident.