MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 881 to 890 of 898 total results

30.4.3.38 The statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile Views

https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-runtimes-in-95th-percentile.html

db The default database for the statement, or NULL if there is none. These views list statements with runtimes in the 95th percentile. The statements_with_runtimes_in_95th_percentile and x$statements_with_runtimes_in_95th_percentile views have ...

30.4.3.39 The statements_with_sorting and x$statements_with_sorting Views

https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-sorting.html

db The default database for the statement, or NULL if there is none. The statements_with_sorting and x$statements_with_sorting views have these columns: query The normalized statement string. total_latency The total wait time of timed occurrences of ...

30.4.3.40 The statements_with_temp_tables and x$statements_with_temp_tables Views

https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-temp-tables.html

db The default database for the statement, or NULL if there is none. These views list normalized statements that have used temporary tables. By default, rows are sorted by descending number of on-disk temporary tables used and descending number of ...

10.11.2 Table Locking Issues

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

The automatic row-level locking makes these tables suitable for your busiest databases with your most important data, while also simplifying application logic since you do not need to lock and unlock tables. InnoDB tables use row-level locking so ...

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 ...

27.3.2 Trigger Metadata

https://dev.mysql.com/doc/refman/8.0/en/trigger-metadata.html

To obtain metadata about triggers: Query the TRIGGERS table of the INFORMATION_SCHEMA database.

3.8 Upgrading MySQL with the MySQL Yum Repository

https://dev.mysql.com/doc/refman/8.0/en/updating-yum-repo.html

Among other instructions discussed there, it is especially important to back up your database before the update. For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”, for a list), you ...

11.4 User-Defined Variables

https://dev.mysql.com/doc/refman/8.0/en/user-variables.html

They cannot be used directly in an SQL statement as an identifier or as part of an identifier, such as in contexts where a table or database name is expected, or as a reserved word such as SELECT. You can store a value in a user-defined variable in ...

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 ...

27.5.5 View Metadata

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

To obtain metadata about views: Query the VIEWS table of the INFORMATION_SCHEMA database.

Displaying 881 to 890 of 898 total results