MySQL, a world-renowned open-source database vendor, will reduce the burden on database administrators by releasing the new MySQL Server 5.0 Enterprise edition this week. The new version of MySQL has a built-in expert recommendation service and a performance monitoring panel to monitor database information and issue identification alarm services.
Zack Urlocker, executive vice president of MySQL products, said the performance monitoring panel has a built-in smart operation function to monitor fault signals in database operations. It can also be customized and monitored by the database administrator through up to 65 rules.
Sheeri Kritzer, one of the early users of MySQL recommended services, is a database administrator for an online community site. Currently, she has not deployed MySQL Enterprise Edition for the nine product databases it is responsible, but she is testing it. This site has 0.8 million users and has 40% million users each week.
On the Enterprise monitoring panel, you can view CPU utilization trends, database activity, database connection, and cache usage rates. The monitoring details can be applied to a group of servers or individual servers.
Monitoring tools help system administrators identify problems that slow database servers over time. There are various causes of server slowdown, including query failure to find the required data from the cache, or too many query queries that require full table scanning for large tables. The new panel will alert you about these situations, or when the CPU usage is very high or some people modify key information about the database.
If these problems are exposed before the database performance is affected, it is very helpful for internal database administrators, third-party system integrators, and database service providers.
The competitor of MySQL Enterprise-level servers is Pervasive DB, which is also a commercial database software from the open-source community. The latter is from PostgreSQL, which is also an excellent open source database software.