Extended Monitoring For MySQL
Oct 30, 2009
I have 2 dedicated servers (Centos with WHM/cPanel), for the oldest server it will be great for me to have some option to monitor which users/databases are more used, I'm more interested about the "spikes" i see in the munin graphs once in a while.
This server has an average of 42 queries/second but sometimes there are some spikes of over 250 queries/second and in munin I can't see which users/databases ware causing the spike.
Curently I use munin for monitoring the server, and it's graphs are ok but I need a more detailed graphs or statistics for mysql, I searched munin plugins but there's no plugins to show the user or database which gets the most queries.
how can I see which user/database had more queries?
I attached a graph generated by munin, you can see the spike, I seen the spike after about one hour, when the traffic was normal, and the page in WHM - Mysql Processes couldn't help me because there's no history.
View 5 Replies
ADVERTISEMENT
Jan 8, 2007
Just turned on extended logging in exim. Went through the log (exim_mainlog) and have thousands of these:
2007-01-08 01:44:10 cwd=/tmp 2 args: /usr/sbin/sendmail -bS
2007-01-08 01:44:12 cwd=/tmp 2 args: /usr/sbin/sendmail -ti
2007-01-08 01:44:50 cwd=/tmp 2 args: /usr/sbin/sendmail -bS
Looked in the /tmp dir. and see nothing interesting. Looks like sendmail has been hijacked. Not sure what to look for now.
View 0 Replies
View Related
Dec 10, 2007
What this does is amongst others is to add "SHOW USER_STATISTICS"
statement do MySQL. What this does is keep statistics on which users on your mysql machine is spending the most time processing queries.
It is also mentioned here: [url]
If you believe this functionality could be important to our industry you are more than welcome to vote for this or add comments to the following feature request:
[url]
View 2 Replies
View Related
Jan 30, 2008
i am getting these error in my shoutcast server...after while the server is in these port is crashing...wha exactly is these
[yp_add] yp.shoutcast.com gave extended error (Please identify this station's genre (in the dsp plugin YP tab).
View 4 Replies
View Related
May 8, 2009
Since my /var partition is full, so I moved /var/lib/mysql to /backup/mysql/.
Seems all the files are copied and I changed my.cnf reboot mysql, but all the web sites using db is not working anymore..
View 4 Replies
View Related
Jan 18, 2008
way to monitor my servers cpu load, but more importantly is there a way to monitor which php scripts are using the most resources? i have searched around and haven't found much information. i use fedora, apache, mysql just so you know.
View 4 Replies
View Related
Jun 24, 2007
external monitoring services for http, ftp, mail, uptime, ping, etc; preferably with some reporting options.
I have been using uppanel.com but am looking for a service with more regular checks and no limitations.
View 9 Replies
View Related
Sep 22, 2007
to monitor our VPS's customers, not our up time but our VPS customer sites resource usage.
Maybe a mixture between TOP/PS and WHM|Server Status|Apache Status
Summarized by domain in a period of time.
Our VPS is going blackzone many times/day and I need to find in real time the actual offending site or application.
I need something that tell me in plain english:
- Site XXX is taking all your VPS resources
- Application XXX is just bombing your VPS
- Close port XXX because your're under hacking
View 12 Replies
View Related
Jan 21, 2007
I installed the MySQL binary packages in /usr/local/mysql/ after removing the MySQL RPM package. MySQL is functioning when I executed /usr/local/mysql/bin/safe_mysqld. I reinstalled MySQL before I installed PHP. When I used a PHP script to access a MySQL database, it outputs an error:
Code:
Warning: mysqli::mysqli() [function.mysqli-mysqli]: (HY000/2002): can't connect to local mysql server through socket /var/lib/mysql/mysql.sock in index.php on line 2
However, I installed MySQL in /usr/local/mysql, not in /var/lib/mysql. How do I fix MySQL?
View 1 Replies
View Related
Jun 19, 2007
Plz show me some software which monitor bandwidth for each website used.
OS : Windows 2003 ENterprise
View 2 Replies
View Related
Jul 9, 2008
Any website monitoring tools available that can tell you when a site is unavailable and/ or other tests/checks?
View 10 Replies
View Related
Oct 22, 2009
a product that I can install on my windows or mac machine to monitor my Centos webserver for CPU usage, Memory usage, Uptime and etc.
View 10 Replies
View Related
Mar 29, 2009
Does anyone know any good system for monitoring if a server is online?
View 11 Replies
View Related
Jul 24, 2009
I just stop httpd service for server maintainance , and disable its monitoring from whm services, but after some time it again start even i disable httpd monitoring and service.
View 6 Replies
View Related
Apr 25, 2009
Anyone know a good Server Monitoring Software that runs on Windows Server 2003?
View 4 Replies
View Related
Jan 3, 2009
Do you use any uptime monitoring service? If so, which one do you use? Do you use a paid monitoring service, or a free one?
View 14 Replies
View Related
May 26, 2008
been using webserverguard.com to monitor my server which has been great because its free. Thinking of upgrading to a paid service and wondered what the good cheap options were?
View 14 Replies
View Related
Dec 20, 2008
Best monitoring application?
We need a good (best?) network/hardware monitoring application for monitoring our servers located at 3 different datacenters and around 50 servers.. I've founded some programs but they don't cover my needs 100%
Basicly I need these;
- Adding servers easily.
- Adding monitoring channel for each servers. (load, network, disk/ram usage etc..)
- Adding users and attaching users to servers seperately.
(For example I will add justify user and attach him to server1, will add wht user and attach him the server2 and their permissions will be different and they will have no control on other's servers.)
- Web based controller for users/admins
- I want to install it to my windows/linux servers and monitor all remotely..
- SMS / mms / msn / email / icq notifications.
- Ability to post/get notification.
View 11 Replies
View Related
May 1, 2008
What are some good monitoring companies that can keep track of downtime. Even more specifically looking for companies that can send an sms alert or possibly reboot the server following ceartin instructions during a downtime.
Though please provide all suggestion (even if they don't do the above).
View 14 Replies
View Related
Nov 10, 2008
Give me 1000GB or 2000GB and that's my limit that I'll try and not go over. Pretty
simple.
However, I'm now dealing with a provider that has me really confused. This company is charging us based on 95th percentile and we're now being asked to commit to 8.5 MBPS while the server doesn't even go over 1500GB monthly bandwidth limit.
Is this correct:
- We're not using tons of bandwidth but we do have large bursts
- The company is ultimately charging you for the bursts
View 4 Replies
View Related
Jul 16, 2008
how can i find out who is using up all the resources of 1 of my server, i am running CENTOS Enterprise 5.2 i686 on standard - WHM X v3.1.0, i have around 180 web site currently on this server and i would like to move my customer how need more power.
or limit my customers to 10% of the server resources for no longer than 10min.
View 3 Replies
View Related
May 12, 2008
I'm currently gathering a list of all VPS providers that offer proactive VPS (services etc...) monitoring. So far I know that Wiredtree and Liquidweb include it and Zone.net and Futurehosting (to a limited extent) offers it as an add-on. Anyone else have any that they know of?
View 12 Replies
View Related
Jul 1, 2008
my dedicated server have a remot reboot panel and i want company monitor my server with less than $10 per month until my server if goes down reboot it from my panel...
View 9 Replies
View Related
Jun 18, 2008
I'd like to know if there are good monitoring services to monitor my VPS.
Not just the website,but everything on the VPS.
I know there is Hyperspin,but i need more to look at.
I want to get an alert by email if there is something wrong with my server.
Also i'd like to receive daily reports by email.
View 13 Replies
View Related
Jan 5, 2007
any DVR / IP Cams, etc setup like the Geovision setup.
what you are running hardware/software wise.
View 0 Replies
View Related
Dec 27, 2007
I have 1 network interface with a few virtual ones. I need to find a way to monitor bandwidth. I've tried vnstat but it can't measure bandwidth with virtual interfaces.
The only thing i've seen is through packet sniffing and i was hoping for a much cheaper alternative(cpu wise).
View 2 Replies
View Related
Jan 6, 2007
if there wre tools which can monitor the server load/apache/mysql and suggest settings to optimize apache/mysql/php?
View 3 Replies
View Related
Sep 21, 2007
Does anyone run any defacement monitoring software? I'm looking for something that will send me an email alert whenever changes have been made to files or folders on my web server. It could be a file or folder watcher I just would like it to notify me whenever changes are made to a file or folder. I have searched but found nothing reliable.
View 10 Replies
View Related
Nov 28, 2007
we have a large number of dell server like Pe 850-860, Sc1425-1435, Pe1850-1950, we are try to find a solution to monitor the server hardware like raid status, fan, ram, controller etc, we have try to use ITassistant but seem that work only with server with Drac card or we should install on each box OMSA, so i would know what different solution can we use.
View 2 Replies
View Related
Jun 9, 2007
I'm trying to do up a gameserver monitoring script whereby, I'm able to check if a particular game service is up or down.
In this example, I'm trying to check if the port 7777 is up (Unreal Tournament server).
PHP Code:
<?php$server = "xxx.xxx.xxx.xx";$fp = fsockopen("$server",7777,$errno,$errstr,30); if ($fp) { $fplist = green; } else { fclose($fp); $fplist = red; }?>Colour is <?php echo $fplist; ?>
I've tried this on an actual UT server which is currently online, but for some reason, it keeps on giving me red (to signify a down service).
View 2 Replies
View Related
Sep 25, 2007
Spamd often died once in a while. How do i set up an auto monitoring and restart it if it dies? Btw, i'm on a Unix machine.
View 14 Replies
View Related
