PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks.html
A deadlock can occur when transactions lock rows in multiple tables (through statements such as UPDATE or SELECT ... FOR UPDATE) in each transaction; create indexes on the columns used in SELECT ... A deadlock is a situation in which multiple ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-disk-data.html
Disk data objects are subject to the following maximums and minimums: Maximum number of tablespaces: 232 (4294967296) Maximum number of data files per tablespace: 216 (65536) The minimum and maximum possible sizes of extents for tablespace data ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-mgm.html
All options that can be used with ndb_mgm are shown in the following table. The ndb_mgm management client process is actually not needed to run the cluster. Its value lies in providing a set of commands for checking the cluster's status, starting ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-security-networking-issues.html
Any traffic other than that shown in the table for a given node type should be denied. iptables is a very common and reliable firewall application, which is often used with APF as a front end to make configuration easier. In this section, we ...
https://dev.mysql.com/doc/refman/8.0/en/online-ddl-parallel-thread-configuration.html
Parallel scan is not supported on tables defined with virtual columns. Parallel scan is not supported on tables defined with a full-text index. Parallel scan is not supported on tables defined with a spatial index. The maximum setting is 256, which ...
https://dev.mysql.com/doc/refman/8.0/en/role-names.html
As stored in the grant tables, they have the same properties as account names, which are described in Grant Table Scope Column Properties. It is possible for a row in the mysql.user system table to serve as both an account and a role. Specifying a ... MySQL role names refer to roles, which are named collections of ...
https://dev.mysql.com/doc/refman/8.0/en/security-options.html
The following table shows mysqld options and system variables that affect security. For descriptions of each of these, see Section 7.1.7, “Server Command Options”, and Section 7.1.8, “Server System Variables”.
https://dev.mysql.com/doc/refman/8.0/en/sorted-index-builds.html
Sorted Index Builds and Compressed Tables For compressed tables, the previous index creation method appended entries to both compressed and uncompressed pages. InnoDB performs a bulk load instead of inserting one index record at a time when ...In ...
https://dev.mysql.com/doc/refman/8.0/en/backup-and-recovery.html
A group of MySQL servers can be configured to create a cluster using MySQL Shell. A minimum of three servers are required to create a high availability cluster. It is important to back up your databases so that you can recover your data and be up ...
https://dev.mysql.com/doc/refman/8.0/en/full-text-adding-collation.html
The instructions here add a collation for a simple character set, which as discussed in Section 12.14, “Adding a Collation to a Character Set”, can be created using a configuration file that describes the character set properties. For a complex ... Warning User-defined collations are deprecated; you should expect support for them to be removed in a future version of ...