
If you administer a MySQL server chances are you’ve seen it go astray. A some point in time for no apparent reason, maybe for a traffic spike, the number of running queries starts snowballing until MySQL eats 100% of your CPU grinding your whole server to a halt. In the context of this article let’s just call this pattern The Snowball Effect.
The Snowball Effect can be caused by slow queries and locking issues especially on MyISAM tables. After you’ve done your homework and optimized your queries, using better indexes and tweaking MySQL configuration, there’s still a little detail, one that doesn’t get noticed: you reduced the probability of triggering The Snowball Effect. It can still happen if the load on database ever increases. For some applications and datasets you may never be able to optimize enough to prevent the Snowball Effect from happening.
Continue reading »

I’m happy to announce the release of Minitube version 1.2. This release brings, among other minor enhancements, a much requested feature: video downloads.
Another highlight for this release is a more native look on the Mac, using the cool unified toolbar, better icons and carefully chosen colors.
I hope everybody understands that this project needs to be economically sustainable to continue improving. So please Linux users make a good use of the orange button on the right. Thank you.
It’s that magic moment again when a new Minitube version is almost ready to be released. This time the main change is a much requested feature. A feature that extends the application scope quite a bit. Drum roll… Video downloads! Please everybody test it so we can have a bug-free release.
Linux 32bit Mac OS X Source code Make a donation
There are a lot of new strings to be translated. So I welcome old time and new translators to launch their Qt Linguist app for the sake of the non-english speaking masses. If you want to help you can work independently on Git or just send me the translation by email. Get existing translations from Gitorious. For new translations you can start from this file.
Here’s the current translation status:
ar.ts : 64% 51/(140-0)
bg_BG.ts : 64% 51/(140-0)
cs_CZ.ts : 64% 51/(158-18)
de_DE.ts : 64% 51/(168-28)
el_GR.ts : 64% 51/(168-28)
en_US.ts : 1% 139/(140-0)
es_AR.ts : 38% 87/(157-17)
es_ES.ts : 52% 68/(163-23)
es.ts : 64% 51/(163-23)
fi_FI.ts : 64% 51/(140-0)
fr_FR.ts : 64% 51/(153-13)
gl.ts : 64% 51/(168-28)
he_IL.ts : 65% 51/(157-15)
hr_HR.ts : 64% 51/(140-0)
hu_HU.ts : 64% 51/(153-13)
it_IT.ts : 100% 0/(157-17)
ja_JP.ts : 49% 72/(149-9)
lat.ts : 64% 51/(154-14)
nb_NO.ts : 64% 51/(153-13)
nl_NL.ts : 64% 51/(140-0)
pl_PL.ts : 64% 51/(158-18)
pt_BR.ts : 64% 51/(168-28)
pt_PT.ts : 64% 51/(140-0)
ro_RO.ts : 64% 51/(153-13)
ru_RU.ts : 64% 51/(168-28)
tr_TR.ts : 64% 51/(168-28)
uk.ts : 64% 51/(168-28)
zh_CN.ts : 64% 51/(140-0)


Coniuga helps you with the conjugation of both regular and irregular Italian verbs. Just type a verb in the search field. You can enter the infinitive form (e.g. Coniugare) or any other mood and tense, e.g. Coniugheresti, Ebbi coniugato, etc. This version requires an active Internet connection. If there is enough interest and positive comments I’ll develop an offline version.
Coniuga is also available for the stunning Nokia N9, get it from the Ovi Store.
I’m very thankful to Nokia/Qt people that accepted me in the Qt Ambassador Program.
The Qt Ambassador Program is a membership-only program that honors Qt development projects. All developers around the world who create products and projects with Qt are eligible to apply. Membership to the Qt Ambassador Program is free and based on your outstanding and innovative Qt project.
Besides having a Minitube page in the Qt Ambassador Showcase site, I can now proudly display the Qt Ambassador logo on my site.
Apparently YouTube changed something and broke many applications including Minitube. So here is a new working release! This release brings minor visual enhancements, various bug fixes and a new Chinese translation. Thanks to Levente Polyak, Zvonimir Đeri and Changtai Liang for contributing to this release.
The Mac version, just like Minitunes, is now offered at a modest price to sustain development. The new project page reflects these changes. Obviously Linux users are still invited to donate.
Get Minitube 1.1 now!
Emanuele Rampichini di Appunti Digitali mi ha intervistato sulla (in)sostenibilità economica dei miei progettini Free Software.
I published today a hotfix release of Minitunes. This release is mostly targeted at Mac users that were experiencing crashes during the library scanning or were missing their AAC files.
In order to have their AAC music shown, Mac users should choose Minitunes => Change collection folder... from the menu.
Potential stack overflow fixes are valid for Linux users too, although no Linux user has reported crashes.
Lazlo, Kirk and Mike tested the changes on their Macs, so you can enjoy a more stable Minitunes!
Just a quick note to say that the Mac build is now 32bit compatible. So if it didn’t start on your Mac, you may give it a second try.
By the way, I’m investigating a crash reported by many that happens when Minitunes scans your music. I believe it’s a “stack overflow” problem since the code is recursive and may exceed the stack size. Don’t worry if you don’t understand what this means, it’s just a technical blurb :)

I’m very happy to announce the release of an innovative music player, Minitunes!
This is just the first release. Many pieces of the puzzle still have to fall in place. Like the search feature, internationalization, media device support and many other features you can read in the to-do list. With your support, we’ll get there.
Minitunes is available for Mac and Linux. A Windows version is coming soon.
Try it out now!