#1
  1. A Change of Season
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Mar 2004
    Location
    Next Door
    Posts
    2,672
    Rep Power
    171

    Does mysql keep running if computer is sleep (Mac Book)?


    Does mysql keep running if computer is sleep (Mac Book)?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Oct 2009
    Location
    Nebraska, USA
    Posts
    876
    Rep Power
    275
    no, nothing runs while the computer is asleep [in standby].
  4. #3
  5. A Change of Season
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Mar 2004
    Location
    Next Door
    Posts
    2,672
    Rep Power
    171
    Originally Posted by DonR
    no, nothing runs while the computer is asleep [in standby].
    I am not sure if you're right or not. An ALTER table ADD INDEX query was running and I had to put the computer to sleep and then back after few hours. When I SHOW PROCESSLIST I see it is running and when I refresh the time changes too.

    testing Query 50464 copy to tmp table ALTER TABLE products_table
    ADD INDEX covering_ind...


    testing Query 50469 copy to tmp table ALTER TABLE products_table
    ADD INDEX covering_ind...
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Oct 2009
    Location
    Nebraska, USA
    Posts
    876
    Rep Power
    275
    What are you considering to be "sleep"?
    To my knowledge, any type of "suspend" operation, whether to RAM [sleep/standby] or HDD [hibernate] will suspend ALL operations until the computer is awakened again.
    That is probably what you are noticing ..is the fact that when the computer is "resumed/awakened" ALL operations will continue wherever they left off.

    If you can telnet/SSH into the computer while it is asleep, and it is successful for you to login that way, then, I would say I was mistaken.
    Last edited by DonR; May 11th, 2013 at 08:47 PM.

IMN logo majestic logo threadwatch logo seochat tools logo