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/x-plugin-options-system-variables.html
When the variable names a list of multiple values, each value must specify a single non-wildcard IP address (either IPv4 or IPv6) or a host name. If given, it must be specified as a /ns suffix immediately following the address. The host system must ... To control activation of X Plugin, use this option: --mysqlx[=value] Command-Line Format --mysqlx[=value] Type Enumeration Default Value ON Valid Values ONOFFFORCEFORCE_PLUS_PERMANENT This option controls how the server loads X Plugin at ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-show-tables.html
If this option is given, the name of a table must follow the database name. ndb_show_tables displays a list of all NDB database objects in the cluster. --database, -d Specifies the name of the database in which the desired table is found. If this ...By default, this includes not only both user-created tables and NDB system tables, but NDB-specific indexes, internal triggers, and NDB Cluster Disk Data objects as ...
https://dev.mysql.com/doc/refman/8.0/en/slow-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 ...To make this easier, you can use the mysqldumpslow command to process a slow query log file and summarize its ... The slow query log consists of SQL statements that ...
https://dev.mysql.com/doc/refman/8.0/en/bug-reports.html
If you encounter an error with InnoDB tables, restart the server and see whether the problem persists, or whether the error affected only cached data in memory. If the problem occurs during compilation, include the exact error messages and also a ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication-system-variables.html
authentication_kerberos_service_key_tab Command-Line Format --authentication-kerberos-service-key-tab=file_name System Variable authentication_kerberos_service_key_tab Scope Global Dynamic No SET_VAR Hint Applies No Type File name Default Value ...
https://dev.mysql.com/doc/refman/8.0/en/can-not-connect-to-server.html
A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file in the file system (default /tmp/mysql.sock), or by using TCP/IP, which connects through a port number. A Unix ...
https://dev.mysql.com/doc/refman/8.0/en/backup-strategy-example.html
The InnoDB data files might not contain consistent data due to the crash, but InnoDB reads its logs and finds in them the list of pending committed and noncommitted transactions that have not been flushed to the data files. InnoDB: Apply batch ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-masterstatus.html
If you are planning to shut down the source to create a data snapshot, you can optionally skip this procedure and instead store a copy of the binary log index file along with the data snapshot. The source binary log coordinates where the replica ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-server.html
A typical my.cnf file might look like this: [mysqld] datadir=/usr/local/mysql/var socket=/var/tmp/mysql.sock port=3306 user=mysql [mysql.server] basedir=/usr/local/mysql The mysql.server script supports the options shown in the following table. If ...To run the server as some specific user, add an appropriate user option to the [mysqld] group of the global /etc/my.cnf option file, as shown later in this ...
https://dev.mysql.com/doc/refman/8.0/en/connecting-using-uri-or-key-value-pairs.html
socket: The path to a Unix socket file or the name of a Windows named pipe. In URI-like strings, they must be encoded, using either percent encoding or by surrounding the path with parentheses. If no database is specified, the connection has no ...