0

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.

Improve this question
1
  • Server specs? Were you writing out a binary log before?
    – HTTP500
    Oct 18, 2011 at 22:26

1 Answer 1

Reset to default
1

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.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .