Search Results
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 ...
https://dev.mysql.com/doc/refman/9.7/en/general-security-issues.html
For information specifically about the access control system that MySQL uses for setting up user accounts and checking database access, see Section 2.9, “Postinstallation Setup and Testing”. For answers to some questions that are often asked ...
https://dev.mysql.com/doc/refman/9.7/en/getting-mysql.html
For RPM-based Linux platforms that use Yum as their package management system, MySQL can be installed using the MySQL Yum Repository. For SUSE Linux Enterprise Server (SLES) platforms, MySQL can be installed using the MySQL SLES Repository. Check ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-fine-tuning-the-group-communication-thread.html
The GCT receives messages from the group and from the plugin, handles quorum and failure detection related tasks, sends out some keep alive messages and also handles the incoming and outgoing transactions from/to the server/group. This is because ...