RE: Determing number of queries

[Rick James]

Richard, there is more to a system than number of queries.
Please post these in a new thread on http://forums.mysql.com/list.php?24 :
   SHOW GLOBAL STATUS;
   SHOW VARIABLES;
   Ram size
I will do some analysis and provide my opinion.

> -Original Message-
> From: Manuel Arostegui [mailto:man...@tuenti.com]
> Sent: Thursday, April 04, 2013 3:20 PM
> To: h...@tbbs.net
> Cc: mysql@lists.mysql.com
> Subject: Re: Determing number of queries
> 
> 2013/4/4 
> 
> > >>>> 2013/04/04 22:40 +0200, Manuel Arostegui >>>>
> > You can start with show innodb status; <<<<<<<< It is now show engine
> > innodb status
> 
> 
> Yep, sorry, not used to it just yet :-)
> 
> 
> --
> Manuel Aróstegui
> Systems Team
> tuenti.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Determing number of queries

[Manuel Arostegui]

2013/4/4 

>  2013/04/04 22:40 +0200, Manuel Arostegui 
> You can start with show innodb status;
> 
> It is now
> show engine innodb status


Yep, sorry, not used to it just yet :-)


-- 
Manuel Aróstegui
Systems Team
tuenti.com

Re: Determing number of queries

[hsv]

 2013/04/04 22:40 +0200, Manuel Arostegui 
You can start with show innodb status;

It is now
show engine innodb status


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

Re: Determing number of queries

[Manuel Arostegui]

2013/4/4 Richard Reina 

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