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/innodb-memcached-benefits.html
Running memcached in the same process space as the MySQL server avoids the network overhead of passing requests back and forth. Data written using the memcached protocol is transparently written to an InnoDB table, without going through the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/native-pluggable-authentication.html
MySQL includes a mysql_native_password plugin that implements native authentication; that is, authentication based on the password hashing method in use from before the introduction of pluggable authentication. Note The mysql_native_password ...The ...
https://dev.mysql.com/doc/refman/8.0/en/ndb-restore-to-different-version.html
It is also advisable to review What is New in NDB Cluster 8.0, as well as Section 3.5, “Changes in MySQL 8.0”, for other changes between NDB 8.0 and previous versions of NDB Cluster that may be relevant to your particular circumstances. Due to ... The following two sections provide information about restoring a native NDB backup to a different version of NDB Cluster from the version in which the backup was ...
https://dev.mysql.com/doc/refman/8.0/en/packet-too-large.html
A communication packet is a single SQL statement sent to the MySQL server, a single row that is sent to the client, or a binary log event sent from a replication source server to a replica. The largest possible packet that can be transmitted to or ...Both the client and the server have their own max_allowed_packet variable, so if you want to handle big packets, you must increase this variable both in the client and in the ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-storage-engines.html
In MySQL 8.0, partitioning support is not actually provided by the MySQL Server, but rather by a table storage engine's own or native partitioning handler. In MySQL 8.0, only the InnoDB and NDB storage engines provide native partitioning handlers.
https://dev.mysql.com/doc/refman/8.0/en/password-logging.html
If such statements are logged by the MySQL server as written, passwords in them become visible to anyone with access to the logs. In particular, INSERT or UPDATE statements for the mysql.user system table that refer to literal passwords are logged ... Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT and SET ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-consumer-configurations.html
No Instrumentation Global Instrumentation Only Global and Thread Instrumentation Only Global, Thread, and Current-Event Instrumentation Global, Thread, Current-Event, and Event-History instrumentation No Instrumentation Server configuration state: ... The consumer settings in the setup_consumers table form a hierarchy from higher levels to ...
https://dev.mysql.com/doc/refman/8.0/en/perl-support-problems.html
If Perl reports that it cannot find the ../mysql/mysql.so module, the problem is probably that Perl cannot locate the libmysqlclient.so shared library. You should be able to fix this problem by one of the following methods: Copy libmysqlclient.so ...Note that you may also need to modify the -L options if there are other libraries that the linker fails to ...
https://dev.mysql.com/doc/refman/8.0/en/reloading-delimited-text-dumps.html
For backups produced with mysqldump --tab, each table is represented in the output directory by an .sql file containing the CREATE TABLE statement for the table, and a .txt file containing the table data. To reload a table, first change location ...
https://dev.mysql.com/doc/refman/8.0/en/rename-table.html
As of MySQL 8.0.13, you can rename tables locked with a LOCK TABLES statement, provided that they are locked with a WRITE lock or are the product of renaming WRITE-locked tables from earlier steps in a multiple-table rename operation. For example, ... RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ...