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-events-statements-current-table.html
The events_statements_current table has these columns: THREAD_ID, EVENT_ID The thread associated with the event and the thread current event number when the event starts. END_EVENT_ID This column is set to NULL when the event starts and updated to ...The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-timing.html
The columns have these meanings: The TIMER_NAME column shows the names of the available timers. The timers in setup_timers that you can use are those that do not have NULL in the other columns. Performance Schema Timer Representation in Events Rows ... Events are collected by means of instrumentation added to the server source ...
https://dev.mysql.com/doc/refman/5.7/en/sorting-rows.html
This means that the order is undefined for columns that are identical except for their case. You can force a case-sensitive sort for a column by using BINARY like so: ORDER BY BINARY col_name. You may have noticed in the preceding examples that the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-metrics.html
The metric type determines the source from which the name is taken: For global status variables: The VARIABLE_NAME column of the global_status table For InnoDB metrics: The NAME column of the INNODB_METRICS table For other metrics: A view-provided ... This view summarizes MySQL server metrics to show variable names, values, types, and whether they are ...
https://dev.mysql.com/doc/refman/5.7/en/view-restrictions.html
SHOW CREATE VIEW displays view definitions using an AS alias_name clause for each column. If a column is created from an expression, the default alias is the expression text, which can be quite long. Aliases for column names in CREATE VIEW ... The ...
https://dev.mysql.com/doc/refman/5.7/en/archive-storage-engine.html
It does support ORDER BY operations, BLOB columns, and basically all data types including spatial data types (see Section 11.4.1, “Spatial Data Types”). The AUTO_INCREMENT column can have either a unique or nonunique index. Attempting to create ... The ARCHIVE storage engine produces special-purpose tables that store large amounts of unindexed data in a very small ...
https://dev.mysql.com/doc/refman/5.7/en/charset-collation-information-schema.html
String columns in INFORMATION_SCHEMA tables have a collation of utf8_general_ci, which is case-insensitive. However, for values that correspond to objects that are represented in the file system, such as databases and tables, searches in ...For ...
https://dev.mysql.com/doc/refman/5.7/en/extended-show.html
To use a WHERE clause with SHOW CHARACTER SET, you would refer to those column names. Some extensions to SHOW statements accompany the implementation of INFORMATION_SCHEMA: SHOW can be used to get information about the structure of ...
https://dev.mysql.com/doc/refman/5.7/en/foreign-key-optimization.html
If a table has many columns, and you query many different combinations of columns, it might be efficient to split the less-frequently used data into separate tables with a few columns each, and relate them back to the main table by duplicating the ...
https://dev.mysql.com/doc/refman/5.7/en/handler.html
If you have a multiple-column index, specify the index column values as a comma-separated list. Either specify values for all the columns in the index, or specify values for a leftmost prefix of the index columns. Suppose that an index my_idx ...