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

Over the weekend I upgrade my Ubuntu server from 9.10 to 10.04 which also updated my MySQL server. I also enabled MySQL replication over to another server as slave.

I have not yet moved any application logic to use slave but I started seeing some performance issues on my master MySQL server. The app has started slowing down and the number of slow queries have increased. Any good tool which can give me more information as to what might be going on or any tips to optimize this.

share|improve this question
    
Server specs? Were you writing out a binary log before? –  HTTP500 Oct 18 '11 at 22:26

1 Answer 1

up vote 1 down vote accepted

I'm not aware of tools, but ensure in your queries you always provide column names so replication serVices don't need to look up the columns and modify the SQL command.

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.