Hello, I want to know when my PM Server should ping to the MySQLi Server. In Shoghicp Plugin SimpleAuth he pings every 30 Ticks but when in tried it with 250 it worked perfectly too. So could someone explain this please?
According to this article: http://www.mysqldba.co.uk/articles/let-sleeping-dogs-die-automatically-close-idle-connections The idle time out is 8 hours. Of course, this is a configurable value. BTW, also remember that the ping not only keeps the connection alive, but it also tells the client if the database died.