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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

We have replication from Oracle to MySQL via Oracle Golden Gate.

Yesterday because of some issues we have rebuilt the replication from Oracle to MySQL (this is called opal replication).

Now our website is very slow

Website load time is really slow today. 10.72 sec vs 6.4 sec last week".

We didn't find any replication issues and there is no lagging. We didn't find the the actual issue causing website load time to be really slow.

Could anyone please help me?


migration rejected from Jul 5 '13 at 8:12

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as too broad by Mark Storey-Smith, Paul White, Shawn Melton, a_horse_with_no_name, ypercubeᵀᴹ Jul 5 '13 at 8:12

There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question.

On the MySQL side, are the tables all InnoDB, all MyISAM, or a mixture of both ??? – RolandoMySQLDBA Jul 4 '13 at 23:02