The SET MAXIDLE option specifies whether a time limit is in force, and how long it is in seconds. The value entered must be less than that defined by the idle_time_limit session privilege. If no idle_time_limit is set, there is no time limit.

When MAXIDLE is set, it remains in effect until another SET MAXIDLE or SET NOMAXIDLE statement is issued, or the session terminates. For more information, see idle_time_limit in the description of GRANT (privilege).