There's more noise about Solaris competing with Linux over at slashdot. I can understand the argument that Sun should direct their efforts to Linux. You know, Peace, Love, Linux. But which business would throw away their crown jewel to compete in the delivery of a product that already has a leading vendor (by some distance over #2)? Can you imagine asking MySQL to get into the Oracle support business (imagining that Oracle open sources their products)? Or let's pressure Alfresco to jump into the (future :-) open sourced MS SharePoint project. Yes, I know, it's ludicrous to ask MySQL or... READ MORE

What you see in the graph is a comparison of the read() versus
aio_read() in Archive. This is using Fedora Core 7. The test is
pretty simple. Read 10,000 rows, 1000 times per user. Increase the
number of users. No aggregate function was run, I did not see where
that was really needed for this test (aggregate functions/queries are
the main SELECT type used against Archive tables).

From the graph it is pretty obvious that aio_read() makes a
difference. I am going to run this later on the T1000 and see what
happens there (I've got other tests running on it right now so no
comparison for the moment...).

The open question for me now is how this compares to my hand written
AIO method. This code is pretty much ready to go (it won't be in MySQL 5.1,
it will got in the next version (which is either 5.2 or 6.0)). The
burnin test has been running …

And we thought it was all about peace, love, and...Solaris. But no, Sun is gearing up for one of the classic open source battles. We've had the various Linux distributions duking it out, and we've had MySQL versus PostgreSQL. Now we're getting Solaris versus Linux, and this is a fight that I believe may actually be worth having.

Why? Because it means more choice for customers, and not just any choice, but a choice between two exceptional operating systems, both completely open source.

Sun's strategy is becoming clearer with Solaris:

...

The Date dimension is a well known construct in general data warehousing. In many cases, the data for a date dimension is generated using a database stored procedure or shell-script.

Another approach to obtain the data for a date dimension is to generate it using an ETL tool like Pentaho Data Integration, a.k.a. Kettle. I think this approach makes sense for a number of reasons:

• 
  
• When you tend to use a particular ETL tool, you will be able to reuse the date dimension generator over an over, and on different database platforms.
  
• You won't need special database privileges beyond the ones you need …

New MySQL 6.0 Alpha Release

If you are reading this, chances are you already know the advantages of open source. Open source is free, benefits from a community of contributors, it's well tested, the list of benefits is long... right?

Well, I agree. It's hard to believe that someone would choose anything but apache to run a web server. But software runs in a lot of different places, different industries and cultures. In the world of billing, we are about 15 years behind the industry standard, as far as open source adoption goes. The other day I had in my hands an issue of a billing magazine (Billing & OSS World, I think is its name). They had an article on open source and it was half funny, half depressing. Open source was synonym of Linux, that's all. Like there is nothing else in the open source world but Linux.

In about two months, jbilling will be launching a new major release that will include a package of components that address es the needs of …

If you are reading this, chances are you already know the advantages of open source. Open source is free, benefits from a community of contributors, it's well tested, the list of benefits is long... right?

Well, I agree. It's hard to believe that someone would choose anything but apache to run a web server. But software runs in a lot of different places, different industries and cultures. In the world of billing, we are about 15 years behind the industry standard, as far as open source adoption goes. The other day I had in my hands an issue of a billing magazine (Billing & OSS World, I think is its name). They had an article on open source and it was half funny, half depressing. Open source was synonym of Linux, that's all. Like there is nothing else in the open source world but Linux.

In about two months, jbilling will be launching a new major release that will include a package of components that address es the needs of …

HighLoad.RU is the conference focused on Building High Performance Systems and has speakers from most of top Russian Internet companies.

It is taking place in Moscow, Russia 24-25 of September and you should know a bit of Russian to attend

The conference has some international flavor though there are few people coming from other countries and giving talks in English. I too will fly from London but I'll specially prepare Russian presentation versions.

I'll have two sessions: MySQL Transactional Storage Engines and MySQL Scaling Techniques for Web Applications.

Here is the full conference program.

Andrey has implemented a little mysqlnd only addition to mysqli_debug(): ‘m’ - dump memory information. It works like the other options described in PHP: Debugging ext/mysqli and mysqlnd with the only difference that it is only available with mysqlnd.

Without option ‘m’

This is a short example of mysqlnd freeing the meta data of a result set.

[...]
| | | >mysqlnd_res_meta::free
| | | | info : persistent=0
| | | | info : Freeing fields metadata
| | | | info : Freeing zend_hash_keys
| | | | info : Freeing metadata structure
| | | >mysqlnd_res_meta::free
[...]

Additional mysqlnd memory allocation debug information with option ‘m’

Same trace excerpt but with memory debugging turned on. The control string used for this trace was ‘t:O,/tmp/mysqlnd.trace:m’.

[...]
| | | >mysqlnd_res_meta::free
| | | | info : …

Andrey has implemented a little mysqlnd only addition to mysqli_debug(): ‘m’ - dump memory information. It works like the other options described in PHP: Debugging ext/mysqli and mysqlnd with the only difference that it is only available with mysqlnd.

Without option ‘m’

This is a short example of mysqlnd freeing the meta data of a result set.

[...]
| | | >mysqlnd_res_meta::free
| | | | info : persistent=0
| | | | info : Freeing fields metadata
| | | | info : Freeing zend_hash_keys
| | | | info : Freeing metadata structure
| | | >mysqlnd_res_meta::free
[...]

Additional mysqlnd memory allocation debug information with option ‘m’

Same trace excerpt but with memory debugging turned on. The control string used for this trace was ‘t:O,/tmp/mysqlnd.trace:m’.

[...]
| | | >mysqlnd_res_meta::free
| | | | info : …