PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-summary-tables.html
Each summary table has grouping columns that determine how to group the data to be aggregated, and summary columns that contain the aggregated values. Tables that summarize events in similar ways often have similar sets of summary columns and differ ... Summary tables provide aggregated information for terminated events over ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-system-variable-tables.html
The global_variables and session_variables tables have these columns: VARIABLE_NAME The system variable name. For session_variables, this column contains the variable value in effect for the current session. The variables_by_thread table has these ... Note The value of the show_compatibility_56 system variable affects the information available from the tables described ...
https://dev.mysql.com/doc/refman/5.7/en/show-processlist.html
row *************************** Id: 3123 User: stefan Host: localhost db: apollon Command: Query Time: 0 State: NULL Info: SHOW FULL PROCESSLIST SHOW PROCESSLIST output has these columns: Id The connection identifier. This is the same value ... SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html
SELECT statements when the source column expressions refer to local variables. Converting these references to NAME_CONST() expressions can result in column names that are different on the source and replica servers, or names that are too long to be ... The binary log contains information about SQL statements that modify database ...
https://dev.mysql.com/doc/refman/5.7/en/account-locking.html
Account locking state is recorded in the account_locked column of the mysql.user system table. The account-locking capability depends on the presence of the account_locked column in the mysql.user system table. For upgrades from MySQL versions older ... MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new ...
https://dev.mysql.com/doc/refman/5.7/en/account-names.html
MySQL stores account names in grant tables in the mysql system database using separate columns for the user name and host name parts: The user table contains one row for each account. The User and Host columns store the user name and host name.
https://dev.mysql.com/doc/refman/5.7/en/analyze-table.html
ANALYZE TABLE Output Key Distribution Analysis Other Considerations ANALYZE TABLE Output ANALYZE TABLE returns a result set with the columns shown in the following table. Column Value Table The table name Op Always analyze Msg_type status, error, ...
https://dev.mysql.com/doc/refman/5.7/en/charset-metadata.html
Thus column names, database names, user names, version names, and most of the string results from SHOW are metadata. Otherwise, neither the SHOW statements nor SELECT statements for tables in INFORMATION_SCHEMA would work properly because different ... Metadata is “the data about the data.” Anything that describes the database—as opposed to being the contents of the database—is ...
https://dev.mysql.com/doc/refman/5.7/en/condition-filtering.html
In EXPLAIN output, the rows column indicates the row estimate for the chosen access method, and the filtered column reflects the effect of condition filtering. In such cases, these techniques may help: If a column is not indexed, index it so that ...
https://dev.mysql.com/doc/refman/5.7/en/counting-rows.html
Counting the total number of animals you have is the same question as “How many rows are in the pet table?” because there is one record per pet. COUNT(*) counts the number of rows, so the query to count your animals looks like this: mysql> ...