The MacDeskBlog

I filled in a bunch of the missing pictures tonight, and found the names of the five which eluded me previously. I think I have 42 left fill in. Friday is looking pretty reasonable at this point to finish that process.

The database hung again tonight. It looked like it hit a write lock or a file lock for some reason. Had to restart it manually. :-\

On the house front, we passed rebar inspection for the slab floor this afternoon. We’re clear to pour tomorrow.

The first morning didn’t go too well on the new server. MySQL was eating up too much CPU and kjournald compounded the problem. The server load got up to 40 around 8AM PDT. So, there were a few reboots as I tried in vain to lower the amount of journaling being done for ext3. Once again, Rob Egan came to the rescue with insights and suggestions. Something he said made me suspect the MySQL settings were not scaled properly, so I ratcheted them down quite a bit. Combining that with the filesystem changes, the server seems to be behaving better now than it is was all morning.

I’m interested to see how it does over the next week or so. I’ll probably need to do some more tweaking of various things. I’ll try to keep downtimes under 15 minutes each, if possible. And most tweaks only require a few seconds to stop and start MySQL or Apache.

I other news, the 13 hours of sleep I got Saturday night paid off in the form working on the server until 2AM Monday morning without kicking my ass today. All of the pictures which were scheduled for April 28th-May 5th have been re-queued for this week, starting today. I got a few of the missing pictures back in for March and April too. I think I’ll be able to get them all in by the end of the week. In the meantime, paging back through prior weeks will display fewer pictures than normal until you get back to March 12th and before.