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

monitoring mysql performance

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

ANN: MySQL Performance Monitoring

Greetings MySQL users -- If MySQL monitoring is something you are doing with one specific tool -- or not at all -- then you might find this blog post on MySQL Performance Monitoring in SPM worth a read: http://wp.me/pwdA7-Xo We frequently hear from organizations across industries who tackle

Re: Mysql Monitoring with Graphite

I am using graphite, but what exactly do you want to graph? For mysql graphing I actually use nagios plugin called check_mysql_health along with check_mk/pnp4nagios That works really well. On Fri, Feb 22, 2013 at 2:24 AM, Johan De Meersman wrote: > - Original Message - >> From: "Adars

Re: Mysql Monitoring with Graphite

- Original Message - > From: "Adarsh Sharma" > > Anyone has any idea about this. Unless someone else here is using Graphite (I've never even heard of it, tbh) I think this may be something for the Graphite support channels, instead. -- Unhappiness is discouraged and will be corrected

Re: Mysql Monitoring with Graphite

Anyone has any idea about this. On Thu, Feb 21, 2013 at 7:42 PM, Adarsh Sharma wrote: > Hi all, > > I need to set up mysql monitoring graphs in Graphite. I am able to monitor > > basic system metrics after runnning example-client.py that comes with > graphite installation. &g

Mysql Monitoring with Graphite

Hi all, I need to set up mysql monitoring graphs in Graphite. I am able to monitor basic system metrics after runnning example-client.py that comes with graphite installation. when i m looking for mysql plugin for graphite , i find MySQLPerfCollector.py but when i am running it after installing

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

Typical monitoring systems, such as Nagios, Zenoss, etc... for example, provide both a typical configuration model out the box as well as the ability to write any checks you may need for your specific environment.  You should have some level of success with any of these. -Garot   garotconk

Re: monitoring tool

t; >> 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 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.

monitoring tool

Hi, Are there any open source MYSQL rela time monitoring tools available in the market. Aastha

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

Monitoring Sessions

Hi All, 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 helping me in this case as i want low level session detai

New releases of Percona Toolkit, Percona Monitoring Plugins

upgrade to the latest versions of the tools. Percona Toolkit is a collection of advanced command-line tools to perform a variety of MySQL and system tasks that are too difficult or complex to perform manually. More details: http://goo.gl/cKOVP Percona Monitoring Plugins version 1.0.1 is released.

Re: MySQL command line remote monitoring tool for 5.0

Innotop can satisfy you demand. On Thu, Apr 16, 2009 at 4:36 PM, Hitesh Shah wrote: > Hello, > I'd like to know if there is a command line tool I can run to collect > vital health information for a remote mysql server (just like > mysqltop) for 5.0 - I often see mysql swapping to disk and would

MySQL command line remote monitoring tool for 5.0

Hello, I'd like to know if there is a command line tool I can run to collect vital health information for a remote mysql server (just like mysqltop) for 5.0 - I often see mysql swapping to disk and would like to know what causes that. Thanks Hitesh -- MySQL General Mailing List For list archives

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

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

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

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

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

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

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

Monitoring MySQL availability

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 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

Monitoring and analysis tool

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 administrating MySQL. We

monitoring utility

Hi, I have a website running on Linux based cluster server. We don't have access to logs, nor we have ssh access. I want monitor mysql server usage of my site for the purpose of optimizing my site scripts. Pls suggest php based application. -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT C

Re: monitoring mysql

d of a bottomless question. Some people just monitor everything, period, in case they ever want to look back. Good general suggestions are in Kristian's talk from the MySQL conference earlier this year: http://mysqldump.azundris.com/archives/68-Monitoring-MySQL.html Baron -- Yoge, AdventNe

Re: monitoring mysql

bottomless question. Some people just monitor everything, period, in case they ever want to look back. Good general suggestions are in Kristian's talk from the MySQL conference earlier this year: http://mysqldump.azundris.com/archives/68-Monitoring-MySQL.html Baron -- MySQL General Mailing

monitoring mysql

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_

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. --

monitoring SQL query response times

Is there a way to monitor SQL query response times? Here's my current my.cnf relating to logs, but I only see response times in the slow query log, and even then, the response time is rounded to the nearest second. log=/logs/mysql.log log-error=/logs/mysql-error.log log-slow-queries=/logs/mysql-

Monitoring for corrupt tables and transiently failing master INSERTs

We're trying to write a monitoring process for our master so that if a table is corrupt it will raise flags which can then trigger operations. We can do the basic stuff such as asserting that the port is open and that we can ping the machine but I want to test if any INSERT/UPDATE/DELETE

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

Monitoring Slow Queries

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 valuable advice that I need right now. I just need to know

Re: remote monitoring of mySQL

Andy Ford ha scritto: > Can I do it with DBD::Perl > DBD::Mysql is a good module and you can control mysql status... You can do a lot of select and you can send them functions as createdb, shutdown or reload. I use this module in my mysql databases (i've only one server not many as you have...)

RE: remote monitoring of mySQL

From: Andy Ford Sent: 06 July 2006 17:06 > > What would be the best approach to remote monitoring of numerous mySQL > databases remotely i.e. number of threads. number of open > tables etc etc > > Can I do it with DBD::Perl You could, run queries such as SHOW STATUS;

remote monitoring of mySQL

What would be the best approach to remote monitoring of numerous mySQL databases remotely i.e. number of threads. number of open tables etc etc Can I do it with DBD::Perl Thanks Andy -- perl -e "print qq^bIG VeRN ! ^^qq^#'#Yv#=http://lists.mysql.com/mysql To unsubscrib

SNMP monitoring of mysql servers

Hi all, We have an implementation of mysql servers, and are looking for a decent SNMP monitoring package for them. We are looking to monitor replication, queries per second, throughput, and slow queries. Are there any decent packages that easily integrate? Regards, Matthew Juszczak

Monitoring...

Hey folks, Anyone know a Unix monitoring (text-based) software to check in realtime the usage of a MySQL server? Like nmon, topas, top or something like that but for MySQL except mytop? Thanks -- Sébastien Roy Administrateur de Systèmes Senior / Senior System Administrator PointPub

Re: MySQL table growth monitoring via RRDtool and histographs?

On Tue, Nov 01, 2005 at 02:38:29PM -0800, Kevin Burton wrote: > Gangla and Cacti seem to do similar tasks (if you stretch them) but > they really fall down fast. Can you elaborate on 'fall down fast'? It should be a really simple operation to do this in cacti. -Jason Martin -- SYSTEM ERROR: pre

MySQL table growth monitoring via RRDtool and histographs?

Hey. I'm looking for a decent tool which uses crontab to monitor the COUNT of tables within MySQL. I'd also like to monitor other queries as well. Ideally it would use RRDtool to log the data and a PHP to draw the UI. Gangla and Cacti seem to do similar tasks (if you stretch them) but

Re: parsing show commands (for monitoring/logging)

thanks but I already have a bash version that logs to local filesystem (then hacks the log into insert statements). what I'm working on is something to log to another MySQL DB (outside replication environment) to which I point (f)cgi (, etc.) I think I've answered my own ?: it seems DBI will par

Re: parsing show commands (for monitoring/logging)

does MySQL have a "pretty" way to persist snapshots of various show commands? for example in Oracle you could just do: insert into sysstat_log select sysdate, * from v$sysstat; --(an ugly, overly simple example) can the show commands be called/parsed with DBD/DBI? so far the only way I've

parsing show commands (for monitoring/logging)

does MySQL have a "pretty" way to persist snapshots of various show commands? for example in Oracle you could just do: insert into sysstat_log select sysdate, * from v$sysstat; --(an ugly, overly simple example) can the show commands be called/parsed with DBD/DBI? so far the only way I've com

mysql tablespace monitoring

First of all, thanks for the mailing list for giving details about myisamchk.we used them but we got some errors which I have reported in 'myisamchk errors' mail to mysql. At present we are working in mysql 3.23.32 ,windows xp os. Are there any system tables that store mysql related info.(like me

please advise on mysql memory,users monitoring

First of all, thanks for the mailing list for giving details about myisamchk.we used them but we got some errors which I have reported in 'myisamchk errors' mail to mysql. At present we are working in mysql 3.23.32 ,windows xp os. Are there any system tables that store mysql related info.(like me

mysql memory,users monitoring

First of all, thanks for the mailing list for giving details about myisamchk.we used them but we got some errors which I have reported in 'myisamchk errors' mail to mysql. At present we are working in mysql 3.23.32 ,windows xp os. Are there any system tables that store mysql related info.(like

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

mysql memory,users monitoring

First of all, thanks for the mailing list for giving details about myisamchk. At present we are working in mysql 3.23.32 ,windows xp os. Are there any system tables that store mysql related info.(like memory related issues etc). Are there any other ways to find memory used and free memory av

Re: Monitoring replication in mysql

, December 21, 2004 6:05 AM To: [EMAIL PROTECTED] Subject: Monitoring replication in mysql Hi, we have no of mysql replication setups in our setup. how to monitor those replication setups.my aim is if any slave goes down my script should immediately send an alert mail to me. if anybody having already

RE: Monitoring replication in mysql

AM To: [EMAIL PROTECTED] Subject: Monitoring replication in mysql Hi, we have no of mysql replication setups in our setup. how to monitor those replication setups.my aim is if any slave goes down my script should immediately send an alert mail to me. if anybody having already developed scripts

Monitoring replication in mysql

Hi, we have no of mysql replication setups in our setup. how to monitor those replication setups.my aim is if any slave goes down my script should immediately send an alert mail to me. if anybody having already developed scripts please let me know otherwise just give me an idea what to monitor in

graphical innodb status monitoring

Hi all, Does anyone know of a graphical monitor for innodb status? Something like RRD, or that integrates with RRD? I'm looking to set up status monitoring for a group of 20 servers, and this would be a very big help in diagnosing problems. Thanks for your time, Devananda van der Veen Ne

Re: innodb monitoring

phill" ([EMAIL PROTECTED]) Subject: innodb monitoring This is the only article in this thread View: Original Format Newsgroups: mailing.database.myodbc Date: 2004-10-05 11:29:24 PST I notice the following special tables innodb_monitor, = innodb_lock_monitor, innodb_tablespace_monitor, innodb_tab

innodb monitoring

I notice the following special tables innodb_monitor, innodb_lock_monitor, innodb_tablespace_monitor, innodb_table_monitor, and innodb_validate. The information from the first can be accessed from the MySQL client prompt with show innodb status without creating the table and watch standard output

Re: Process Monitoring

> The timestamp is when the query was written to the log. You will have to > subtract the query time to get when the query began. Unless you have queries > that are running for long durations the timestamp and actual time should be > close. OK, so, slow query shouldn´t be my problem, because there

RE: Process Monitoring

captured or monitored the CPU and memory usage during this time? -Original Message- From: Ronan Lucio To: Victor Pendleton; [EMAIL PROTECTED] Sent: 4/20/04 3:34 PM Subject: Re: Process Monitoring Victor, > Do you have any around the approximate time? I know the time that the problem occur

Re: Process Monitoring

On Tue, Apr 20, 2004 at 01:13:14PM -0700, Eric wrote: > Hi, > > The mysql administrator tool is a lot better for this. They still > seem to be working out some bugs, but there is a lot of flexibility > with the graphs. I have been able to see peaks in bandwidth and > queries that I never noticed

Re: Process Monitoring

Victor, > Do you have any around the approximate time? I know the time that the problem occurred. In the slow-log, it shows the line "Time". Is it line the hour the query ran? > The timestamp will be will the > query was written to the slow log and how long it took. What are the > symptoms that

RE: Process Monitoring

] Sent: 4/20/04 3:20 PM Subject: Re: Process Monitoring Victor, > Are you logging slow queries? If so, have you looked in the slow query log? Yes, I am. But, it shows many of them and no one at this time. Or, it doesn´t show slow queries when the problem is occurring. I restarted the server 1 h

Re: Process Monitoring

Victor, > Are you logging slow queries? If so, have you looked in the slow query log? Yes, I am. But, it shows many of them and no one at this time. Or, it doesn´t show slow queries when the problem is occurring. I restarted the server 1 hour ago and after I did it, the server seems to be OK. I

Re: Process Monitoring

> To: <[EMAIL PROTECTED]> >cc: >Subject:Process Monitoring > > >Hi, > >We have a MySQL-Server-4.0.17 installed in our enterprise >working fine... :-) > >Some times our application takes too bandwidth from the >database serve

RE: Process Monitoring

Are you logging slow queries? If so, have you looked in the slow query log? -Original Message- From: Ronan Lucio To: [EMAIL PROTECTED] Sent: 4/20/04 1:58 PM Subject: Process Monitoring Hi, We have a MySQL-Server-4.0.17 installed in our enterprise working fine... :-) Some times our

Re: Process Monitoring

try getting 'mytop'. Do a google on it... It's like the 'top' utility, but displays information regarding mysql procs. P "Ronan Lucio" <[EMAIL PROTECTED]> 04/20/2004 06:58 PM To: <[EMAIL PROTECTED]> cc: Subj

Process Monitoring

Hi, We have a MySQL-Server-4.0.17 installed in our enterprise working fine... :-) Some times our application takes too bandwidth from the database server. So, I´m trying to figure out what (perhaps what select) is taking so manu bandwidth. SHOW FULL PROCESSLIST shows me the follow: mysql> show

Re: Usage Monitoring

On Wed, Sep 24, 2003 at 09:54:12AM -0400, John May wrote: > Will this show usage per-database, or only for the server overall? Overall. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 10 days, proc

Re: Usage Monitoring

Will this show usage per-database, or only for the server overall? - John Might try mytop (search google for it) .. jeremy z wrote it.. it works well for realtime monitoring.. On Tue, 23 Sep 2003, John May wrote: Is there any way to monitor which databases are being used the most heavily on

Re: Usage Monitoring

EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, September 23, 2003 10:00 PM Subject: Re: Usage Monitoring > On Tue, Sep 23, 2003 at 09:12:46PM -0700, David Griffiths wrote: > > If you're using InnoDB, then that's not exactly true. > > > > >From the

Re: Usage Monitoring

On Tue, Sep 23, 2003 at 09:12:46PM -0700, David Griffiths wrote: > If you're using InnoDB, then that's not exactly true. > > >From the msql client, you can type "show innodb status" and you'll get a > bunch of stats on the database, which include: > > -- > ROW OPERATIONS > ---

Re: Usage Monitoring

]> Sent: Tuesday, September 23, 2003 8:27 PM Subject: Re: Usage Monitoring > On Tue, Sep 23, 2003 at 09:30:14PM -0400, John May wrote: > > Is there any way to monitor which databases are being used the most > > heavily on a MySQL server? Thanks for any info! > > No. MySQL

