Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-read-only-instance.html
For example, CREATE USER, GRANT, REVOKE, and INSTALL PLUGIN operations are not permitted in read-only mode. The default setting is ibtmp1:12M:autoextend, which creates the ibtmp1 temporary tablespace data file in the data directory. For example: ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-general-options.html
--defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File name Read this option file after the global option file but (on Unix) before the user option file. The temporary files needed to sort the keys would be ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-table-info.html
To obtain a description of a MyISAM table or statistics about it, use the commands shown here. The output from these commands is explained later in this section. myisamchk -d tbl_name Runs myisamchk in “describe mode” to produce a description ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-overview-requirements.html
See Section 25.6.8.2, “Using The NDB Cluster Management Client to Create a Backup”, for more information about creating encypted backups. Communication latency between these processes can directly affect the observed performance and latency of ... One of the strengths of NDB Cluster is that it can be run on commodity hardware and has no unusual requirements in this regard, other than for large amounts of RAM, due to the fact that all live data storage is done in ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog-backup.html
Along with --read-from-remote-server, it is common to specify other options: --host indicates where the server is running, and you may also need to specify connection options such as --user and --password. Use mysqlbinlog to make a continuous backup ... By default, mysqlbinlog reads binary log files and displays their contents in text ...
https://dev.mysql.com/doc/refman/8.4/en/option-file-options.html
To create or modify a login path file, use the mysql_config_editor utility. Most MySQL programs that support option files handle the following options. Because these options affect option-file handling, they must be given on the command line and ...
https://dev.mysql.com/doc/refman/8.4/en/postinstallation.html
When you are ready to create additional user accounts, you can find information on the MySQL access control system and account management in Section 8.2, “Access Control and Account Management”. This section discusses tasks that you should ...
https://dev.mysql.com/doc/refman/8.4/en/session-state-tracking.html
A client can enable these trackers to receive notification of changes to its session state. Uses for Session State Trackers Available Session State Trackers C API Session State Tracker Support Test Suite Session State Tracker Support Uses for ...
https://dev.mysql.com/doc/refman/8.4/en/show-procedure-code.html
To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, or have the SELECT privilege at the global level. SHOW PROCEDURE CODE proc_name This statement is a MySQL extension that is available only ...
https://dev.mysql.com/doc/refman/8.4/en/sys-diagnostics.html
Creates a report of the current server status for diagnostic purposes. Configuration Options diagnostics() operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 30.4.2.1, ...