Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
All MySQL editions provide a component_keyring_file component, which stores keyring data in a file local to the server host. MySQL Enterprise Edition offers additional keyring components and plugins: component_keyring_encrypted_file: Stores keyring ... InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system tablespace, redo logs, and undo ...You can set an ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-secure-installation.html
Normal usage is to connect to the local MySQL server; invoke mysql_secure_installation without arguments: mysql_secure_installation When executed, mysql_secure_installation prompts you to determine which actions to perform. For example, to connect ... This program enables you to improve the security of your MySQL installation in the following ways: You can set a password for root ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-program-reference-server-script-config.html
The config.sh / config.bat script is used to configure the MySQL Server Repository for the Service Monitor. This must be a resolvable name or IP address of the server where the MySQL instance is running. The following example instructs MySQL ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-dbsystems-intro.html
MySQL Server 1.2 MySQL Server The MySQL Server on MySQL HeatWave on AWS is built on the MySQL Enterprise Edition Server, which allows developers to quickly create and deploy secure cloud native applications using the world's most popular open ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore-cloud.html
To restore a backup image from cloud storage to datadir on the server, use the cloud storage options, and also the --backup-dir option to specify the temporary directory into which temporary output, status files, and backup metadata will be saved: ...
https://dev.mysql.com/doc/refman/8.4/en/memory-use.html
The default configuration is designed to permit a MySQL server to start on a virtual machine that has approximately 512MB of RAM. The MySQL Performance Schema is a feature for monitoring MySQL server execution at a low level. MySQL allocates ...The ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-error-log-table.html
Granting the SELECT privilege for the error_log table thus gives clients and applications access to error log contents using SQL queries, enabling DBAs to provide access to the log without the need to permit direct file system access on the server ... Of the logs the MySQL server maintains, one is the error log to which it writes diagnostic messages (see Section 7.4.2, “The Error ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-interface-usage.html
Prepared Statement Logging For prepared statements that are executed with the mysql_stmt_prepare() and mysql_stmt_execute() C API functions, the server writes Prepare and Execute lines to the general query log so that you can tell when statements ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-multiple-nodes.html
The following are issues relating to the use of multiple MySQL servers as NDB Cluster SQL nodes, and are specific to the NDBCLUSTER storage engine: Stored programs not distributed. Stored procedures, stored functions, triggers, and scheduled events ...A LOCK TABLES statement or GET_LOCK() call works only for the SQL node on which the lock is issued; no other SQL node in the cluster “sees” this ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-methods-ldap-kerberos.html
MySQL Enterprise Edition supports authentication methods that enable MySQL Server to use LDAP (Lightweight Directory Access Protocol), LDAP with Kerberos, or native Kerberos to authenticate MySQL users. Note The server-side LDAP and Kerberos ...