MySQL Forums
Forum List  »  Newbie

Re: mysql connection confusion clear
Posted by: Phillip Ward
Date: November 08, 2021 05:59AM

Quote

Does not it close the connection if it is not well-written and mysql connection does not close?

There can be issues with connections not being closed.
This can lead to connection "exhaustion" in the database and the whole site goes down. Either that or the database tries to handle the huge number of connections and does so, but very, very slowly.

Quote

When we click on any link, will It close the previous connection where I visited last?

You are still not grasping the idea of this Client-Server architecture.

It will close any connections as soon as it has finishes whatever processing is required to send your browser the HTML that makes up the page as you see it.
You can have that same page sitting on your screen all day, but the web server has forgotten all about you - there is no connection of any kind between your computer and the web server.

Options: ReplyQuote


Subject
Written By
Posted
Re: mysql connection confusion clear
November 08, 2021 05:59AM


Sorry, only registered users may post in this forum.

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.