Showing entries 34211 to 34220 of 45389
« 10 Newer Entries | 10 Older Entries »
Creative programming with MySQL


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 …
[Read more]
MySQL Conference Swag


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]
T2000 CPU Performance - Watch out

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]
MySQL and Ubuntu - a perfect match

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 …

[Read more]
2008 MySQL Conference Videos, Notes, Slides and Photos!

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]
More than 400 people joined for MySQL World Tour event in Beijing

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]
PBXT & BLOB Streaming Conference Presentations & Videos

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, …

[Read more]
Again, MySQL 5.1.24 does not come with Cluster

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!

Can having information public hurt consulting business ?

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]
Optimizing MySQL and InnoDB on Solaris 10 for World's Largest Photo Blogging Community - Video

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 …

[Read more]
Showing entries 34211 to 34220 of 45389
« 10 Newer Entries | 10 Older Entries »