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.