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/mysqld.html
Note Some installation packages contain a debugging version of the server named mysqld-debug. mysqld, also known as MySQL Server, is a single multithreaded program that does most of the work in a MySQL installation. MySQL Server manages access to ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-sql-format.html
This section describes how to use mysqldump to create SQL-format dump files. For information about reloading such dump files, see Section 9.4.2, “Reloading SQL-Format Backups”. By default, mysqldump writes information as SQL statements to the ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlimport.html
Note If the OpenSSL FIPS Object Module is not available, the only permitted value for --ssl-fips-mode is OFF. The mysqlimport client provides a command-line interface to the LOAD DATA SQL statement. Most options to mysqlimport correspond directly ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlshow.html
Note If the OpenSSL FIPS Object Module is not available, the only permitted value for --ssl-fips-mode is OFF. The mysqlshow client can be used to quickly see which databases exist, their tables, or a table's columns or indexes. The same information ...
https://dev.mysql.com/doc/refman/8.0/en/native-pluggable-authentication.html
Note The mysql_native_password authentication plugin is deprecated as of MySQL 8.0.34, disabled by default in MySQL 8.4, and removed as of MySQL 9.0.0. MySQL includes a mysql_native_password plugin that implements native authentication; that is, ...
https://dev.mysql.com/doc/refman/8.0/en/ndb-restore-different-number-nodes.html
Note When changing the total number of LCP threads or LQH threads per node group, you should recreate the schema from backup created using mysqldump. It is possible to restore from an NDB backup to a cluster having a different number of data nodes ...
https://dev.mysql.com/doc/refman/8.0/en/no-login-pluggable-authentication.html
Note Because the nologin account cannot be used directly, the operations required to set up objects that it uses must be performed by root or similar account that has the privileges required to create the objects and set DEFINER values. The ...
https://dev.mysql.com/doc/refman/8.0/en/not-enough-file-handles.html
Note If you run the tcsh shell, ulimit does not work! tcsh also reports incorrect values when you ask for the current limits. If you get ERROR 'file_name' not found (errno: 23), Can't open file: file_name (errno: 24), or any other error with errno ...
https://dev.mysql.com/doc/refman/8.0/en/numeric-type-attributes.html
Note The ZEROFILL attribute is ignored for columns involved in expressions or UNION queries. MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the type. For ...
https://dev.mysql.com/doc/refman/8.0/en/optimize-overview.html
Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. These software constructs result in CPU and I/O operations at the hardware level, which you must minimize and make as ...