Re: Mysql suddenly become slow for different connections to changes
Posted by: Peter Brawley
Date: August 05, 2021 03:12PM

The database that your "next page" depends upon is on the same server, or a different one? Local, or remote? Kept in sync with its source via replication, or what?

Since it's a different connection, you'll need to time the connection, the sync method, and the retrieval query to see where the bottleneck is.

Options: ReplyQuote

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.