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/charset-unicode-utf32.html
utf32 takes twice as much space as ucs2 and more space than utf16, but utf32 has the same advantage as ucs2 that it is predictable for storage: The required number of bytes for utf32 equals the number of characters times 4. The utf32 character set ...Also, unlike utf16, there are no tricks for encoding in utf32, so the stored value equals the code ...
https://dev.mysql.com/doc/refman/8.0/en/charset-unicode-utf8.html
utf8mb3 remains supported for the lifetimes of the MySQL 8.0.x and following LTS release series, as well as in MySQL 8.0. Since changing character sets can be a complex and time-consuming task, you should begin to prepare for this change now by ...
https://dev.mysql.com/doc/refman/8.0/en/expired-password-handling.html
Pass the CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS flag to mysql_real_connect() at connect time: MYSQL mysql; mysql_init(&mysql); if (!mysql_real_connect(&mysql, host, user, password, db, port, unix_socket, CLIENT_CAN_HANDLE_EXPIRED_PASSWORDS)) { ...
https://dev.mysql.com/doc/refman/8.0/en/full-disk.html
This section describes how MySQL responds to disk-full errors (such as “no space left on device”), and to quota-exceeded errors (such as “write failed” or “user block limit reached”). The thread is aborted the next time it checks the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-primary-secondary-replication.html
The source is the primary, and there are one or more replicas, which are secondaries. The source applies transactions, commits them and then they are later (thus asynchronously) sent to the replicas to be either re-executed (in statement-based ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-index-table-table.html
The same word can occur several times within the cache table, once for each combination of DOC_ID and POSITION values. For related usage information and examples, see Section 17.15.4, “InnoDB INFORMATION_SCHEMA FULLTEXT Index Tables”. Use the ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-server-clients.html
If you normally use a specific socket file or port number, you can place commands to set these environment variables in your .login file so that they apply each time you log in. For TCP/IP connections, you may also need to specify --host and --port ...Start the client with --protocol=TCP to connect using TCP/IP, --protocol=SOCKET to connect using a Unix socket file, --protocol=PIPE to connect using a named pipe, or --protocol=MEMORY to connect using shared ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-online-add-node-basics.html
In the event that you have API nodes using dynamically allocated node IDs and these IDs match node IDs that you want to use for new data nodes, it is possible to force any such API nodes to “migrate”, as described later in this procedure. This ... In this section, we list the basic steps required to add new data nodes to an NDB ...
https://dev.mysql.com/doc/refman/8.0/en/optimization.html
Sometimes you can be proactive and plan in advance for performance, while other times you might troubleshoot a configuration or code issue after a problem occurs. This chapter explains how to optimize MySQL performance and provides examples.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-applier-status-table.html
Thread-specific status information is available in the replication_applier_status_by_coordinator table (and replication_applier_status_by_worker if the replica is multithreaded). There is always a default replication channel, and more replication ...