From: Manuel Arostegui (manueltuenti.com)
Date: Thu Apr 04 2013 - 15:40:53 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

2013/4/4 Richard Reina <gatorreinagmail.com>

> I am looking to spec out hardware for a new database server. I figured
> a good starting point would be to find out how much usage my current
> server is getting. It just a local machine that runs mysql and is
> queried by a few users here in the office. Is there a way that mysql
> can tell me info about it's workload?
>
> Thanks

Hello,

You can start with show innodb status;
For the basics, you might want to start graphing the stats under ROW
OPERATIONS (inserts, updates, reads, deletes...)

Manuel.

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]