It works when I run "DELETE FROM mdl_sessions2 WHERE DATEDIFF(NOW(),expiry)>2"
REF:http://moodle.org/mod/forum/discuss.php?d=122060
Thanks
Hardware and performance
HIGH CPU USAGE BY MYSQL WITH A HUGE mdl_sessions2 TABLE
This discussion has been locked so you can no longer reply to it.