PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-tablespaces-brief-table.html
The INNODB_TABLESPACES_BRIEF table provides space ID, name, path, flag, and space type metadata for file-per-table, general, undo, and system tablespaces. INNODB_TABLESPACES provides the same metadata but loads more slowly because other metadata ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-parameters-table.html
The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and about return values for stored functions. ORDINAL_POSITION For successive parameters of a stored procedure or function, the ...The PARAMETERS table does not include built-in (native) functions or loadable ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-background.html
You might need to size your buffer pool to accommodate the additional data of both compressed and uncompressed pages, although the uncompressed pages are evicted from the buffer pool when space is needed, and then uncompressed again on the next ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-create-table-external.html
As of MySQL 8.0.21, tables and table partitions created outside of the data directory using the DATA DIRECTORY clause are restricted to directories known to InnoDB. This requirement permits database administrators to control where tablespace data ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-indexes.html
For example, an index continues to be updated per changes to table rows, and a unique index prevents insertion of duplicates into a column, regardless of whether the index is visible or invisible. Dropping and re-adding an index can be expensive for ... MySQL supports invisible indexes; that is, indexes that are not used by the ...
https://dev.mysql.com/doc/refman/8.0/en/making-windows-dumps.html
This is a separate download from the standard MSI or Zip file. The PDB file contains more detailed information about mysqld and other tools that enables more detailed trace and dump files to be created. For more information on PDB files and the ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-servers.html
For example, you might run a server from MySQL 5.7 and one from MySQL 8.0, to see how different versions handle a given workload. Parameters can be set on the command line, in option files, or by setting environment variables. To see the values used ... In some cases, you might want to run multiple instances of MySQL on a single ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-connection-strings.html
A bind address consists of a hostname or network address and an optional port number. Consider the following connection string: poseidon:1186;bind-address=localhost, perch:1186;bind-address=198.51.100.242 In this case, the node uses localhost to ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-cluster-locks.html
The cluster_locks table provides information about current lock requests holding and waiting for locks on NDB tables in an NDB Cluster, and is intended as a companion table to cluster_operations. Information obtain from the cluster_locks table may ...The transaction ID (transid column) is the identifier generated by the NDB API for the transaction requesting or holding the current ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs.html
Using and managing an NDB Cluster requires several specialized programs, which we describe in this chapter. We discuss the purposes of these programs in an NDB Cluster, how to use the programs, and what startup options are available for each of ...