I managed to get MySQL to stall completely last night, when working…: sleepy

Log in

No account? Create an account

Remember me

: That chubby swede (sleepy) wrote,
2006-02-07 15:50:00

That chubby swede
sleepy
2006-02-07 15:50:00

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.

Post a new comment
0 comments

Log in

Error