|
|
Programming databases is tricky. If you need the basic access only, any programming language can do. But when you want to get some advanced feature, you face difficult choices. If you are lucky, the feature you are looking for is available in a library compatible with your language of choice. But usually it happens that you are writing in Java, and your life-saving routine is only available in Perl, or you are writing in PHP and striving for features that are buried deep into a Java class. Hard choices. But it does not have to be that way. Sometimes, you can develop closer to the server, in such a way that any client, using any programming language, can access your extended routine. MySQL, although not as equipped with built-in features like some competitors, is nonetheless particularly suited for such … |
I was reading a post about The Swag Report and realized that I stayed so busy at the Phorum booth (and a little at the memcached booth) and preparing for my talks, I did not bother to go around and collect any swag from the conference. So, if you are a vendor and want to mail me some swag that I missed, you can send it to: Brian Moon, 198 S. Hillcrest Rd., Odenville, AL 35120. Of course, I expect nothing. But, ya never know what product I might pimp because of a t-shirt. =)
[Read more]Sun is aggressively pushing T2000 as Scalable MySQL Platforms, and indeed it is Scalable in terms of high concurrency workloads - it is able to execute a lot of concurrent threads and so speed gain from 1 thread to say 32 thread will be significant.
But thing a lot of people miss is - Being Scalable is Not Enough - you need to scale from reasonable base to claim the good performance, and this is where T2000 performs subpar in many cases.
I often hear about people complaining queries take much longer on T2000 compared to recent Intel or AMD CPUs when there is no concurrent load - It is reported T2000 can be as much as 5-15 times slower in this case depending on the workload.
Here is example run of purely CPU consuming "Benchmark" function for 2.6Ghz Intel Xeon vs T2000:
PLAIN TEXT SQL: …
[Read more]
I like Ubuntu's philosophy. Among the Debian derived Linux
distros, it's the one that appeals to me the most. The first live
CDs (Knoppix, Mepis) were a revolution, but Ubuntu has perfected
the trend by adding a quality that was missing from these early
ones.
I especially like the ease of installation. Plug to the net,
apt-get install package_name, and presto! you got what you
want.
MySQL server comes with just one line:
apt-get install mysql-client mysql-server
This will get you the latest server and client binaries, ready to
use.
Yesterday I wanted to build MySQL 5.1 from source. The latest one
(5.1.24) that has been released is missing the Federated engine,
and I wanted the complete thing. So I installed Ubuntu in a spare
machine, and got the source code from the development
tree.
By …
All of the videos from the 2008 MySQL Conference have been
processed and uploaded. Links to the videos, slides, notes,
photos for each presentation are all on the mega-conference page
at:
http://forge.mysql.com/wiki/MySQLConf2008Notes
This represents many hours of my own toil, but it also reflects plenty of people who have blogged, edited the wiki pages and speakers who wrote and gave tutorials and presentations. I am proud of everyone’s efforts to offer so many learning resources for free….
Enjoy! EDIT: I forgot to thank Jay, the folks at O’Reilly and all the speakers for giving me explicit permission to video and freely offer their presentations.
If you know of any video, audio, notes, slides, photos, etc that are not linked, please link them at the wiki page. If you can’t or won’t, please comment here and I will update the wiki …
[Read more]Hi,
Sun & MySQL World Tour event was held in Beijing on Apr 23. It was the first Sun & MySQL event in China and the second visit of the World Tour in APAC. More than 400 people joined and it became truly exciting event.
Kaj Arno, VP of Community at MySQL, gave his speech in Chinese to
share what he has heard about this acquisition from MySQL
communities in various countries he has visited since Feb as
Ambassador to Sun. As you can guess from his picture, he is not a
Chinese speaker. He has been practicing this speech for hours
especially tones with Scott Chen, Product Manager of Software in
Great China. Eventually it seemed people understood Kaj’s Chinese
mostly as attendees laughed several times during his 8 minutes
speech
Additionally a press conference was held on the same day in Beijing. Then some questions brought up if MySQL would go as open source or closed source. The answer was “OPEN”. Kaj insisted …
[Read more]
The slides of my presentations at the MySQL Conference & Expo
2008 are now available for download. Videos of the presentations
have been uploaded to YouTube:
Inside the PrimeBase XT Storage Engine
Presentation: pbxt-uc-2008.pdf
Videos: Part 1/7, Part
2/7, Part 3/7, Part
4/7, Part 5/7, Part
6/7, …
I've seen some posts on our forums and comments on our website
telling us that the Cluster Storage Engine is missing. Yes, it's
not anymore in MySQL 5.1.24-rc and later. It has been pulled out
to go into a different distribution.
Reading the ChangeLog is a good thing!
People frequently ask me if the fact we keep information public can hurt our consulting business ? Lets keep aside for the moment amount of new business publishing this information brings to us but think it also have significant negative effect because people find information on MySQL Performance Blog and use it instead of purchasing our services ?
Sure they do. There are people searching for advice finding it on MySQL Performance Blog and so they do not need to purchase any commercial consulting. However these people are not likely clients on the first place - if not our blog they would find information in MySQL Manual or on thousands of other sites, or may be they would read some books.
Seriously speaking for vast majority of the problems you can run into there is information out there - so you …
[Read more]
The video of one of my three sessions, "Optimizing MySQL and InnoDB on Solaris 10 for World's
Largest Photo Blogging Community", presented at MySQL Conference & Expo 2008 has been uploaded by
Sheeri. I am
very thankful to her for doing all the hard work and making it
available.
There are a few slides that were edited out of video because of
reasons beyond my control. However, you should still be able to
enjoy most of the video.
There is one point related to this video that I would like to
make: Based on my particular experience I was leading to believe
that Solaris 10 Kernel had the same …