Unix Technical Forum

MySQL Performance Analysis tools

This is a discussion on MySQL Performance Analysis tools within the MySQL General forum forums, part of the MySQL category; --> Hi. Using MySQL on Linux, I'd like to analyze the performance and know how resources (memory, threads) are used ...


Go Back   Unix Technical Forum > Database Server Software > MySQL > MySQL General forum

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 07:02 AM
thomas Armstrong
 
Posts: n/a
Default MySQL Performance Analysis tools

Hi.

Using MySQL on Linux, I'd like to analyze the performance and know how
resources (memory, threads) are used during a period of time.

Do you know any tool to carry it out? Thank you very much.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-28-2008, 07:02 AM
Bernd Jagla
 
Posts: n/a
Default RE: MySQL Performance Analysis tools

"sar" will give you some basic information about what happens on the
system... (see e.g.: http://linux.die.net/man/1/sar)...

-B

|-----Original Message-----
|From: thomas Armstrong [mailto:tarmstrong@gmail.com]
|Sent: Monday, November 19, 2007 6:42 AM
|To: mysql@lists.mysql.com
|Subject: MySQL Performance Analysis tools
|
|Hi.
|
|Using MySQL on Linux, I'd like to analyze the performance and know how
|resources (memory, threads) are used during a period of time.
|
|Do you know any tool to carry it out? Thank you very much.
|
|--
|MySQL General Mailing List
|For list archives: http://lists.mysql.com/mysql
|To unsubscribe: http://lists.mysql.com/mysql?unsub=baj2107@columbia.edu

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-28-2008, 07:02 AM
mark addison
 
Posts: n/a
Default Re: MySQL Performance Analysis tools

Bernd Jagla wrote:
> "sar" will give you some basic information about what happens on the
> system... (see e.g.: http://linux.die.net/man/1/sar)...
>
>

Munin (http://munin.projects.linpro.no/) will generate graphs and stats
over time for system usage (cpu, mem load, disk usage etc) and includes
good support for mysql graphing throughput, queries, threads and slow
queries.
Example here: http://munin.ping.uio.no/ping.uio.no...ng.uio.no.html

mark
> |







MARK ADDISON
WEB DEVELOPER

200 GRAY'S INN ROAD
LONDON
WC1X 8XZ
UNITED KINGDOM
T +44 (0)20 7430 4678
F
E Mark.Addison@itn.co.uk
WWW.ITN.CO.UK

P Please consider the environment. Do you really need to print this email?
-----Original Message-----

> |From: thomas Armstrong [mailto:tarmstrong@gmail.com]
> |Sent: Monday, November 19, 2007 6:42 AM
> |To: mysql@lists.mysql.com
> |Subject: MySQL Performance Analysis tools
> |
> |Hi.
> |
> |Using MySQL on Linux, I'd like to analyze the performance and know how
> |resources (memory, threads) are used during a period of time.
> |
> |Do you know any tool to carry it out? Thank you very much.
> |
> |--
> |MySQL General Mailing List
> |For list archives: http://lists.mysql.com/mysql
> |To unsubscribe: http://lists.mysql.com/mysql?unsub=b...@columbia..edu
>
>
>

Please Note:



Any views or opinions are solely those of the author and do not necessarilyrepresent
those of Independent Television News Limited unless specifically stated.
This email and any files attached are confidential and intended solely for the use of the individual
or entity to which they are addressed.
If you have received this email in error, please notify postmaster@itn.co.uk

Please note that to ensure regulatory compliance and for the protection of our clients and business,
we may monitor and read messages sent to and from our systems.

Thank You.


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 06:19 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com