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 …

Finally managed to upload the photos from Open SQL Camp to Flickr... btw below is the photo of a very bashful Baron receiving his surprise signed shirt from the gathering for all his hard work in helping it come together. I also want to note some thanks to everyone else who contributed in making it a success. Very impressive, very useful, very fun.

I've always been intrigued by the FIRST_ROWS hint, so I paid special attention when we reached it in the 11g SQL Tuning class. But I'm still puzzled.The course notes said that although you shouldn't be using hints generally, when you do, FIRST_ROWS is the most useful of the hints (in the form FIRST_ROWS(n) where you specify how many rows to optimize for). Also that it's not effective when the

Yang's departure opens the door for improved execution. Any takers? READ MORE

I've now been playing with MySQL Enterprise Monitor in its latest guise (which includes the Query Analyzer) for a number of days. To be honest, this is pretty amazing stuff.

Once installed, all you have to do is point your applications to port 4040 on the database server instead of the default of port 3306 and in a few minutes you'll start to see the queries being logged in the Query Analyzer tab. You can sort them by database, by execution time, by execution count, or any of the other table headings in the output. You can also filter by partial query as well as a variety of other filters.

"Ho hum" I hear you say? Yes you could probably just take a look at the processlist on your db server to see what it is doing now, but the statistics Query Analyzer provides can be extremely powerful. Two examples:

#1 - Badly performing query

I installed Quan (Query Analyzer) and within about 20 minutes it became clear I …

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.