Following up on yesterday's post about Peter Drucker's principles of effective executives, I asked former CEO of MySQL Mårten Mickos to discuss the principles that we has used in building an effective executive team. After all no single executive can be successful on their own; to build a high-performance culture requires a discipline that extends across the entire leadership.

read more

This Thursday (July 2nd, 13:00 UTC), Roland Bouman will will take the Sakila sample database and explain how to design and load a data warehouse for it, and how to use that to create those reports and charts that make managers smile. Along the way, he'll explain often uttered terms and concepts such as dimensional model, denormalization, star schema, OLAP, data staging, business intelligence, ETL and data integration. Roland's session is titled Starring Sakila - A Data Warehouse Mini-Tutorial.

For MySQL University sessions, point your browser to this page. You need a browser with …

This Thursday (July 2nd, 13:00 UTC), Roland Bouman will will take the Sakila sample database and explain how to design and load a data warehouse for it, and how to use that to create those reports and charts that make managers smile. Along the way, he'll explain often uttered terms and concepts such as dimensional model, denormalization, star schema, OLAP, data staging, business intelligence, ETL and data integration. Roland's session is titled Starring Sakila - A Data Warehouse Mini-Tutorial.

For MySQL University sessions, point your browser to this page. You need a browser with …

Last week I gave a MySQL University Presentation about how to contribute code to MySQL. This time DimDim did not fail to record the session, even though there is a funky overlap of audio from Stefan Hinz (the moderator) and myself at the beginning. I had a bit of a slow start into the presentation, because of a very nasty headache that plagued me that day. But we had a lively discussion at the end and I hope it was useful to the participants.

In case you have missed it, you can now watch the playback or download the session slides:

• Presentation slides: MySQL Code Contributions (PDF)
• …

Kickfire is really different than anything you have seen before

The Kickfire column store and SQL chip combine to achieve database performance never before seen in  a small footprint and power efficient database appliance, or in any other relational database to date for that matter.

I’d like to demonstrate the performance of the Kickfire model 2400 appliance running query #17 of the DBT-3 benchmark.  Others have blogged about this query recently, so I figured it would be good to look at Kickfire performance on this query.  I decided to present results not at one or ten gigabytes, but instead at one terabyte of data.

Have you ever experienced using MySQL on a very large database?

Let me begin by saying that I don’t think anybody has ever had the patience to allow this query to run to completion on MySQL with one terabyte of data.  At the time of this …

FISL 2009 wrapped up over the weekend. Even though the conference officially ended on Saturday but the connections made there will certainly allow us to continue all the great momentum. The conference celebrates open source and it was certainly great to see Federal Government and Banks with their booths in the exhibitor halls. The visit by Brazilian President Lula certainly highlights the importance of this conference to the local community. There were booths from Debian, Firefox, Ubuntu and other major open source softwares. Some commercial vendors had a booth as well and of course Sun Microsystems had a big presence with GlassFish, Open Solaris, NetBeans, MySQL and …

FISL 2009 wrapped up over the weekend. Even though the conference officially ended on Saturday but the connections made there will certainly allow us to continue all the great momentum. The conference celebrates open source and it was certainly great to see Federal Government and Banks with their booths in the exhibitor halls. The visit by Brazilian President Lula certainly highlights the importance of this conference to the local community. There were booths from Debian, Firefox, Ubuntu and other major open source softwares. Some commercial vendors had a booth as well and of course Sun Microsystems had a big presence with GlassFish, Open Solaris, NetBeans, MySQL and …

As you see MySQL is doing great in InnoDB performance improvements, so we decided to concentrate more on additional InnoDB features, which will make difference.

Beside ideas I put before http://www.mysqlperformanceblog.com/2009/03/30/my-hot-list-for-next-innodb-features/ (and one of them - moving InnoDB tables between servers are currently under development), we have few mores:

- Stick some InnoDB tables / indexes in buffer pool, or set priority for InnoDB tables. That means tables with bigger priority will be have more chances to stay in buffer pool then tables with lower priority. Link to blueprint https://blueprints.launchpad.net/percona-patches/+spec/lru-priority-patch

- Separate LRU list into several …

Kickfire is really different than anything you have seen before

The Kickfire column store and SQL chip combine to achieve database performance never before seen in  a small footprint and power efficient database appliance, or in any other relational database to date for that matter.

I'd like to demonstrate the performance of the Kickfire model 2400 appliance running query #17 of the DBT-3 benchmark.  Others have blogged about this query recently, so I figured it would be good to look at Kickfire performance on this query.  I decided to present results not at one or ten gigabytes, but instead at one terabyte of data.

Have you ever experienced using MySQL on a very large database?

Let me begin by saying that I don't think anybody has ever had the patience to allow this query to run to completion on MySQL with one terabyte of data.  At the time of this writing, …

Danfoss Electronic Controls & Sensors, one of Denmark's largest industrial companies, today announced it has selected Sun Microsystems' MySQL database to help power its air conditioning software application AKM, Adap-Kool Monitoring. The AKM software enables commercial facilities, such as grocery store staff, to monitor and control temperature levels inside store premises. Embedding MySQL into AKM will enable Danfoss to increase the number of concurrent users of the application, while maintaining a high level of availability and performance.