I have this in my my.cnf

wait_timeout=1800
interactive_timeout=1800;
net_read_timeout=1800;
net_write_timeout=1800

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.