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-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and metadata about the pages within the InnoDB buffer pool. Do not query these tables on a production system unless you are aware of the performance impact and ...The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB_BUFFER%'; +-----------------------------------------------+ | Tables_in_INFORMATION_SCHEMA (INNODB_BUFFER%) | +-----------------------------------------------+ | INNODB_BUFFER_PAGE_LRU | | INNODB_BUFFER_PAGE | | INNODB_BUFFER_POOL_STATS | +-----------------------------------------------+ Table Overview INNODB_BUFFER_PAGE: Holds information about each page in the InnoDB buffer ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-general-info.html
Support for the NDB storage engine is not included in standard MySQL Server 8.0 binaries built by Oracle. NDB Cluster 8.0 users who build from source should use the sources provided for MySQL 8.0 and build with the options required to provide NDB ...
https://dev.mysql.com/doc/refman/8.0/en/replication-howto-additionalslaves.html
To do this, you can set up the new replica by copying the data directory of an existing replica, and giving the new replica a different server ID (which is user-specified) and server UUID (which is generated at startup). As an alternative to ... You ...
https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html
If you know the root password and want to change it, see Section 15.7.1.1, “ALTER USER Statement”, and Section 15.7.1.10, “SET PASSWORD Statement”. The following sections provide instructions for Windows and Unix and Unix-like systems, as ...
https://dev.mysql.com/doc/refman/8.0/en/secure-client-programming.html
Handle External Data Properly Handle MySQL Error Messages Properly Handle External Data Properly Applications that access MySQL should not trust any data entered by users, who can try to trick your code by entering special or escaped character ...
https://dev.mysql.com/doc/refman/8.0/en/transport-protocols.html
For programs that use the MySQL client library (for example, mysql and mysqldump), MySQL supports connections to the server based on several transport protocols: TCP/IP, Unix socket file, named pipe, and shared memory. This section describes how to ...Otherwise, a connection to localhost results in a TCP/IP connection to ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-object-filtering.html
The ENABLED column indicates whether matching objects are monitored, and TIMED indicates whether to collect timing information. The order in which matching occurs matters because different matching setup_objects rows can have different ENABLED and ... The setup_objects table controls whether the Performance Schema monitors particular table and stored program ...
https://dev.mysql.com/doc/refman/8.0/en/data-type-defaults.html
See Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”. The exception is that, for TIMESTAMP and DATETIME columns, you can specify CURRENT_TIMESTAMP as the default. See Section 13.2.5, “Automatic Initialization ...Some aspects of explicit DEFAULT clause handling are version dependent, as described ...
https://dev.mysql.com/doc/refman/8.0/en/can-not-connect-to-server.html
If you get the error message Can't connect to MySQL server on some_host, you can try the following things to find out what the problem is: Check whether the server is running on that host by executing telnet some_host 3306 and pressing the Enter key ...You should check that there is a MySQL server running, that it has network connections enabled, and that the network port you specified is the one configured on the ... A MySQL client on Unix can connect to the mysqld server in two ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-reference.html
If the timeout is 0, there is no waiting and the function produces an error if locks cannot be acquired immediately. One set of functions permits the server's list of version tokens to be manipulated and inspected. Another set of functions permits ... The following discussion serves as a reference to these Version Tokens elements: Version Tokens Functions Version Tokens System Variables Version Tokens Functions The Version Tokens plugin library includes several ...