PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/query-log.html
Note If you specify the TABLE log destination, see Log Tables and “Too many open files” Errors. The server creates the file in the data directory unless an absolute path name is given to specify a different directory. The log_timestamps system ...The general query log can be very useful when you suspect an error in a client and want to know exactly what the client sent to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-nodes.html
config_generation The version of the cluster configuration file in use on this data node. This table contains information on the status of data nodes. For each data node that is running in the cluster, a corresponding row in this table provides the ...For nodes that are starting, it also shows the current start ...This is one of: NOTHING, CMVMI, STARTING, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-installation.html
In NDB 8.0.21 and earlier releases, all network addresses used for connections to or from data and management nodes must use or be resolvable using IPv4, including addresses used by SQL nodes to contact the other nodes. Whereas the examples in ...
https://dev.mysql.com/doc/refman/8.0/en/option-defaults-equals.html
080111 22:53:32 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var 080111 22:53:34 mysqld_safe mysqld from pid file /usr/local/mysql/var/tonfisk.pid ended [1]+ Done ./mysqld_safe --log-error my-errors The server attempted to ...080112 12:53:40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var $> After shutting down the server, restart it as follows: $> mysqld_safe --log-error & [1] 11699 $> 080112 12:53:40 mysqld_safe Logging to ...
https://dev.mysql.com/doc/refman/8.0/en/set-variable.html
SET can also be used to persist certain system variables to the mysqld-auto.cnf file in the data directory, to affect server operation for subsequent startups. To make a global system variable setting permanent so that it applies across server ...| ...variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | {PERSIST | @@PERSIST.} system_var_name | {PERSIST_ONLY | @@PERSIST_ONLY.} system_var_name | [SESSION | ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-mgm.html
--core-file Command-Line Format --core-file Removed 8.0.31 Write core file on error; used in debugging. To make this happen whenever ndb_mgm is run, put the option in the [ndb_mgm] section of the my.cnf file. Note If the management client command to ... The ndb_mgm management client process is actually not needed to run the ...Advanced users can also employ this API for programming ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-auto-positioning.html
GTIDs replace the file-offset pairs previously required to determine points for starting, stopping, or resuming the flow of data between source and replica. The alternative SOURCE_LOG_FILE | MASTER_LOG_FILE and SOURCE_LOG_POS | MASTER_LOG_POS ...To ...For full instructions to configure and start sources and replicas using GTID-based replication, see Section 19.1.3.4, “Setting Up Replication Using ...
https://dev.mysql.com/doc/refman/8.0/en/windows-start-service.html
The error log is located in the MySQL data directory (for example, C:\Program Files\MySQL\MySQL Server 8.0\data). Note On Windows, if the server is started with the --defaults-file and --install options, --install must be first. Install the server ... On Windows, the recommended way to run MySQL is to install it as a Windows service, so that MySQL starts and stops automatically when Windows starts and ...
https://dev.mysql.com/doc/refman/8.0/en/checking-gpg-signature-windows.html
The signature file must have the same name as the packaged file but with an appended .asc extension, as shown by the example in the following table. Figure 2.5 Kleopatra: the Decrypt and Verify Results Dialog: All operations completed Seeing a red ...The Fingerprint and Key-ID must be "3A79BD29" for MySQL 8.0.28 and higher or "5072E1F5" for MySQL 8.0.27 and earlier, or choose ...
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions-unexpected-replica-halt.html
From MySQL 8.0.27, when GTID-based replication is in use (gtid_mode=ON), set GTID_ONLY=1, which makes the replica use only GTIDs in the recovery process, and stop persisting binary log and relay log file names and file positions in the replication ... In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before ...