Create an account

Subscribe to LWN

Return to the Announcements page

LWN.net Weekly Edition for February 16, 2012

Book review: Open Advice

Linux support for ARM big.LITTLE

LWN.net Weekly Edition for February 9, 2012

Weekly edition	Kernel	Security	Distributions	Contact Us	Search
Archives	Calendar	Subscribe	Write for LWN	LWN.net FAQ	Sponsors

New MySQL Distribution: ExtSQL Provides Usage Accounting

[Posted October 3, 2008 by ris]

Software Workshop has developed their own modifications to MySQL and called it ExtSQL. ExtSQL gives database administrators a simple way to monitor activity by individual users, database, or even connection. ExtSQL has new commands built into the server as an extension to the SQL language. ExtSQL is being released under the GPL.

(Log in to post comments)

New MySQL Distribution: ExtSQL Provides Usage Accounting

Posted Oct 4, 2008 13:20 UTC (Sat) by mbottrell (guest, #43008) [Link]

I would have been nice if they submitted the patches back to MySQL.

I don't see the need for a fork for just these features.

New MySQL Distribution: ExtSQL Provides Usage Accounting

Posted Oct 4, 2008 16:18 UTC (Sat) by ewan (subscriber, #5533) [Link]

It's always possible that they tried but that Sun/MySQL weren't
interested in including the patches in mainline, or that Software
Workshop weren't prepared to give Sun/MySQL a non-GPL licence to their
code.

New MySQL Distribution: ExtSQL Provides Usage Accounting

Posted Oct 4, 2008 21:46 UTC (Sat) by tzafrir (subscriber, #11501) [Link]

They also have patches to PostgreSQL. In their FAQ they claim that developing outside of tree was the fastest way to get things done.

http://www.extsql.com/showPage.php?Page=faq (near the bottom)

New MySQL Distribution: ExtSQL Provides Usage Accounting

Posted Oct 5, 2008 21:44 UTC (Sun) by alvherre (subscriber, #18730) [Link]

They don't seem to have Postgres releases -- they only have placeholder links, and you can "vote" for them to implement those.

However, I don't see why would anybody wish to do that, as it seems that the feature they are offering is already present in mainstream Postgres ...

New MySQL Distribution: ExtSQL Provides Usage Accounting

Posted Oct 9, 2008 14:32 UTC (Thu) by jmurtari (guest, #54601) [Link]

I work on ExtSQL and noted the commentary on this. Perhaps
I can give a bit more insight into why decisions were made.

If you are a DBA and look at the tracking features offered and
the changes to SQL, it is a fairly significant change. The patch
set is pretty extensive and complex, making changes to a lot of
'core' areas of the mysql server. We think it will certainly get
picked up in the main MySQL distribution and that is a good thing.

At the same time we wanted to 'get it out there' so people could
try it. In the next few weeks we'll be addressing it on some of
the MySQL-internals lists, but like anything, I would expect some
hesitation given the extent of the changes and the desire by MySQL
to always have a very stable product.

Hopefully good feedback from developers trying it will expedite the
acceptance process; also, we are a commercial company and money is
a factor for us. We hope by providing pre-compiled binaries for much
earlier versions of MySQL we can support ourselves in this effort.

We are also on the ANSI US Standards committee for SQL(H2) (INCITS.ORG),
and would like to see this as a future addition to the standard.
We've also taken a novel approach to supporting the many Open Source
developers that are out there by offering them real pay for work done.
Our site allows developers to sign up and bid on projects.

Hope this helps!
John

Copyright © 2008, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds