Access databases, monitor and adjust MySQL settings. Keep track of the status of MySQL replication, tweak the application code parameters, work with dynamic queries and database schemas that generate statistics about server execution and query performance.
MySQL is a relational database management system. The program runs as a server providing access to the databases. MySQL 's source code is available under terms of the GPL License, that means you can download it and use for free. If you want support and training by the company, you can contact them. You can have it up to date with tools for upgrading and configuring MySQL. Monitoring and adjusting MySQL settings that will tune, scale and maintain performance. In production, you can setting-up and monitor the status of MySQL replication with a simple and easy to use interface. Application code, database schemas and dynamic queries can be tunned up if you experience performance issues.
As a counterpart, MySQL 5.1 has some known bugs in addition to the present in version 5.0. Critical bugs sometimes do not get fixed for long periods of time. Also it shows poor performance when used for Data Warehousing; this is partly due to inability to take advantage of a cluster of CPU cores for processing a single query. Despite all this, this is the preferred database for web developers.
v5.7 [May 23, 2013]
Optimizer Notes
- It is now possible to provide hints to the optimizer by including /* ... */ comments following the SELECT, INSERT, REPLACE, UPDATE, or DELETE keyword of SQL statements. Such statements can also be used with EXPLAIN.
Packaging Notes
- Several binary distribution types have been made more modular, to split out test components into a separate distribution file. This reduces the size of the main download. In addition to the previously available test/debug distributions already available for Windows Zip archives, RPM packages, and Debian packages, the current release makes separate test distributions available for Solaris PKG files, and generic binary Linux and OS X compressed tar packages. These separate distributions have “test” in the distribution file name.
- Generally, use of a test distribution requires that the main distribution is also installed. Additionally, for Solaris, the main and test distributions must be for the same version of MySQL.
Performance Schema Notes
- These Performance Schema changes have been made:
- - The MySQL sys schema is now installed by default during data directory installation. This is a set of objects that provides convenient access to data collected by the Performance Schema.
- - For new installations, mysql_install_db installs the sys schema. To permit this behavior to be suppressed, mysql_install_db now has a --skip-sys-schema option.
- - For upgrades, mysql_upgrade installs the sys schema if it is not installed, and upgrades it to the current version otherwise. To permit this behavior to be suppressed, mysql_upgrade now has a --skip-sys-schema option.
- - For sys schema usage instructions, see https://github.com/MarkLeith/mysql-sys.
- - The events_statements_history and events_transactions_history consumers now are enabled by default.
Feature-rich relational database known for its high performance and excellent concurrency
