MySQL Forums
Forum List  »  Performance

Re: Hints on what to check for bad performance
Posted by: Chandan Kumar
Date: September 25, 2015 07:55AM

Hi,
1.for new setup can you rebuild indexes by "OPTIMIZE TABLE <tbl_name>;
for all tables in that DB.

2.for performance analysis take one query & execute on both servers & setup profiler and check where this query spending more time.

Let me know for further analysis

Thanks & Regards,
Chandan
chandankumar9965@gmail.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Hints on what to check for bad performance
700
September 25, 2015 07:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.