Close the database connection when kivy app gets killed

Question

I have created a small kivy app. Here, I have made use of mysql database. When the kivy app gets killed or destroyed ,I want to close the database connection. How will I know if my kivy app is running in background or destroyed.

Answer 1

to close database connection, you can set wait timeout parameter with minimum value which have 8 hours by default. So if database will have any idle connection, same will be killed by MySQL server itself.

Let's say, if we set wait_timeout 60 seconds. then idle connection will be active for 60 seconds only. after 60 seconds, connection will be released. To change required variable, Please use below steps:

mysql -uUSER -pPASSWORD

then

set global variables wait_timeout=60;

or you can also set this variable for your kivy app only with session variables