Search Results
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-4-0.html
MySQL Connector/J 9.4.0 supersedes 9.3 and is recommended for use on production systems. This release can be used against MySQL Server version 8.0 and later. Note These release notes were created with the assistance of MySQL HeatWave GenAI. It ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-6-0.html
MySQL Connector/J 9.6.0 supersedes 9.5 and is recommended for use on production systems. This release can be used against MySQL Server version 8.0 and later. Note These release notes were created with the assistance of MySQL HeatWave GenAI. It ...
https://dev.mysql.com/doc/refman/9.7/en/account-activity-auditing.html
When a client connects successfully, the server authenticates the client to a particular row in this table. Applications can use the following guidelines to perform SQL-based auditing that ties database activity to MySQL accounts. The User and Host ...
https://dev.mysql.com/doc/refman/9.7/en/alter-resource-group.html
If FORCE is given, existing threads in the group are moved to their respective default group (system threads to SYS_default, user threads to USR_default). ALTER RESOURCE GROUP group_name [VCPU [=] vcpu_spec [, vcpu_spec] ...] [THREAD_PRIORITY [=] ...
https://dev.mysql.com/doc/refman/9.7/en/backup-strategy-summary.html
In case of an operating system crash or power failure, InnoDB itself does all the job of recovering data. But to make sure that you can sleep well, observe the following guidelines: Always tun the MySQL server with binary logging enabled (that is ...If you have such safe media, this technique can also be good for disk load balancing (which results in a performance ...
https://dev.mysql.com/doc/refman/9.7/en/charset-general.html
In real life, most character sets have many characters: not just A and B but whole alphabets, sometimes multiple alphabets or eastern writing systems with thousands of characters, along with many special symbols and punctuation marks. Mix strings ...
https://dev.mysql.com/doc/refman/9.7/en/create-temporary-table.html
After a session has created a temporary table, the server performs no further privilege checks on the table. LIKE to create an empty table based on the definition of a table that resides in the mysql tablespace, InnoDB system tablespace ... You can ...
https://dev.mysql.com/doc/refman/9.7/en/drop-resource-group.html
If FORCE is given, existing threads in the group are moved to their respective default group (system threads to SYS_default, user threads to USR_default). Examples: Drop a group, failing if the group contains any threads: DROP RESOURCE GROUP rg1; ...
https://dev.mysql.com/doc/refman/9.7/en/drop-table.html
(For example, if an abnormal server exit occurs after removal of the table from the storage engine but before removal of the data dictionary entry.) The TEMPORARY keyword has the following effects: The statement drops only TEMPORARY tables. They are ...Be careful with this statement! For each table, it removes the table definition and all table ...
https://dev.mysql.com/doc/refman/9.7/en/events-overview.html
While there is no provision in the SQL Standard for event scheduling, there are precedents in other database systems, and you may notice some similarities between these implementations and that found in the MySQL Server. MySQL Events are tasks that ...