Re: Usage Monitoring

On Tue, Sep 23, 2003 at 09:30:14PM -0400, John May wrote: > Is there any way to monitor which databases are being used the most > heavily on a MySQL server? Thanks for any info! No. MySQL doesn't keep per-database statistics. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!

Re: Usage Monitoring

Might try mytop (search google for it) .. jeremy z wrote it.. it works well for realtime monitoring.. On Tue, 23 Sep 2003, John May wrote: > Is there any way to monitor which databases are being used the most > heavily on a MySQL server? Thanks for any info! > >

Re: Usage Monitoring

Mytop ? > Is there any way to monitor which databases are being used the most > heavily on a MySQL server? Thanks for any info! > > - John > > -- > > --- > John May : President > P

Usage Monitoring

Is there any way to monitor which databases are being used the most heavily on a MySQL server? Thanks for any info! - John -- --- John May : President Point In Space Internet Solutio

FW: monitoring [from an off-list reply]

-Original Message- From: Moritz Steiner [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 16, 2003 10:46 AM To: Jay Blanchard Subject: AW: monitoring I want to see: Number of queries Number of Connections Network Data In/Out Key writes Key reads Types of queries Temporary and

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]

monitoring

How are you monitoring on your databases? Who has a good solution? Moritz

RE: mysql monitoring

