Re: Application fails to connect to MySQL database
> 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 mysql.rjweb.org/doc.php/memory.
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.
Subject
Written By
Posted
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.