TriTUX is based in Tunis, Tunisia. Founded in 2006 as Systems Analysis and Weblication Development, TriTUX is providing high-quality professional services for achieving flexible, creative and scalable systems. TriTUX engineers is a team of jack-of-all-trades, possessing intimate knowledge in networking, eXtreme programming, GNU/Linux and scalable solutions.

A few months ago I was at dinner with Yves Trudeau discussing what all consultants discuss in the late hours after a long day of hard work… how to improve performance and scalability.  I brought up an idea to him to utilize memcached as an L2 cache for innodb.  At first he was skeptical, but as we talked he was more and more intrigued by the idea.  The idea was simple, add a set to memcached when something hit the LRU…  then issue a get from memcached when you do not find the data locally stored in the buffer pool but before you read from disk.  Starting from that point, you can work out any of the issues that would be sure to follow.   So Yves continued emailing me asking me questions…  then he sent me a note that he had made huge progress with the idea. Huge progress means that he wrote version 0.1 and had it working.    That’s when the Idea really turned into a project.

We called …

While it took some time to get things sorta out with building MySQL 5.1 with the right parameters to get partitioning support working, I finally was able to get a working install and had some time to play around with this new intriguing MySQL 5.1 feature hands on. The results were mixed I think. For an initial release, things are pretty solid, save for a few non-trivial oddities.

One of the problems I was trying to tackle was splitting up a logs table up by a date range. It seems like this would be a popular use for partitions since it replicates some of the functionality of the MERGE storage engine, only in most cases, does so better. The problem, however, I ran into was that it did not seem quite as trivial as I thought to partition by year and month. Partitioning by year seems easy - just use the year() function, but partitioning by year and month is far less …

Sun Microsystems, Inc. today announced a major new version of its MySQL Enterprise™ subscription service to help corporate users dramatically improve the speed and uptime of their MySQL™ database applications. MySQL Enterprise subscribers now have access to Sun's new MySQL Query Analyzer tool for monitoring query performance to accurately pinpoint and correct problem SQL code -- in addition to MySQL Enterprise's regular software updates and 24x7 production technical support.

Thirty-day trial subscriptions for the new MySQL Enterprise service, including MySQL Query Analyzer, are now available free-of-charge from www.mysql.com/trials.

During the Sun CEC 2008 MySQL sessions training track it was great to get Marten Mickos to speak to the Sun audience. As I was lining up guest speakers for my MySQL sessions I really wanted to get Marten there to address questions Sun employees have on the MySQL acquisition and to discuss future directions of MySQL with Sun. Marten as one of the key leaders in open source as always did a great

Recently I burned a copy of OpenSolaris 2008.11 RC1 and used it with Songbird (using pkg install SUNWsongbird)  and Fluendo MP3 Decoder (which is free for OpenSolaris),  Flash and soon I had a setup in my bedroom which I love to call OpenSolaris Home Theatre Edition that I used to listen to my songs collection and watch online shows that I controlled via Remote Desktop  which to me was a serious contender to those Media Centers out there. 

However I realized that while I wanted to …

Recently I burned a copy of OpenSolaris 2008.11 RC1 and used it with Songbird (using pkg install SUNWsongbird)  and Fluendo MP3 Decoder (which is free for OpenSolaris),  Flash and soon I had a setup in my bedroom which I love to call OpenSolaris Home Theatre Edition that I used to listen to my songs collection and watch online shows that I controlled via Remote Desktop  which to me was a serious contender to those Media Centers out there. 

However I realized that while I wanted to …

Taming MySQL is… challenging. Especially in very large, fast-growth, ‘always-on’ environments. It’s one of those things where you seemingly can never know all there is to know about it. That’s why I really like coming across posts like this one from FreshBooks that describes a very real problem that was affecting their users, how they dealt with it, why *that* failed, and what the final fix was. Post a link to your favorite MySQL Problem and Solution post in the comments (oh yeah, and “subscribe to comments” should be working now!)

A former colleague recently posed a problem to me: “This guy has a table full of table names, and he wants to run a query that unions those tables.” I spent a couple of minutes telling him why it was a bad idea. It’s not a very robust solution, and an incorrect value in your […]