Search Results
https://dev.mysql.com/doc/refman/8.4/en/apis-perl.html
The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines without change. To use DBI with MySQL, install the following: The DBI module. Optionally, the DBD ...
https://dev.mysql.com/doc/refman/8.4/en/creating-accounts.html
To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and remove accounts. GRANT and REVOKE assign privileges to and revoke privileges from accounts. Account-management statements cause the ...
https://dev.mysql.com/doc/refman/8.4/en/data-types.html
MySQL supports SQL data types in several categories: numeric types, date and time types, string (character and byte) types, spatial types, and the JSON data type. This chapter provides an overview and more detailed description of the properties of ...
https://dev.mysql.com/doc/refman/8.4/en/federated-usagenotes.html
The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL server. The remote table that a FEDERATED table points to must exist before you try to access the table through the ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-restrictions.html
Full-text searches are supported for InnoDB and MyISAM tables only. The exception is that for Unicode, the utf8mb3 or utf8mb4 character set can be used, but not the ucs2 character set. Although FULLTEXT indexes on ucs2 columns cannot be used, you ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-maximum-consensus.html
The following functions enable you to inspect and configure the maximum number of consensus instances that a group can execute in parallel. group_replication_get_write_concurrency() Check the maximum number of consensus instances that a group can ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-length.html
The following table describes the maximum length for each type of identifier. For constraint definitions that include no constraint name, the server internally generates a name derived from the associated table name. For example, internally ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-collations-table.html
The COLLATIONS table provides information about collations for each character set. CHARACTER_SET_NAME The name of the character set with which the collation is associated. IS_DEFAULT Whether the collation is the default for its character set.
https://dev.mysql.com/doc/refman/8.4/en/keyring-encrypted-file-component.html
Note component_keyring_encrypted_file is an extension included in MySQL Enterprise Edition, a commercial product. The component_keyring_encrypted_file keyring component stores keyring data in an encrypted, password-protected file local to the ...
https://dev.mysql.com/doc/refman/8.4/en/memory-use.html
MySQL allocates buffers and caches to improve performance of database operations. The default configuration is designed to permit a MySQL server to start on a virtual machine that has approximately 512MB of RAM. You can improve MySQL performance by ...