Search Results
https://dev.mysql.com/doc/refman/8.4/en/drop-user.html
DROP USER fails with an error if any account to be dropped is named as the DEFINER attribute for any stored object. (That is, the statement fails if dropping an account would cause a stored object to become orphaned.) To perform the operation ...The ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-secure-user.html
User credentials set using CHANGE REPLICATION SOURCE TO are stored in plain text in the replication metadata repositories on the server, but user credentials specified on START GROUP_REPLICATION are saved in memory only, and are removed by a STOP ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-length.html
This applies to identifiers in table definitions and to identifiers stored in the grant tables in the mysql database. You can use multibyte characters without reducing the number of characters permitted for values stored in these columns. For ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-syntax-warnings.html
This section describes syntax warnings and errors that you may encounter when using the table compression feature with file-per-table tablespaces and general tablespaces. SQL Compression Syntax Warnings and Errors for File-Per-Table Tablespaces ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-truncate-table-reclaim-space.html
To reclaim operating system disk space when truncating an InnoDB table, the table must be stored in its own .ibd file. For a table to be stored in its own .ibd file, innodb_file_per_table must enabled when the table is created. This is in contrast ...Additionally, there cannot be a foreign key constraint between the table being truncated and other tables, otherwise the TRUNCATE TABLE operation ...
https://dev.mysql.com/doc/refman/8.4/en/internal-temporary-tables.html
Internal Temporary Table Storage Engine An internal temporary table can be held in memory and processed by the TempTable or MEMORY storage engine, or stored on disk by the InnoDB storage engine. New data is stored in RAM if space becomes available ... In some cases, the server creates internal temporary tables while processing ...
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-functions.html
Note To store values generated by INET_ATON(), use an INT UNSIGNED column rather than INT, which is signed. If you use a signed column, values corresponding to IP addresses for which the first octet is greater than 127 cannot be stored correctly.
https://dev.mysql.com/doc/refman/8.4/en/miscellaneous-optimization-tips.html
This section lists a number of miscellaneous tips for improving query processing speed: If your application makes several database requests to perform related updates, combining the statements into a stored routine can help performance. See Section ...Similarly, if your application computes a single result based on several column values or large volumes of data, combining the computation into a loadable function can help ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-basics.html
NDB Cluster tables are normally stored completely in memory rather than on disk (this is why we refer to NDB Cluster as an in-memory database). However, some NDB Cluster data can be stored on disk; see Section 25.6.11, “NDB Cluster Disk Data ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-overview.html
When data is stored by the NDB storage engine, the tables (and table data) are stored in the data nodes. The data stored in the data nodes for NDB Cluster can be mirrored; the cluster can handle failures of individual data nodes with no other impact ... NDB Cluster is a technology that enables clustering of in-memory databases in a shared-nothing ...