Channels ▼


MySQL Looks To Make Database Administrators' Jobs Easier

MySQL, the supplier of the open source database with the same name, this week started shipping a new enterprise version of its MySQL Server 5.0 database that eases the workload of database administrators. The new version comes with an expert advisory service built in, as well as monitoring information and problem-identifying alerts offered on a dashboard.

The dashboard system has operational intelligence built into it that can detect trouble signs in a database's operation. Administrators also can customize it with up to 65 rules for monitoring running systems, says Zack Urlocker, MySQL executive VP for products.

Online Buddies' database administrator Sheeri Kritzer is beta testing Enterprise Edition for the nine production databases that she oversees. The site, which includes dating, employment, and personal ads, has 800,000 users, with 40% using it once or more per week. Kritzer was an early user of MySQL Enterprise advisory service.

The Enterprise dashboard "allows us to see trends in CPU utilization, database activity, database connection, and cache hit ratios," she noted in an e-mail response to questions. The monitoring detail can be applied to a group of servers or any individual server.

The monitoring tools can help administrators identify problems that can cause a database to run slower and slower over time. Possible causes of such slowdowns include queries not finding the data they need in cache, or too many queries requiring full-table scans on large tables. The new dashboard "will alert you to those scenarios; also when CPU usage is high or someone has changed the schema in a database," she wrote.

The monitoring allows alerts before a problem becomes a production-threatening issue. In the event of a database failure, the dashboard advisory service has a built-in audit trail that can be used to reconstruct events that occurred before a crash.

"We haven't had to do one of those in a while, but I can imagine it would be useful to see the CPU load, connections, and database activity just before a crash," crucial forensic evidence when seeking to prevent the next mishap, she wrote.

Urlocker says 40% of MySQL's business is now purchased for enterprise database use. MySQL got its start as a Web site database for startups, thanks to its ease of implementation and speed of serving content. It's used at and other content-serving sites. MySQL Enterprise includes the open source InnoDB transaction engine, with enterprise-oriented backup and recovery features. InnoDB is now owned by Oracle but the system is still issued under the open source GPL license.

MySQL earlier this year received $18.5 million in its third round of venture capital funding. Investors included Intel Capital; Red Hat, which distributes MySQL with Red Hat Enterprise Linux; and SAP Ventures, a unit of application supplier SAP AG.

Related Reading

More Insights

Currently we allow the following HTML tags in comments:

Single tags

These tags can be used alone and don't need an ending tag.

<br> Defines a single line break

<hr> Defines a horizontal line

Matching tags

These require an ending tag - e.g. <i>italic text</i>

<a> Defines an anchor

<b> Defines bold text

<big> Defines big text

<blockquote> Defines a long quotation

<caption> Defines a table caption

<cite> Defines a citation

<code> Defines computer code text

<em> Defines emphasized text

<fieldset> Defines a border around elements in a form

<h1> This is heading 1

<h2> This is heading 2

<h3> This is heading 3

<h4> This is heading 4

<h5> This is heading 5

<h6> This is heading 6

<i> Defines italic text

<p> Defines a paragraph

<pre> Defines preformatted text

<q> Defines a short quotation

<samp> Defines sample computer code text

<small> Defines small text

<span> Defines a section in a document

<s> Defines strikethrough text

<strike> Defines strikethrough text

<strong> Defines strong text

<sub> Defines subscripted text

<sup> Defines superscripted text

<u> Defines underlined text

Dr. Dobb's encourages readers to engage in spirited, healthy debate, including taking us to task. However, Dr. Dobb's moderates all comments posted to our site, and reserves the right to modify or remove any content that it determines to be derogatory, offensive, inflammatory, vulgar, irrelevant/off-topic, racist or obvious marketing or spam. Dr. Dobb's further reserves the right to disable the profile of any commenter participating in said activities.

Disqus Tips To upload an avatar photo, first complete your Disqus profile. | View the list of supported HTML tags you can use to style comments. | Please read our commenting policy.