The latest from the MySQL community

If you want to play with Amazon cloud computing stuff, I think using AWS Management Console web interface is the best, easiest, and most intuitive approach, based on my experience so far.

My usage with Amazon Web Services has been only with EC2 up to this point. Prior to AWS Management Console, I had to set up Java, EC2 API tools, various path and environmental variables, certificates, keys, etc., etc.. It is a fairly convoluted process.

AWS Management Console is much easier, except for downloading PuTTY and PuTTYgen on Windows and tsclient on Linux, and a private key pair, everything else is handled inside the browser. Here are a few things I learned:

• Once you are in, create a Key Pair. The web interface will prompt you to save it. Do so, because you will need it to start instances and, depending on what type of instances …

Last week I've participated in several Performance Conferences and Trainings in Kiev. Events mainly were dedicated to the latest improvements within MySQL performance, as well Solaris and Oracle tuning / performance analyzing and best practices. The week was very hot :-) but I've enjoyed every day discussing with creative and smart people! People hungry on knowledge and ready to stay 2 hours more overnight outpassing all allowed timing - it was a real pleasure to share all I know! :-))

So, I'd like to thank all participants! As well Sun@Kiev and i-Klass teams who organized and prepared all these events! I may only wish to see such events more and more often, and don't forget to invite me again! :-))

NOTE : similar conference about MySQL performance improvement will be organized soon in Paris - so if you're …

At the Open World Forum event in Paris this morning I presented a quick overview of the state of free and open source software in 2009 and a look at the trends shaping FOSS into the next decade. The presentation was just 10 minutes rather than the 20 I had originally understood it to be, so I wanted to use the blog to expand a little on the discussion and my thinking.

War is over (if you want it)
Aside from the ongoing adoption of open source, one of the trends that has defined FOSS in 2009 has been the numerous declarations …

The linux.conf.au organisers have given all miniconfs an additional few weeks to spruik for more proposal submissions, huzzah!

So if you didn’t submit a proposal because you weren’t sure whether you’d be able to attend LCA2010, you now have until October 23 to convince your boss to send you and get your proposal in.

Maximize your strengths, minimize your weaknesses.

You can apply this approach to many things in life, I apply it to describing and using MySQL the product, and it’s components. The Query Cache like many features in MySQL, and indeed features in many different RDBMS products (don’t get me started on Oracle *features*) have relative benefits. In one context it can be seen as ineffective, or even detrimental to your performance, however it’s course grain nature makes it both trivial to disable dynamically (SET GLOBAL query_cache_size=0;), and also easy to get basic statistics on current performance (SHOW GLOBAL STATUS LIKE ‘QCache%’;) to determine effectiveness and action appropriately.

The Query Cache is course grained, that is it is rather simple/dumb in nature. When you understand the path of execution of a query within the MySQL kernel you learn a few key things.

• When enabled, by default the Query …

The article was published in July but I noticed it only today. I guess I should pay more attention to my favorite topics when I travel.

Oracle is keeping MySQL. Yahoo is selling Zimbra. Linus is feeling bloated. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

# Larry Ellison reportedly said Oracle has no intention of spinning off MySQL.

# Yahoo is trying to sell Zimbra, according to All Things D.

# Linus Torvalds said Linux is “bloated and huge”.

# GroundWork Open Source released GroundWork Monitor 6.0.

# Zend launched Simple API for Cloud Application …

With a discussion on identifying CPU and Memory bottlenecks achieved, let us now look at how Disk can affect MySQL performance.

One of the first steps when addressing a MySQL performance tuning problem is to perform a system audit of the physical hardware resources (CPU,Memory,Disk,Network), then identify any obvious bottlenecks in these resources.

There are several commands you can use including vmstat, iostat and sar (both part of the sysstat package) to provide information on disk I/O.

vmstat is a good place to start for an overall view for multiple resources, however for disk it only provides a total system overview.

procs -----------memory---------- ---swap-- -----io---- -system-- …

Topics for this podcast:

*Microsoft founds CodePlex Foundation, losing Sam Ramji
*Software patents at the center of MS, OIN maneuvering
*Eucalyptus Systems releases hybrid cloud product
*Oracle-Sun Microsystems and the potential fate of MySQL

iTunes or direct download (26:40, 6.1 MB)

Citrix joins the Linux Foundation. BonitaSoft raises $3m. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

# Citrix joined The Linux Foundation.

# Open source BPM vendor BonitaSoft raised $3m from Ventech and Auriga Partners.

# Jaspersoft updated JasperReports Professional with enhanced data visualization.

# US CIO Vivek Kundra outlined the government’s cloud strategy, using NASA’s open source Nebula cloud.

# Infobright …