MYSQL Issue

All installation and configuration problems and questions

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

MYSQL Issue

Postby prosenjit2009 » Mon Mar 18, 2019 12:49 pm

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 .
prosenjit2009
 
Posts: 38
Joined: Fri Dec 22, 2017 6:12 am

Re: MYSQL Issue

Postby omarrodriguezt » Mon Mar 18, 2019 1:40 pm

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
http://www.ITContinental.com
Dedicated USA Servers - Vicibox - Vicidial - Limesurvey - Vtiger CRM - More than 15 years experience - Hablamos Español
omarrodriguezt
 
Posts: 667
Joined: Fri Jun 05, 2009 12:22 pm
Location: Dominican Republic

Re: MYSQL Issue

Postby williamconley » Mon Mar 18, 2019 3:42 pm

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.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: MYSQL Issue

Postby prosenjit2009 » Tue Mar 19, 2019 4:43 am

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
 
Posts: 38
Joined: Fri Dec 22, 2017 6:12 am

Re: MYSQL Issue

Postby prosenjit2009 » Tue Mar 19, 2019 4:44 am

omarrodriguezt wrote: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.
prosenjit2009
 
Posts: 38
Joined: Fri Dec 22, 2017 6:12 am

Re: MYSQL Issue

Postby williamconley » Tue Mar 19, 2019 11:21 am

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.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 72 guests