mysqlreport v3.4a is ready which, like the recently released v3.4, fixes a bug in the relative reports. This time, it was the InnoDB reports which were not correct when made relative. Changes in v3.4a are:

• Fixed bug: InnoDB report values were wrong in relative reports because 13 InnoDB status values needed to be excluded from being made relative. (thanks Debbie)
• Changed InnoDB Buffer Pool Read ratio to Read hit %

The Guide to Understanding mysqlreport has been accordingly updated, too.

I have been noticeably absent on my comments in this topic, something I was pinged about yet again today by another colleague.
Did I have nothing to say? No. It’s just I’ve not been able to say much, or actually do anything in the past 7 days due to strong bought of the flu which has kept me in bed near 5 days straight (coincidently aligning perfectly with MySQL’s recent ACM. Go figure that luck).

So what are my thought’s here. (Ok, I’m going to waffle a bit with my point of view, but my key technical points for those of you that just want that, scroll down to the next section heading)

Overall I believe it’s a good thing, on the surface and at the moment. As mentioned MySQL was on an IPO path, I’d would have liked the option to buy my own MySQL shares, be part of a company that got to that point (have worked for 2 failed startup Internet companies previously). I think there would have been many a proud MySQL …

I have been noticeably absent on my comments in this topic, something I was pinged about yet again today by another colleague. Did I have nothing to say? No. It’s just I’ve not been able to say much, or actually do anything in the past 7 days due to strong bought of the flu which has kept me in bed near 5 days straight (coincidently aligning perfectly with MySQL’s recent ACM.

Earlier this month I took a look at Fortune’s tips for initial public offerings in 2008 and passed comment on the open source-related contenders. Given the events of the past ten days or so it is worth taking another look at the open source vendors that might make IPO candidates between now and the turn of the decade.

Once again I should note that I have no knowledge of the IPO plans of these companies beyond that which is presented below, and the assessment of their potential is my own.

Ingres

Ingres has confirmed that it intends to file for IPO in 2008. It had expected to follow MySQL, but will now be the first open source database …

I really like the 21st century open source technology community. 20 years ago, if a company bought out another company, everyone would have their own island of opinions and response, and you would not know if you were on-track or even if the publicized reports were on-track either.Today, it is amazing to see the responses around the boards and blogs, which seems to keep the mainstream reports

Data Warehousing Continued

Part of the reason I was hired by my company was to help the company?s largest customer connect their data warehouse to the company?s website database. I have data basing experience but I have never been involved in such a large project (don?t tell my bosses). Luckily for me, I wont be doing everything, but for starters, I had to get some customer data, mainly email addresses and build a newsletter mailing list. Sounds simple enough..
Unfortunately for me, I had no idea how difficult it is to take even simple data fields from 2-3 sources and merge it into one. Some of the systems were so old, that back when they recorded the email address, there were no validation rules to enforce the input from the users. I saw emails like this http://www.163.com@yingying837.cn (163.com is a Chinese email server). It seemed to me that the people who inputted this email address only recently purchased a computer.
…

When you connect a Linux server to a SAN, the network driver will present the available SAN partition as normal SCSI drives. This can be more complicated when more than one Fiber Channel paths are involved. Let’s consider a server having two FC adapters (or a dual port one) and a SAN having two FC channels. For this server, each SAN partitions will appear four times but some FC adapter drivers, like the QLogic ones, will filter them out.

If you are using another brand of Fiber Channel adapters, like Emulex, you will see all of them. I recently worked on a MySQL project using 9 SAN partitions so I ended up dealing with 36 SCSI devices (/dev/sdb to /dev/sdao). Dealing with so many devices is not a fun task, especially if the order of the disks is not preserved between after a reboot. My first attempt to deal with this problem was to use partition label and mount partition by label. Although this solution worked, it was slow and I sometimes …

Yet Another Sun Bought MySQL Post

So Sun bought MySQL?. dunno about you, but I was surprised. My first impression was ?nooooooooooooooo, I liked it when it was small and my contributions made a difference?, but I realized that it has obvious big advantages.

The main one, which has been mentioned over and over again, is the support of MySQL will grow to the level which I might see it in companies that opted not to get it and use commercial databases.

When I was interviewed for my current job, I learnt that the company made a website for a large customer and that they were using MySQL along side open source frameworks for it. The customer would want in the future to integrate the data, the website gathers, to their CRM system. Because of that, they were thinking about moving to using Oracle. They were also thinking of moving to Oracle anyway, because and I quote ?we have more then 500 views a day on the …

Heh, who knew we'd see the day that Gartner would write this:Recommendations for all enterprises
...
MySQL is capable of supporting clusters, delivering atomic, consistent, isolated and durable (ACID) functionality and handling some mission-critical applications. Evaluate MySQL as an alternative to IBM DB2, Oracle and other DBMSs.Well, fact of the matter is, they did write it in a recent report on the MySQL / Sun deal. You can download the Gartner analysis right here free of charge.

A few weeks after the latest useful quiz, I want to offer a funny one.
Given the following table, on a MySQL server 5.1.22 or newer,

CREATE TABLE t1 (id int, c char(100)) engine=MyISAM;

1. Create one set of three triggers that must all be activated BEFORE INSERT.
   
   • Upon insertion of the values (1, 'nothing'), the first trigger should replace 'nothing' with 'something', leaving the number unchanged;
   • the second trigger should add ' more ';
   • the third trigger should add '!!'.
2. Create one set of three more triggers, all activated BEFORE INSERT.
   
   • Upon insertion of the values (1,'nothing') the first trigger should add 10 to the number, leaving the text unchanged.
   • the second trigger should add 100 to the number;
   • the …