Re: monitoring mysql performance

2017-11-02 Thread Reindl Harald
Am 02.11.2017 um 20:09 schrieb Miguel González: I have a VPS Web server (Apache 2.4/PHP 7.x + Varnish 4.1) running with MySQL 5.6. I have 20 Gb of RAM. I serve Wordpress sites mainly all using innodb. So I´m thinking of ways of improving MySQL performance and of course for that, you need t

monitoring mysql performance

2017-11-02 Thread Miguel González
Hi, I have a VPS Web server (Apache 2.4/PHP 7.x + Varnish 4.1) running with MySQL 5.6. I have 20 Gb of RAM. I serve Wordpress sites mainly all using innodb. So I´m thinking of ways of improving MySQL performance and of course for that, you need to measure. Currently I´m checking, there are no

Re: generic remote command/script for monitoring MySQL instance health

2009-03-11 Thread Sven
On 3/11/09, Thomas Spahni wrote: > > I am searching for a generic command to monitor that MySQL instance is > > up and running. I don't have any know-how about the schema of the DB. > What about 'mysqladmin ping' ? Hi Thomas thank you. That was the command I searched. kind regards Sven -- M

Re: generic remote command/script for monitoring MySQL instance health

2009-03-11 Thread Thomas Spahni
On Mon, 9 Mar 2009, Sven wrote: Hi folks I am searching for a generic command to monitor that MySQL instance is up and running. I don't have any know-how about the schema of the DB. kind regards Sven Aluoor Hi What about 'mysqladmin ping' ? Regards, Thomas Spahni -- MySQL General Mailing

Re: generic remote command/script for monitoring MySQL instance health

2009-03-09 Thread walter harms
you may like to try "mytop" or watch -n10 mysql -BNA -e "show full processlist" add user,host,databasename as needed Sven schrieb: > Hi folks > > I am searching for a generic command to monitor that MySQL instance is > up and running. I don't have any know-how about the schema of the DB. > >

generic remote command/script for monitoring MySQL instance health

2009-03-09 Thread Sven
Hi folks I am searching for a generic command to monitor that MySQL instance is up and running. I don't have any know-how about the schema of the DB. kind regards Sven Aluoor -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/

Re: Monitoring MySQL availability

2009-02-27 Thread Pascal Charest
Hi, I'm using Nagios or Zabbix as a monitoring system for my/my clients infrastructures. When the client doesn't want an access to his monitoring system, I install Nagios with a couples of fine-tuned configuration/plugins. This is mainly a legacy position since I've been using that for years.

Re: Monitoring MySQL availability

2009-02-27 Thread Claudio Nanni
We monitor hundreds of production systems with Nagios, of any kind. I dont have time to search for better ones, but this is doing its job. Cheers Claudio 2009/2/27 Éric Fournier > > > > Hi everybody , > > I'm searching for a good way to monitor MySQL > availabilit

Monitoring MySQL availability

2009-02-27 Thread Éric Fournier
Hi everybody , I'm searching for a good way to monitor MySQL availability (to be able to be alerted when it goes down unplanned) and i just wanted to poke around to know which ways you people find the most efficient. Are you using third party software , scripts , s

Re: monitoring mysql

2007-07-13 Thread Yoge
You can use the Application Manager to monitor your mysql server. For more info http://manageengine.adventnet.com/products/applications_manager/mysql-management.html http://manageengine.adventnet.com/products/applications_manager/index.html --Yoge Baron Schwartz wrote:

Re: monitoring mysql

2007-07-12 Thread Baron Schwartz
Hi, John Mancuso wrote: I am running a fairly large Innodb database on mysql 5.x and would like to know what would be the best variables to monitor (for Nagios)- for instance: threads connected,Innodb_data_pending_reads,Innodb_data_pending_writes, slow queries etc This is kind of a bottoml

monitoring mysql

2007-07-10 Thread John Mancuso
I am running a fairly large Innodb database on mysql 5.x and would like to know what would be the best variables to monitor (for Nagios)- for instance: threads connected,Innodb_data_pending_reads,Innodb_data_pending_writes, slow queries etc Aborted_clients Aborted_connects Binlog_cache_disk_