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 …

We’re happy to announce the availability of the next Alpha release of MySQL Workbench 5.2. There have been further improvements to the querying part and we added the foundations for the administration part (which will be onboard in the next alpha).
On startup, MySQL Workbench 5.2 now doesn’t automatically create a new design-document anymore – thats for decreasing resource-usage when you only launch Workbench for running a few queries against your database. Also the fix to make Workbench work on Snow Leopard has been included in 5.2 now as well.

Please download the program, take it for a test-drive and tell us what you think. But keep in mind, that this is still an alpha version – so be advised to not use it for production data! Also please note, MySQL Workbench files saved with version 5.2 cannot be opened with previous versions of our
program.

For Linux we now …

Before I even start this post I am going to repeat our view that Oracle is well aware that it has little to gain from killing off MySQL and that we expect MySQL to become the scale-out database for non-transactional web applications and to compete with SQL Server in departmental deployments.

That said there has been some interesting discussion on Twitter this week in response to the European Commission’s investigation of Oracle-Sun about whether Oracle could - in theory - kill off MySQL. Here’s a Q+A explaining my view as to how Oracle could kill MySQL but probably won’t, and why MySQL AB’s choice of dual licensing and the GPL has come back to haunt Monty Widenius.

Q. Oracle can’t kill MySQL even if it wants to, because its open source. Right?

A. …

Following the release of our report, ‘The Myth of Open Source License Proliferation’ and during research for it, we heard and sensed a feeling that open source software licenses had evolved to become a generally well-accepted piece of the the enterprise IT and IP market. However, we also heard from numerous vendors, developers and other individuals that the next battlefront is obviously software patents, which are in need of reform, according to many supporters of free and open source software.

This week, we saw some of the software patent skirmishes that are driving and validating this thinking. There was first news that the Open Invention Network, the consortium dedicated to legal and IP defense of Linux, had bought some software patents that related to …

CodePlex, patents and Linux code. An interesting few days for Microsoft open source.

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

CodePlex, CodePlex, CodePlex!
Microsoft launched the CodePlex Foundation to facilitate open source contributions, and confirmed the departure of Sam Ramji.

Patents, Patents, Patents!
The OIN confirmed the acquisition of 22 patents formerly owned by …

MySQL provides a level of statistics for your INSERT, UPDATE, DELETE, REPLACE Data Manipulation Language (DML) commands using the STATUS output of various Com_ variables, however it is per server stats. I would like per table stats.

You can achieve this with tools such as MySQL Proxy and mk-query-digest, however there is actually a very simple solution that requires no additional tools.
The following 1 line Linux command (reformatted for ease of reading) gave me exactly what I wanted, and it had ZERO impact on the database.

$ mysqlbinlog /path/to/mysql-bin.000999 |  \
   grep -i -e "^update" -e "^insert" -e "^delete" -e "^replace" -e "^alter"  | \
   cut -c1-100 | tr '[A-Z]' '[a-z]' |  \
   sed -e "s/\t/ /g;s/\`//g;s/(.*$//;s/ set .*$//;s/ as .*$//" | sed -e "s/ where .*$//" |  \
   sort | uniq -c | sort -nr  

  33389 update e_acc
  17680 insert into r_b
  17680 insert into e_rec
  14332 insert into rcv_c
  13543 update e_rec
  10805 …

After my previous post about InnoDB Doublewrite Buffer impact I've received several feedbacks where people are claiming to see an important performance degradation when they enabling doublewrite... Discussing with them about their wokloads I've tried to reproduce a similar activity with dbSTRESS tool. And finally I was happy (or unhappy - all depends on the side :-))

• Happy because I was able to reproduce the problem :-)
• And unhappy because I've got 30% performance degradation by activating doublewrite buffer!

And now I'll tell you a story how to fix it :-))

Sorry, it'll be little bit long (but it was hard to make it shorter :-))
First of all let's get a look on the I/O activity and possible solutions to make it running more optimally...

I/O Requests
Generally we may …

Reaction to EC’s Oracle-Sun delay. OIN to acquire ex-Microsoft patents. 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.”

Reaction to EC’s Oracle-Sun delay
Despite widespread criticism of the European Commission’s decision to open a formal investigation into Oracle’s proposed acquisition of Sun, Glyn Moody maintained that the EC deserves credit for making open source a central part of its analysis. Meanwhile Monty Program (by way of Steven J Vaughan Nicholls) explained why the EU should block Oracle/Sun, Roberto Galoppini reported …