Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
However, the data files must always be applied before the logs. This program reads the files created as a result of the backup and inserts the stored information into the database. ndb_restore must be executed once for each of the backup files that ...This is equal to the number of data nodes in the cluster at the time that the backup was ... The NDB Cluster restoration program is implemented as a ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-post-install.html
Other exceptions are the error log file, the mysql-files directory, the pid file, and socket file, to which the mysql user must have write access. $> cd /usr/local/mysql $> bin/mysqld --defaults-file=/etc/my.cnf --initialize Initialization output is ...(This implies the user can read any file in any database directory, because the server can access any of those files.) The FILE privilege also enables the user to create new files in any directory where the MySQL server has write ... Post-installation setup involves creating a safe directory for import and export ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
If the option names no file, the default error log destination on Unix and Unix-like systems is a file named host_name.err in the data directory. Unless otherwise specified, the default file location is the data directory if the value is a relative ...The most common methods are to provide options in an option file or on the command ... When you start the mysqld server, you can specify program ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-logging-configuration.html
Adding Query Statistics for Outlier Detection In MySQL 8.4, you can extend log files in JSON format with optional data fields to show the query time, the number of bytes sent and received, the number of rows returned to the client, and the number of ... This section describes how to configure audit logging characteristics, such as the file to which the audit log plugin writes events, the format of written events, whether to enable log file compression and encryption, and space ...
https://dev.mysql.com/doc/internals/en/guided-tour-skeleton.html
"Prepare: Parse the query Allocate a new statement, keep it in 'thd->prepared statements' pool Return to client the total number of parameters and result-set metadata information (if any)" The prepare is the step that must happen before execute ...
https://dev.mysql.com/doc/workbench/en/dbdoc-templates.html
These text files are processed by the template system built into MySQL Workbench, and the markers replaced by actual data. Variables Variables denoted by markers in the template file are replaced by their corresponding data prior to the generated ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-command-options.html
It specifies the directory in which files named in LOAD DATA LOCAL statements must be located. When --load-data-local-dir applies, the option value designates the directory in which local data files must be located. If the file does not exist or is ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/doc/ndbapi/en/mgm-functions-start-stop-nodes.html
The nodes to be started must have been started with the no-start option (-n), meaning that the data node binary was started and is waiting for a START management command which actually enables the node. The MGM API provides several functions which ...You can start, stop, and restart Cluster nodes using the following functions, which are described in more detail in the next few ...ndb_mgm_start() ndb_mgm_stop() ndb_mgm_stop2() ndb_mgm_stop3() ndb_mgm_stop4() ndb_mgm_restart() ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/glossary.html
For example, how much time is taken by a database query, or how full is the file system on a server machine. Agent The MySQL Enterprise Monitor component that actively collects data from a host and its MySQL server instances. asset A component that ... These terms are commonly used in information about MySQL Enterprise ...Based on ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
In addition, if --ndb-nodeid is used, then either a matching node ID must be found in a [mysqld] or [api] section of config.ini, or there must be an “open” [mysqld] or [api] section in the file (that is, a section without a NodeId or Id ...For ...For general information on using these, and for other options and variables not specific to NDB Cluster, see Section 7.1, “The MySQL ...