query not closed after time_out passed

Discussion in 'MySQL' started by jalex, Aug 31, 2007.

0
  1. #1
    on mysql server i have defined below variable:

    set-variable = wait_timeout=10
    set-variable = interactive_timeout=10

    but when i check the processes i have queries running for over 200 seconds.. why these queries are not closed after wait_timeout is passed? what's the problem?
     
    jalex, Aug 31, 2007 IP
  2. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #2
    what db shows at : show variables like '%timeout%'

    did you restart mysql server?
     
    gibex, Sep 2, 2007 IP