To get Processlist and Status of MySQL ?

--00504502b870ce14380486c15908
Content-Type: text/plain; charset=ISO-8859-1

Hi All,

What is the other way to get the *processlist* and *status* of mysql server
on event that the mysql server cannot be able to reach due to hung or
crashed?

Cheers,
James

--00504502b870ce14380486c15908--

Re: To get Processlist and Status of MySQL ?

In infinite wisdom James Corteciano wrote:

> [1 ]
> Hi All,
>
> What is the other way to get the *processlist* and *status* of mysql server
> on event that the mysql server cannot be able to reach due to hung or
> crashed?

GDB

--
Raj Shekhar
-
If there's anything more important than my ego around, I want it
caught and shot now.



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: To get Processlist and Status of MySQL ?

--001636e0af2d9676800486d94868
Content-Type: text/plain; charset=ISO-8859-1

I found some tools to capture the MySQL processlist, log errors, etc.
MySQLReport and
mytopapps. My goal is to grab
the logs of mysql including the processlist to help
me assist in diagnosis of faults.

What tool/apps do you use?

Thanks.
James

On Tue, May 18, 2010 at 5:06 AM, Raj Shekhar wrote:

> In infinite wisdom James Corteciano wrote:
>
> > [1 ]
> > Hi All,
> >
> > What is the other way to get the *processlist* and *status* of mysql
> server
> > on event that the mysql server cannot be able to reach due to hung or
> > crashed?
>
> GDB
>
> --
> Raj Shekhar
> -
> If there's anything more important than my ego around, I want it
> caught and shot now.
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=james@linux-source.org
>
>

--001636e0af2d9676800486d94868--

Re: To get Processlist and Status of MySQL ?

--00504501748b2128f20486dcd19d
Content-Type: text/plain; charset=ISO-8859-1

If your mysql server is hung, crashed or otherwise unreacheable (as you
first posted), you can't connect to it and request it's status and
processlist - it's threaded and thus all inline.

You could use GDB or something similar to go look in the execution stack, as
Raj said, and if you have full query logging enabled, you can parse your
logs and see what was happening at the time of the crash - although I
suspect that only completed queries get logged, so the one causing the crash
may not be in there.

Generally, it's a good idea to use Munin, Cacti or similar tools to graph
performance data all the time, so you can have a post-mortem look at stuff
like "did the number of connections increase in the moments before ?"


On Tue, May 18, 2010 at 9:28 AM, James Corteciano wrote:

> I found some tools to capture the MySQL processlist, log errors, etc.
> MySQLReport and
> mytopapps. My goal is to grab
> the logs of mysql including the processlist to help
> me assist in diagnosis of faults.
>
> What tool/apps do you use?
>
> Thanks.
> James
>
> On Tue, May 18, 2010 at 5:06 AM, Raj Shekhar
> wrote:
>
> > In infinite wisdom James Corteciano wrote:
> >
> > > [1 ]
> > > Hi All,
> > >
> > > What is the other way to get the *processlist* and *status* of mysql
> > server
> > > on event that the mysql server cannot be able to reach due to hung or
> > > crashed?
> >
> > GDB
> >
> > --
> > Raj Shekhar
> > -
> > If there's anything more important than my ego around, I want it
> > caught and shot now.
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> > http://lists.mysql.com/mysql?unsub=james@linux-source.org
> >
> >
>



--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

--00504501748b2128f20486dcd19d--