With MySQL and its proven performance, reliability and ease of use, it has become the main option I use for database in Web-based applications. In addition, it is an extremely popular alternative as an integrated database.
With its latest version, MYSQL 5.0 append new important features that make it more competitive with drivers such as SQL Server, Sybase and Oracle.
Something I find very fascinating in this new released version I can summarize it in this way:
Use of transactions ACID (Atomic, Consistent Isolated, Durable): To build more secure applications through commit, rollback, crash recovery and blocking by registration.
Store Procedures: To improve programming.
Triggers: To improve business rules.
Views: So that sensitive information is more secure.
Information Schema: For easy access to metadata.
Distributed Transactions (XA): To support transactions between multiple database environments
The new features in turn also bring with them new problems that until now are supported by technical support. for example:
Mirroring with disconnected states
The message is duplicated in / etc / motd
filter a message in the log messages
validate the execution time of a process
Statistics in the database
but as I have indicated before, these problems are already being solved by the trained personnel. And by the way, I mention that he is very trained and I congratulate him
I recently made some basic adjustments to improve the performance of MySQL. By adjusting these parameters properly, you can obtain many improvements in the performance of the database, especially if the database server does not have enough resources, and if the SQL optimization part can not be improved much more.
First of all, it can be very useful to take a look inside phpMyAdmin to the sections 'Show MySQL runtime information' and 'Show MySQL system variables', normally accessible from the main page of the application.
The first shows information and statistics that the system collects and maintains from its start. Special attention must be paid to the values of the variables shown in red, and to the tips indicated to the right of these values.
in summary you must have high knowledge of this manager to make changes and adjustments to the required level.
having acquired the license for MySQL server we have eliminated great problems with this manager of tados and has resulted in immediate progress with the company. for example: we have equipment inventory control and the same website of the corporation is managed with said manager.
certainly this tool is very attractive, I hope to continue giving the required use and to continue improving its performance