RE: Determing number of queries

2013-04-06 Thread 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 h...@tbbs.net
 
   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

Determing number of queries

2013-04-04 Thread 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

Richard

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

Re: Determing number of queries

2013-04-04 Thread Manuel Arostegui 
2013/4/4 Richard Reina gatorre...@gmail.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.

Re: Determing number of queries

2013-04-04 Thread 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

2013-04-04 Thread Manuel Arostegui 
2013/4/4 h...@tbbs.net

  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