MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 341 to 350 of 352 total results

https://dev.mysql.com/doc/refman/8.0/en/string-types.html

The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For information about storage requirements of the string data types, see Section 13.7, “Data Type Storage Requirements”. For descriptions of functions that ...

10.2.2.2 Optimizing Subqueries with Materialization

https://dev.mysql.com/doc/refman/8.0/en/subquery-materialization.html

The optimizer uses materialization to enable more efficient subquery processing. Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it ...

30.4.5.14 The ps_thread_account() Function

https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-account.html

Given a Performance Schema thread ID, returns the user_name@host_name account associated with the thread. Parameters in_thread_id BIGINT UNSIGNED: The thread ID for which to return the account. The value should match the THREAD_ID column from some ...

10.4.6 Limits on Table Size

https://dev.mysql.com/doc/refman/8.0/en/table-size-limit.html

The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. For up-to-date information operating system file size limits, refer to the documentation ...

15.7.4.6 UNINSTALL PLUGIN Statement

https://dev.mysql.com/doc/refman/8.0/en/uninstall-plugin.html

UNINSTALL PLUGIN plugin_name This statement removes an installed server plugin. It requires the DELETE privilege for the mysql.plugin system table because it removes the row from that table that registers the plugin. plugin_name must be the name of ...

7.9.1.6 Using Server Logs to Find Causes of Errors in mysqld

https://dev.mysql.com/doc/refman/8.0/en/using-log-files.html

Note that before starting mysqld with the general query log enabled, you should check all your tables with myisamchk. If mysqld dies or hangs, you should start mysqld with the general query log enabled. When mysqld dies again, you can examine the ...

9.4 Using mysqldump for Backups

https://dev.mysql.com/doc/refman/8.0/en/using-mysqldump.html

Tip Consider using the MySQL Shell dump utilities, which provide parallel dumping with multiple threads, file compression, and progress information display, as well as cloud features such as Oracle Cloud Infrastructure Object Storage streaming, and ...

2.1.4.1 Verifying the MD5 Checksum

https://dev.mysql.com/doc/refman/8.0/en/verifying-md5-checksum.html

After you have downloaded a MySQL package, you should make sure that its MD5 checksum matches the one provided on the MySQL download pages. Each package has an individual checksum that you can verify against the package that you downloaded. The ...

27.5.2 View Processing Algorithms

https://dev.mysql.com/doc/refman/8.0/en/view-algorithms.html

The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. For MERGE, the text of a statement that refers to the view and the view definition are merged such that parts of the view definition replace ...

27.9 Restrictions on Views

https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html

The maximum number of tables that can be referenced in the definition of a view is 61. View processing is not optimized: It is not possible to create an index on a view. Indexes can be used for views processed using the merge algorithm. However, a ...

Displaying 341 to 350 of 352 total results