Take the 2-minute tour ×

I am new to DBA role, and wanted to know if there was any commands (or free software) that come with Mysql 5.5 (master/slave/slave) replication to quickly get familiar with the database, and also making sure my.cnf is set up with the correct parameters.

share|improve this question
maybe break this out into a few separate questions by posting your configs, describing your workload, and asking for help identifying potential areas of weakness in the system. also, look for documentation from the last person. –  zlatan Jan 8 '13 at 22:20
@swasheck - that's almost an answer in itself :) –  trygvis Jan 9 '13 at 7:47
add comment

1 Answer

up vote 2 down vote accepted

The pt-mysql-summary tool from Percona toolkit gives you a very nice overview of your running server.

It will tell you stuff like what the major config params are set to, what technologies ara available in your server, take a 10 second status sample, analyze your schema etc.

Also worth to run pt-duplicate-key-checker at least once, to detect redundant keys.

I'm authoring the common_schema tool for MySQL, which also offers some diagnostics: the redundant_keys view is parallel to pt-duplicate-key-checker; the data_size_per_schema view will tell you, well, the datasize per schema; the auto_increment_columns view will tell you about "free space" in your AUTO_INCREMENT columns; and more.

Watching the processes as they go, using innotop or the old-timer mytop is also worthwhile: get to know the processes that run most, the longest etc.

share|improve this answer
add comment

Your Answer


