SHOW GLOBAL STATUS LIKE 'Innodb%';
Then do some math -- usually dividing by Uptime.
That will give you some insight in how hard the I/O is working, and how full
the buffer_pool is.
> -Original Message-
> From: Rafał Radecki [mailto:radecki.ra...@gmail.com]
> Sent: Friday, June 21, 2013 4:
Hello Rafał,
On 6/24/2013 4:26 AM, Rafał Radecki wrote:
As I can see the changes in these values are use by percona cacti
monitoring templates to graph "InnoDB I/O".
Can anyone answer the question finally? ;)
2013/6/21 Hartmut Holzgraefe
On 21.06.2013 13:59, Rafał Radecki wrote:
Hi All.
I
As I can see the changes in these values are use by percona cacti
monitoring templates to graph "InnoDB I/O".
Can anyone answer the question finally? ;)
2013/6/21 Hartmut Holzgraefe
> On 21.06.2013 13:59, Rafał Radecki wrote:
> > Hi All.
> >
> > I've searched but with no luck... what do exactly
On 21.06.2013 13:59, Rafał Radecki wrote:
> Hi All.
>
> I've searched but with no luck... what do exactly these variables mean:
>
> 1343928 OS file reads, 1085452262 OS file writes, 19976022 OS fsyncs
>
> ?
these are the total number of reads/writes/fsyncs (number of system
calls actually?) sin
Frank,
CREATE TABLE innodb_monitor(a INT) TYPE=InnoDB;
causes the output to be written to the .err file untruncated. DROP the table
to stop the printouts.
There is a limit in the mysql client that restricts the output length to 64
kB.
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transac
On Mon, 26 Jul 2004 18:03:25 -0700, Matt Solnit <[EMAIL PROTECTED]> wrote:
> How is it possible to have a hit rate of 1000/1000? Doesn't the buffer
> get inOn Mon, 26 Jul 2004 18:03:25 -0700, Matt Solnit <[EMAIL PROTECTED]> wrote:
>
> How is it possible to have a hit rate of 1000/1000? Doesn't
Mark,
How is it possible to have a hit rate of 1000/1000? Doesn't the buffer
get initialized by cache misses?
-- Matt <[EMAIL PROTECTED]>
Re: INNODB SHOW STATUS
From: Marc Slemko (marcsznep.com)
Date: Wed Apr 21 2004 - 10:29:44 CDT
On Tue, 20 Apr 2004, Emmett Bishop wrote:
> Howdy all,
>
On Fri, Jan 03, 2003 at 12:04:47AM +0200, Heikki Tuuri wrote:
>
> I think Sinisa suggested some of the InnoDB statistics could be
> included in SHOW STATUS. Of course not all, as SHOW INNODB STATUS
> often prints several kilobytes of data.
Right...
> But, what is the problem in scanning the text
Jean-Luc,
- Original Message -
From: "Jean-Luc Fontaine" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Thursday, January 02, 2003 2:14 PM
Subject: SHOW INNODB STATUS output as SHOW STATUS?
> Hello,
>
> I was wondering whether it would be possible, in a future release, to
>
