JasperSoft, formerly known as Panscopic, and a leader in commercial open source reporting solutions has unveiled the new JasperReports DBA Dashboard for MySQL.The open source JasperReports DBA Dashboard for MySQL is designed to give MySQL administrators the ability to monitor performance and use, plus identify problems across an unlimited number of MySQL database servers.

Demonstrations of the product are available in the MySQL booth #810 at LinuxWorld.

JasperReports is the world’s most popular open source reporting engine, the company says. Downloaded more than 420,000 times, JasperReports has been deployed in 10,000 leading companies and ISVs in at least 50 countries. JasperReports is currently ranked as the 7th most active project on Sourceforge.com, which hosts over 100,000 open source projects. An industry standard, it is now integrated with MySQL and JBoss.

“MySQL and JasperReports are used together frequently in open source applications,” said Al Campa, founder and executive vice president at JasperSoft. “Typically, JasperReports is used to display MySQL data in a variety of report types, including HTML, PDF, Excel, CSV and XML. Now, JasperSoft has built an extension to JasperReports that accesses and stores performance and usage data from a number of MySQL database servers, and presents it within JasperReports’ Dashboard view. MySQL DBAs now will have the ability to monitor the performance of an unlimited number of MySQL servers over any period of time.”

JasperReports is heavily used within the MySQL community. A recent survey conducted by MySQL revealed that JasperReports is the most popular reporting engine within the MySQL community. More than 40 percent of MySQL users who responded to the survey said they were using or considering JasperReports.

“Given the popularity of the JasperReports reporting engine in the MySQL community, a JasperReports-based DBA Dashboard for MySQL makes perfect sense,” said Robin Schumacher, director of product management, MySQL AB. “The JasperReport DBA Dashboard for MySQL can be a tremendous help to MySQL DBAs, providing an extension to JasperReports that lets them monitor and tune their database servers to build high- performing and large-scale MySQL applications.”

Using JasperReports DBA Dashboard for MySQL, DBAs will be able to:

• Capture real-time performance and usage stats, such as selects, inserts, connections, login times, as well as schema and privilege information, for an unlimited number of MySQL database servers;

• Display the stats by second, minute, hour, or day in JasperReports

• Allow MySQL database administrators to monitor performance and quickly identify problems in real time.