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/string-collating.html
If the sorting rules for your language are too complex to be handled with simple arrays, you must define string collating functions in the ctype-MYSET.c source file in the strings directory. For a simple character set named MYSET, sorting rules are ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html
Before upgrading to the latest MySQL 8.0 release, ensure the upgrade readiness of your current MySQL 5.7 or MySQL 8.0 server instance by performing the preliminary checks described below. Tip Consider using the MySQL Shell upgrade checker utility ...
https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html
This can cause problems in the following circumstances for views with too-long aliases: View definitions fail to replicate to newer replicas that enforce the column-length restriction. The maximum number of tables that can be referenced in the ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-start.html
If the file size would be larger than this value, the index is created using the key cache instead, which is slower. bulk_insert_buffer_size The size of the tree cache used in bulk insert optimization. myisam_max_sort_file_size The maximum size of ... The following options to mysqld can be used to change the behavior of MyISAM ...
https://dev.mysql.com/doc/refman/8.0/en/alter-logfile-group.html
ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement adds an UNDO file named 'file_name' to an existing log file group logfile_group. The optional INITIAL_SIZE parameter ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-blobs.html
Parts of JSON values exceeding 4000 bytes in size are also stored in this table. The part and (NDB 8.0.30 and later) inline sizes of NDB blob columns can be set using CREATE TABLE and ALTER TABLE statements containing NDB table column comments (see ...For more information about how NDB Cluster stores columns of such types, see String Type Storage ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-preparation.html
Ensure that each MySQL server acting as a replication source is assigned a unique server ID, and has binary logging enabled, using the row-based format. If you are using a release of NDB Cluster prior to NDB 8.0.30, you should also consider ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-key-caches.html
For example: mysql> SET GLOBAL keycache1.key_buffer_size=128*1024; To destroy a key cache, set its size to zero: mysql> SET GLOBAL keycache1.key_buffer_size=0; You cannot destroy the default key cache. Any attempt to do this is ignored: mysql> SET ... Note As of MySQL 8.0, the compound-part structured-variable syntax discussed here for referring to multiple MyISAM key caches is ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-log-statistics.html
For inserts and updates, this is proportional to the number of columns written, and the size of their data. This statistic increases in size as the utilization of the TCP/IP buffer improves. The NDB management client's CLUSTERLOG STATISTICS command ...
https://dev.mysql.com/doc/refman/8.0/en/online-ddl-memory-management.html
The innodb_ddl_buffer_size variable, introduced in MySQL 8.0.27, defines the maximum buffer size for online DDL operations. Defining an appropriate buffer size limit avoids potential out of memory errors for online DDL operations that create or ...