I have this in my my.cnf


but when i execute

show processlist;

I have processes that still running more than 4500sec even they are in 'Sleep' command.

please help about this, thank you.

Just because a process is "sleeping" doesn't mean it isn't running. It is just waiting for a timer or wakeup event to happen.

but i thought if it reached a certain timeout, it should be killed to free-up a connection slot.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.