Sunday, June 13, 2021

Sun Expands MySQL With Closed Source

Sun’s open source database MySQL is getting an enterprise update today — thanks to closed source.

The MySQL Enterprise Fall 2008 Release includes the new MySQL Query Analyzer tool, a proprietary source component designed to help improve database efficiency.

The Query Analyzer tool is being integrated with MySQL Enterprise Monitor to monitor database query performance, enabling administrators to view bottlenecks and optimize code. It’s only being offered to MySQL’s paying customers, however.

“Query Analyzer is a proprietary tool and it does have closed source components,” Rob Young, senior product marketing manager at MySQL, told InternetNews.com. “It is a closed source product that we make available only to our enterprise subscribers.”

Fears over MySQL making more of its code closed-source erupted earlier this year, several months after the acquisition of MySQL by Sun (NASDAQ: JAVA) for $1 billion.

Though Query Analyzer is only available to paying customers, Young admitted that the tool could be something that would useful for all MySQL users.

“We really think it has global applicability across all of our user base, whether people are paying us or not,” Young said. “The plan for now is to keep it commercial and proprietary, but we’d like to keep our options open. It could go out as GPL, but at this point the options are open to us.”

MySQL began offering subscriptions-based support with MySQL Network in early 2005. The MySQL Enterprise subscription offering replaced the MySQL Network in 2006, with the MySQL Enterprise Monitor now a key part of that offering.

There are a number of benefits that Young claimed customers will see by using the Query Tool, which provides an aggregated view of database queries and execution times across MySQL database servers.

“Basically, we’ve extended the MySQL agent to have a proxy nature to it, so it will now proxy the connection between an application and the back-end server, which allows us to capture the queries as they pass through,” Young explained.

The tool can show the total execution time for a query across servers as well as report on the number of rows that a query is returning. Developers then can use the results to can determine if they’re pulling back too much data that their application might not be using.

“The most compelling thing is we aggregate query executions and show [database administrators] the number of times a query is executing,” Young said. “You may have a query that is running really fast that may not pop up on your radar screen. But if it’s running half a million times an hour across all your servers in error, that’s a performance problem.”

Young noted that the Query Analyzer could be a benefit to both run-time databases as well as those that are being developed, as both could be optimized with the help of the tool.

So where’s MySQL 5.1?

The new Query Analyzer will also work with the upcoming MySQL 5.1 database, a release that’s been anticipated for months but has yet to ship.

Sun first announced the 5.1 database back in April, at the time claiming that it would be available by June — which didn’t happen. Young commented that the plan is now for MySQL 5.1 to be released on Dec. 9.

This article was first published on InternetNews.com. To read the full article, click here.

Similar articles

Latest Articles

Top Data Visualization Tools...

The amount of data generated and consumed by organizations is growing at an astounding rate. The total volume of data and information worldwide has...

The Data Capture Market

Data capture is the process of collecting, ingesting, or otherwise acquiring structured and unstructured data and either converting it into a data format usable...

NVIDIA and the Move...

NVIDIA recently held a Q&A with its visionary CEO Jensen Huang.   While the Q&A this week focused on NVIDIA’s announcements at Computex, his opening and...

Acquia Updates Open Digital...

BOSTON – Acquia’s Drupal-based customer experience (CX) platform is looking different to enterprise users. Acquia made updates last quarter across its three-part Open Digital Experience...