Re: Application fails to connect to MySQL database
Posted by: Peter Brawley
Date: January 27, 2016 03:01PM

> When a user tries to login in the front-end (UI). The execution time is about 70 secs.

You'll need first to add timing debug stubs to the app to see what's taking the time.

If all queries are slow, you may need to tune the server and/or the database. For a start see

If you can identify particular queries that are slow, running Explain Extended on them will usually show what needs fixing. If you get stuck, post those queries, their Explain Extended results, and Show Create Table results for all tables.

Options: ReplyQuote

Written By
Re: Application fails to connect to MySQL database
January 27, 2016 03:01PM

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.