Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

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. – swasheck Jan 8 at 22:20
@swasheck - that's almost an answer in itself :) – trygvis Jan 9 at 7:47

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

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.