Re: monitoring mysql performance

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

Re: monitoring tool

2012/10/10 Aastha > it should do the following: > > 1. give the status of the health of the nodes -Primary concern > What do you mean with "health of the nodes"? mysqld running? master-slaves up and sync'ed? replication not broken? you using NDB?. Still a very vague explanation. > 2. Give slow

Re: monitoring tool

...@yahoo.com From: Aastha To: Manuel Arostegui Cc: mysql@lists.mysql.com Sent: Wednesday, October 10, 2012 2:25 PM Subject: Re: monitoring tool it should do the following: 1. give the status of the health of the nodes -Primary concern 2. Give slow queries 3

Re: monitoring tool

it should do the following: 1. give the status of the health of the nodes -Primary concern 2. Give slow queries 3. NO or reads etc 4. No of users logged in 5. Other admin tasks On Wed, Oct 10, 2012 at 1:20 PM, Manuel Arostegui wrote: > > > 2012/10/10 Aastha > >> Hi, >> >> Are there any open s

Re: monitoring tool

2012/10/10 Aastha > Hi, > > Are there any open source MYSQL rela time monitoring tools available in the > market. > > Aastha > Hello Aastha, You should try to be more specific when asking for stuff. What do you want to monitor? reads/writes? QPS? threads? etc Thanks Manuel.

Re: Monitoring Sessions

have not tried the Percona tool. David. - Original Message - From: Anupam Karmarkar [mailto:sb_akarmar...@yahoo.com] Sent: Wednesday, October 10, 2012 08:02 AM To: mysql@lists.mysql.com Subject: Re: Monitoring Sessions Thanks Johan for info, We already tried with tcpdump and wireshark

Re: Monitoring Sessions

Thanks Johan for info, We already tried with tcpdump and wireshark it was helpfull. Percona tool kit i need to try. From: Johan De Meersman To: Anupam Karmarkar Cc: mysql@lists.mysql.com Sent: Wednesday, 10 October 2012 5:16 PM Subject: Re: Monitoring

Re: Monitoring Sessions

- Original Message - > From: "Anupam Karmarkar" > > How to monitor individual session number of rows selected or updated > by sessions, number of bytes sent and reviewed by session in a given > time period, sessions connects runs command and then disconnects, > SHOW GLOBAL STATUS is not h

Re: Monitoring MySQL availability

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

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

Re: Monitoring and analysis tool

Baron Schwartz wrote: Correct. But if you are willing to patch your server, you can: http://www.mysqlperformanceblog.com/2007/10/31/new-patch-for-mysql-performance/ This is in 5.1 as well now :) Regards Mark -- Mark Leith, Manager of Support, Americas MySQL AB, www.mysql.com Are you MyS

Re: Monitoring and analysis tool

Daniel, On Dec 16, 2007 12:37 PM, Daniel Caune <[EMAIL PROTECTED]> wrote: > > -Message d'origine- > > De: Mark Leith [mailto:[EMAIL PROTECTED] > > Envoyé: dimanche, décembre 16, 2007 04:53 > > À: Daniel Caune > > Cc: mysql@lists.mysql.com &g

RE: Monitoring and analysis tool

> -Message d'origine- > De : Mark Leith [mailto:[EMAIL PROTECTED] > Envoyé : dimanche, décembre 16, 2007 04:53 > À : Daniel Caune > Cc : mysql@lists.mysql.com > Objet : Re: Monitoring and analysis tool > > Daniel Caune wrote: > > Hi, > > >

Re: Monitoring and analysis tool

Daniel Caune wrote: Hi, Our MySQL server used for our development environment is slowing down, certainly because of a massive query execution by different processes. We are trying to determine which kind of query is the most executed and on which database instance(s). We are quite novice in adm

Re: monitoring mysql

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

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

Re: monitoring SQL query response times

Is there a way to monitor SQL query response times? Mysqlperformanceblog has patches for higher granularity query log: http://www.mysqlperformanceblog.com/2006/09/06/slow-query-log-analyzes-tools/ You could always just wrap the query calls in between some time registration of your own. --

Re: Monitoring Slow Queries

Thanks, Philip. On 8/2/06, Philip Hallstrom <[EMAIL PROTECTED]> wrote: .. http://hackmysql.com/mysqlsla . That's definitely of immense help. -- Thanks a zillion, Asif -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

Re: Monitoring Slow Queries

Though I understand very well that it has been discussed lots of time before but I don't have time to browse through the previous archives and dig out the stuff I need. So, guys, I would be thankful if you could give me your valuable advice that I need right now. I just need to know

Re: Monitoring Slow Queries

On Wednesday 02 August 2006 09:28, Asif Lodhi wrote: > Hi, > > Though I understand very well that it has been discussed lots of time > before but I don't have time to browse through the previous archives > and dig out the stuff I need. So, guys, I would be thankful if you > could give me your valu

Re: Monitoring replication in mysql

We use a monitoring system that does TCP based checks on our various systems and can alerts us based on criteria we define. So we right shell scripts that run locally and return certain values and tie those scripts to specific TCP ports using /etc/inetd.conf and /etc/services - This is the script w

Re: Monitoring replication in mysql

Tucker, Gabriel wrote: Anil Write a script that does a slave status and check if either of the threads are running. You could further check for error numbers and descriptions. This is what we do. Gabe -Original Message- From: Anil Doppalapudi [mailto:[EMAIL PROTECTED] Sent: Tuesday, Dece

RE: Monitoring replication in mysql

Anil Write a script that does a slave status and check if either of the threads are running. You could further check for error numbers and descriptions. This is what we do. Gabe -Original Message- From: Anil Doppalapudi [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 21, 2004 6:05 A

RE: monitoring

[snip] How are you monitoring on your databases? Who has a good solution? [/snip] What do you mean by monitoring? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Monitoring Database

BigBrother (www.bb4.com) has a plugin for MySQL. It monitors the IP port of the mysqlserver and sends you a message when it is down (or start a script and do wahtever you want e.g. start up the slave). Hugo Burm [EMAIL PROTECTED] > -Original MessageH- > From: Simon Green [mailto:[EMAIL

Re: Monitoring Database

naveed wrote: > dear simon > hello > try mysqlman its the best tool to manage database remotely > > naveed > - Original Message - > From: Simon Green <[EMAIL PROTECTED]> > To: Mysql <[EMAIL PROTECTED]> > Sent: Thursday, March 15, 2001 4:50 PM > Subject: Monitoring Database > > > Hi > > I

Re: Monitoring Database

dear simon hello try mysqlman its the best tool to manage database remotely naveed - Original Message - From: Simon Green <[EMAIL PROTECTED]> To: Mysql <[EMAIL PROTECTED]> Sent: Thursday, March 15, 2001 4:50 PM Subject: Monitoring Database > Hi > I am trying to right a program to monito