MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 771 to 780 of 786 total results

26.4.3.39 The statements_with_sorting and x$statements_with_sorting Views

https://dev.mysql.com/doc/refman/5.7/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 ...

26.4.3.40 The statements_with_temp_tables and x$statements_with_temp_tables Views

https://dev.mysql.com/doc/refman/5.7/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 ...

8.11.2 Table Locking Issues

https://dev.mysql.com/doc/refman/5.7/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 ...

8.4.6 Limits on Table Size

https://dev.mysql.com/doc/refman/5.7/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 ...

23.3.2 Trigger Metadata

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

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

23.3 Using Triggers

https://dev.mysql.com/doc/refman/5.7/en/triggers.html

A trigger is a named database object that is associated with a table, and that activates when a particular event occurs for the table. Some uses for triggers are to perform checks of values to be inserted into a table or to perform calculations on ...

9.4 User-Defined Variables

https://dev.mysql.com/doc/refman/5.7/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 ...

5.8.1.6 Using Server Logs to Find Causes of Errors in mysqld

https://dev.mysql.com/doc/refman/5.7/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 ...

23.5.5 View Metadata

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

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

2.3.4.2 Creating an Option File

https://dev.mysql.com/doc/refman/5.7/en/windows-create-option-file.html

To initialize a MySQL installation by creating the data directory and populating the tables in the mysql system database, initialize MySQL using either --initialize or --initialize-insecure. If you need to specify startup options when you run the ...

Displaying 771 to 780 of 786 total results