That chubby swede (sleepy) wrote,
That chubby swede
sleepy
  • Mood: calm
I managed to get MySQL to stall completely last night, when working on a query to update a table of meta data... MySQL went unresponsive and I had to shut down the service to kill it. The table was crashed and I had to recreate it, no real loss of data.
The query took about 90 to 100% cpu-time for 30 minutes, before I lost my patience... killed it and tweaked the query, it returned the 927 rows of data in less than 2 seconds.

Gonna visit my parents tonight, to arrange for grandma's funeral and such.
Subscribe
  • Post a new comment

    Error

    switch
    default userpic

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
    Help
  • 0 comments