I have a yii-powered website using a mysql database. When i run show processlist in the mysql I see many sleeping connections, which I think means that the database connection is not being closed by Yii?
I also tried to see if the Yii::app()->db->close() function is ever being run but it doesn’t seem to be… or maybe I am not checking properly.
Anyway, my question is: Does Yii close the database connection after a page is loaded? If not, how can I do it so Yii does close the DB connection once done with it?