Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I want to compare the memory and cpu usage of the the redis-server and the mysql-server. I have used a profiler to get the client data but I would also like to know what is going on on the servers when I execute queries.

Do you know a tool that I could use.

I am running them locally on mac os x10.6.8

share|improve this question

2 Answers 2

You can run a query against your information_schema table to get my mysql stats on current usage by MEMORY tables, if you use them:

select sum(data_length+index_length) as memory from information_schema.tables where engine='memory';

Also if you use INNODB, you can run SHOW ENGINE INNODB STATUS granted you have the PROCESS privelage

share|improve this answer

There's an easy way for redis.

There's a comand for the command line client (redis-cli) called INFO. which shows (among others) a variable called "used_memory".

see http://redis.io/commands/info

share|improve this answer
    
Yes I know that :) and I use it, but I would like to see if my processes cause extra load on the servers. –  x_maras Jun 6 '12 at 15:13

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.