345466 -Original Message- From: Dr. Poo [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 11, 2003 5:07 PM To: Michael Weiner; [EMAIL PROTECTED] Subject: Re: mysql monitoring I didn't read the original thread...but go to CPAN and check out MyTop.pl. Just like unix Top process

Re: mysql monitoring

Thanks Chris, i had not seen that before, nice little tool to compliment the plots!! thanks, added as a bookmark and running it now Michael Weiner -- On Sat, 2003-01-11 at 09:06, Dr. Poo wrote: > I didn't read the original thread...but go to CPAN and check out MyTop.pl. > Just like unix Top

Re: mysql monitoring

I didn't read the original thread...but go to CPAN and check out MyTop.pl. Just like unix Top process watch application, but for mysql... pretty cool! -Chris On Thursday 09 January 2003 06:02 pm, Michael Weiner wrote: > There are a few solutions out there for you. I recommend you check o

mysql monitoring

There are a few solutions out there for you. I recommend you check out RRDTOOL, and associated packages at http://people.ee.ethgz.ch/~oetiker/webtools/rrdtool/ and also look for a took called cactus, it absolutely rules. THere are others, but rrdtool, has a myriad of contributed packages it can w

RE: mysql monitoring?

cacti? cheers David Ziggy Lubowa Network Engineer One2net (U) web: www.one2net.co.ug Tel: +256 41 345466 -Original Message- From: Shon Stephens [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 8:55 PM To: '[EMAIL PROTECTED]' Subject: mysql monitoring? is there a

Re[2]: mysql monitoring?

Hello David, DL> is there an snmp mib or something available for snmp to monitor mysql DL> server? or, does anyone have a script that they would like to share that DL> they use to monitor and gather statistics about mysql? MYSQLSTAT - A set of utilities to monitor, store and display Mysql DBMS us

mysql monitoring?

is there an snmp mib or something available for snmp to monitor mysql server? or, does anyone have a script that they would like to share that they use to monitor and gather statistics about mysql? thanks, shon - Before posting,

Re: Where can I get innodb monitoring tools?

At 18:11 +0900 11/12/02, Chung Ha-nyung wrote: innodb manual (http://www.innodb.com/ibman.html) mentions about innodb monitoring tools, e.g. innodb_tablespace_monitor. But they don't seem to be included in mysql 4.0.4. Should I buy them or can get somewhere else, like innodb homepage? Se

Where can I get innodb monitoring tools?

innodb manual (http://www.innodb.com/ibman.html) mentions about innodb monitoring tools, e.g. innodb_tablespace_monitor. But they don't seem to be included in mysql 4.0.4. Should I buy them or can get somewhere else, like innodb homepage? -- Chung Ha-nyung Sayclub <http://www.say

Re: MySQL Monitoring Alerts

Mike, I totally agree. The log solution wasn't my idea though . No matter what language you write the script in, any type of ""Get some kind of response by throwing something against the server and seeing if it sticks"" response will get you the information you need. I set up a dummy account

Re: MySQL Monitoring Alerts

Eric, Isn't letting an outside connection access to your log file a "little dangerous"? Why not create a dummy table with just one record in it, restrict it to read access only, then use your chron job on a remote computer to run a PHP/Perl script to access that record over the net. I

RE: MySQL Monitoring Tool

This cuts the time between checks in half across the board. -J -Original Message- From: Tom Freeman [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 10, 2002 5:04 AM To: [EMAIL PROTECTED] Subject: MySQL Monitoring Tool Hi, I hope this question hasn't been asked loads of times be

Re: MySQL Monitoring Tool

arts of errors!). This along with load monitoring using the NRPE utility and MRTG to chart query usage gives us some great information. Hope some of this helps you. Best of luck, Ken - Original Message - From: "Tom Freeman" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]&g

Re: MySQL Monitoring Alerts

Hey, I noticed another response about "tailing the log" and looking for information in the "err" log which looks like a great solution. However, if you have an extra computer laying around, you can also set up a cron job with a shell script that connects to the server (via telnet or using a m

Re: MySQL Monitoring Tool

. if bofhlog found a line with one of these keywords, then it will alarm you via anything you want (using other tools). It's real time monitoring ;-) -- C is quirky, flawed, and an enormous success -- Dennis M. Ritchie MySQL 3.23.51 : up 0 days, Queries : 776.454 per second (avg). --

  1   2   >