PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
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-profiling-table.html
SEQ A sequence number indicating the display order for rows with the same QUERY_ID value. Its contents correspond to the information produced by the SHOW PROFILE and SHOW PROFILES statements (see Section 15.7.7.30, “SHOW PROFILE Statement”). The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-role-column-grants-table.html
Each row lists a single privilege, so there is one row per column privilege held by the grantee. The ROLE_COLUMN_GRANTS table (available as of MySQL 8.0.19) provides information about the column privileges for roles that are available to or granted ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-role-routine-grants-table.html
Each row lists a single privilege, so there is one row per column privilege held by the grantee. The ROLE_ROUTINE_GRANTS table (available as of MySQL 8.0.19) provides information about the routine privileges for roles that are available to or ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-role-table-grants-table.html
Each row lists a single privilege, so there is one row per column privilege held by the grantee. The ROLE_TABLE_GRANTS table (available as of MySQL 8.0.19) provides information about the table privileges for roles that are available to or granted ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-routines-table.html
The return value row for a stored function can be identified as the row that has an ORDINAL_POSITION value of 0. The ROUTINES table provides information about stored routines (stored procedures and stored functions). The ROUTINES table does not ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Introduced Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-tp-thread-group-state-table.html
For example, if an application uses this query: SELECT * FROM INFORMATION_SCHEMA.TP_THREAD_GROUP_STATE; The application should use this query instead: SELECT * FROM performance_schema.tp_thread_group_state; The TP_THREAD_GROUP_STATE table has one ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-temp-table-info.html
row *************************** TABLE_ID: 194 NAME: #sql7a79_1_0 N_COLS: 4 SPACE: 182 The TABLE_ID is a unique identifier for the temporary table. The number of columns (N_COLS) is 4 rather than 1 because InnoDB always creates three hidden table ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-introduction.html
Row-level locking and Oracle-style consistent reads increase multi-user concurrency and performance. InnoDB is a general-purpose storage engine that balances high reliability and high performance. Unless you have configured a different default ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-performance-thread_concurrency.html
Since an SQL statement (such as a join) may comprise multiple row operations within InnoDB, InnoDB assigns a specified number of “tickets” that allow a thread to be scheduled repeatedly with minimal overhead. Once the thread is entitled to enter ... InnoDB uses operating system threads to process requests from user ...