PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-waits-history-long-table.html
For more information about the relationship between the three wait event tables, see Section 29.9, “Performance Schema Tables for Current and Historical Events”. The events_waits_history_long table contains N the most recent wait events that ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-filtering-names.html
Names given for filtering operations can be as specific or general as required. For example, to select all file I/O instruments, it is better to use a pattern that includes the entire instrument name prefix: ... WHERE NAME LIKE 'wait/io/file/%'; A ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-hosts-table.html
For each host name, the table counts the current and total number of connections. The hosts table contains a row for each host from which clients have connected to the MySQL server. To set the table size explicitly, set the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-innodb-redo-log-files-table.html
FILE_NAME The path and file name of the redo log file. The innodb_redo_log_files table contains a row for each active InnoDB redo log file. The innodb_redo_log_files table has the following columns: FILE_ID The ID of the redo log file. START_LSN ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-objects-summary-global-by-type-table.html
row *************************** OBJECT_TYPE: TABLE OBJECT_SCHEMA: test OBJECT_NAME: t COUNT_STAR: 3 SUM_TIMER_WAIT: 263126976 MIN_TIMER_WAIT: 1522272 AVG_TIMER_WAIT: 87708678 MAX_TIMER_WAIT: 258428280 ... row *************************** OBJECT_TYPE: ... The Performance Schema maintains the objects_summary_global_by_type table for aggregating object wait ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-user-variable-tables.html
These are variables defined within a specific session and include a @ character preceding the name; see Section 11.4, “User-Defined Variables”. The Performance Schema provides a user_variables_by_thread table that exposes user-defined variables. The user_variables_by_thread table has these columns: THREAD_ID The thread identifier of the session in which the variable is ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-users-table.html
For each user name, the table counts the current and total number of connections. The users table contains a row for each user who has connected to the MySQL server. To set the table size explicitly, set the performance_schema_users_size system ...
https://dev.mysql.com/doc/refman/8.0/en/perl-support.html
The DBI/DBD interface requires Perl 5.6.0, and 5.6.1 or later is preferred. The Perl DBI module provides a generic interface for database access. You can write a DBI script that works with many different database engines without change. To use DBI, ...
https://dev.mysql.com/doc/refman/8.0/en/permission-optimization.html
For example, if you do not grant any table-level or column-level privileges, the server need not ever check the contents of the tables_priv and columns_priv tables. The more complex your privilege setup, the more overhead applies to all SQL ...
https://dev.mysql.com/doc/refman/8.0/en/plugin-services.html
The following sections describe plugin services available at the SQL and C-language levels. MySQL server plugins have access to server “plugin services.” The plugin services interface complements the plugin API by exposing server functionality ...