PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/multiple-servers.html
If you use the following log file options, their values must differ for each server: --general_log_file=file_name --log-bin[=file_name] --slow_query_log_file=file_name --log-error[=file_name] For further discussion of log file options, see Section ...In addition to using different data directories, several other options must have different values for each server instance: --port=port_num --port controls the port number for TCP/IP ...
https://dev.mysql.com/doc/refman/8.0/en/installing-source-distribution.html
Perform Postinstallation Setup The remainder of the installation process involves setting up the configuration file, creating the core databases, and starting the MySQL server. Obtain a distribution file using the instructions in Section 2.1.3, ...
https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-usage.html
They are good for encrypting small amounts of data and creating and verifying signatures. This example works with both the component function and the legacy function: SET @priv1 = create_asymmetric_priv_key('RSA', 2048); SELECT ... To use MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-configuring-instances.html
Storage Engines Replication Framework Group Replication Settings Storage Engines For Group Replication, data must be stored in the InnoDB transactional storage engine (for details of why, see Section 20.3.1, “Group Replication Requirements”). If ...The use of other storage engines, including the temporary MEMORY storage engine, might cause errors in Group ... This section ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-crash-recovery.html
When performing crash recovery, it is important to understand that each MyISAM table tbl_name in a database corresponds to the three files in the database directory shown in the following table. File Purpose tbl_name.MYD Data file tbl_name.MYI Index ...If you cannot guarantee this, you must stop mysqld while you check the ... This ...For an explanation of ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-operations.html
For ALGORITHM=COPY, the mysqld NDB Cluster handler performs the following actions: Tells the data nodes to create an empty copy of the table, and to make the required schema changes to this copy. Tells the data nodes to drop the original table and ...NDB Cluster handles COPY and INPLACE as described in the next few ... MySQL NDB ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-waiter.html
ndb_waiter repeatedly (each 100 milliseconds) prints out the status of all cluster data nodes until either the cluster reaches a given status or the --timeout limit is exceeded, then exits. SINGLE USER MODE: This is shown for all cluster data nodes ...By default, it waits for the cluster to achieve STARTED status, in which all nodes have started and connected to the ...--connect-retries Command-Line Format ...
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/replication-options-gtids.html
binlog_gtid_simple_recovery Command-Line Format --binlog-gtid-simple-recovery[={OFF|ON}] System Variable binlog_gtid_simple_recovery Scope Global Dynamic No SET_VAR Hint Applies No Type Boolean Default Value ON This variable controls how binary log ... The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-quick-start.html
For example, use these lines in the server my.cnf file: [mysqld] performance_schema=ON When the server starts, it sees performance_schema and attempts to initialize the Performance Schema. Check the server error log for information about what went ... This section briefly introduces the Performance Schema with examples that show how to use ...row *************************** ENGINE: PERFORMANCE_SCHEMA SUPPORT: ...