How to monitor Database

Any and all non-support discussions

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

How to monitor Database

Postby jdaano » Wed Sep 14, 2016 8:55 am

Hi guys.. im just a level 1 IT support
Just ask if how to know if our Database is running good..
Were using Vicibox
what i do is running the HTOP command to show the load and memory.
is there anything aside from that. to know our database is at good performance.
thanks all
jdaano
 
Posts: 2
Joined: Wed Jun 01, 2016 9:06 am

Re: How to monitor Database

Postby covarrubiasgg » Thu Sep 15, 2016 12:57 pm

Try with mtop , it will display in red all the queries that are taking too long.
covarrubiasgg
 
Posts: 420
Joined: Thu Jun 10, 2010 10:20 am
Location: Tijuana, Mexico

Re: How to monitor Database

Postby williamconley » Thu Sep 15, 2016 9:52 pm

Code: Select all
mysql -u cron -p1234 asterisk -e"show processlist"


Which shows the same stuff as mtop and mytop, but does not fail to configure itself properly as those other packages often do. LOL.

If you want to "keep an eye on it" for a while:
Code: Select all
watch -n 1 "mysql -u cron -p1234 asterisk -e'show processlist' | grep Sleep -v"


Trust me, if the server starts sweating, you'll notice it. LOL
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: How to monitor Database

Postby covarrubiasgg » Fri Sep 16, 2016 12:53 pm

williamconley wrote:
Trust me, if the server starts sweating, you'll notice it. LOL


xD thats when the fun starts xD .
covarrubiasgg
 
Posts: 420
Joined: Thu Jun 10, 2010 10:20 am
Location: Tijuana, Mexico


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 60 guests