This is a response to a response to an article about Scaling MySQL with a Sun server with a 256-thread count.
With x86 based processors, you get high speed threads, but only a couple (up to four) per processor. With the Sun Coolthread T2 processor, you get slower speed threads, but a lot of them, 64 threads per processor. The 256-way is 4 of these processors on one board.
Silverlight seems to be taking off a lot slower than I anticipated. One problem is it doesn’t work on Linux. There is Moonlight, but, its not so obvious. Here I am browsing my blog on my Xubuntu desktop, and I visit a blog entry I made awhile ago on Silverlight (at the time on an XP desktop), and I can’t view my video.
This is a real life example. Case study is, we had performance problems that was narrowed down to a large number of the following query:
SELECT sg.gid FROM Scheduleable_Group sg WHERE sg.domain=’domain.com’ OR sg.sid=’555′;
The database engine is InnoDB on MySQL 4.1.
Continue reading for the analysis and solution.
Read moreMySQL 4.1 “WHERE … OR … ” results in full table scan
9/30/08 – Update…. this doesn’t work anymore, eyespot closed down. It was a start-up, ran out of cash. I’ll leave the post for history sake, and also to point out the new security model in Flash 9.0.124.0 (and presumably up), that is relevant to all Flash developers and users, regardless of Eyespot’s status.
I recently read “Getting Things Done: The Art of Stress-Free Productivity” after hearing Merlin Mann speak about Inbox Zero at a corporate event. The philosophy presented by David Allen in his GTD book has transformed my work process.
The basis of The Art of Stress-Free Productivity is the notion that there are 5 categories of things that we do:
I’d like to explain these in my own words. The instructions I give below are not the author’s words, but rather inspired by. I suggest that you read this article, read David Allen’s Getting Things Done book, then make changes to your own system. I must admit, before I read this book, I thought I had a pretty good system for workplace efficiency. I was reluctant to read it, but after a few recommendations from co-workers, and finally hearing Merlin Mann refer to it, I had to give it a shot. I got a lot out of it. After reading it, last weekend, I immediately made significant changes to my working system. I’ve only had the changes in place for one week, so hard to say this is perfect. But, read on to see how much I got out of it so fast!
Quick History of IPv6
Early ’90s – forecasted that IPv4 would run out
Mid 90s – IPv6 specification arrived
IPv6 surge, then, late 2002:
Since 2005 – rate jump to 160 million per year
When will IPv4 be depleted?
As of April 2008, Geoff Huston of APNIC predicts May 2011.
Tony Hain of Cisco predicts July 2010.
Are you ready!?
Playing with silverlight.live.com. It’s a free, up to 10 GB, online repository for my video files. This is great, I’m utilizing Microsoft’s Silverlight Streaming over a Content Delivery Network, and I don’t have to pay for it! Plus, its super simple to use. I uploaded a video, it gives me a chunk of HTML to paste in my site where I want the video to appear.
There are also limits on video length, and bandwidth limit, so this isn’t the ultimate find. It’s more of a teaser to get developers to use the Streaming Service and CDN architecture. Even so, for my personal use, the limits are more than I need.
Let me show you. Going to drop in a video here, of my dog, Shiloh, wearing snow boots.
Really, I’m just testing the YouTube plugin for WordPress here, but I do find this topic interesting. The 2008 Olympics is going to turn the world on to Silverlight. Its what Flash wanted to be, but never was. This video shows a little demo of the way you’re going to watch the Olympics this year. Check it out….