PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 255.8Kb
Man Pages (Zip)
- 360.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/show-variables.html
System variable information is also available from these sources: Performance Schema tables. SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] Note The value of the show_compatibility_56 system variable affects the information ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-trx-info.html
The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and events_statements_history tables. The value should match the THREAD_ID column from some ... Returns a JSON object containing information about a given ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-auto-increment-columns.html
This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values and the usage ratio (ratio of used to possible values). Tables in these schemas are excluded ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-redundant-indexes.html
The schema_redundant_indexes view has these columns: table_schema The schema that contains the table. The x$schema_flattened_keys view has these columns: table_schema The schema that contains the table. The schema_redundant_indexes view displays ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-elements.html
MySQL Enterprise Thread Pool comprises these elements: A plugin library file implements a plugin for the thread pool code as well as several associated monitoring tables that provide information about thread pool operation. For a detailed ...
https://dev.mysql.com/doc/refman/5.7/en/update-optimization.html
Performing multiple updates together is much quicker than doing one at a time if you lock the table. For a MyISAM table that uses dynamic row format, updating a row to a longer total length may split the row. If you do this often, it is very ... An ...
https://dev.mysql.com/doc/refman/5.7/en/view-syntax.html
The CREATE VIEW statement creates a new view (see Section 13.1.21, “CREATE VIEW Statement”). To alter the definition of a view or drop a view, use ALTER VIEW (see Section 13.1.10, “ALTER VIEW Statement”), or DROP VIEW (see Section 13.1.32, ...
https://dev.mysql.com/doc/refman/5.7/en/workbench.html
Data Modeling: Enables you to create models of your database schema graphically, reverse and forward engineer between a schema and a live database, and edit all aspects of your database using the comprehensive Table Editor. The Table Editor provides ... MySQL Workbench provides a graphical tool for working with MySQL servers and ...
https://dev.mysql.com/doc/refman/5.7/en/alter-event.html
This example changes the SQL statement executed by myevent to one that deletes all records from mytable; it also changes the schedule for the event such that it executes once, one day after this ALTER EVENT statement is run. ALTER EVENT myevent ON ... ALTER [DEFINER = user] EVENT event_name [ON SCHEDULE schedule] [ON COMPLETION [NOT] PRESERVE] [RENAME TO new_event_name] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] [DO event_body] The ALTER EVENT statement changes one or more of the characteristics of an existing event without the need to drop and recreate ...
https://dev.mysql.com/doc/refman/5.7/en/alter-logfile-group.html
For example, you cannot have a tablespace and an undo log file with the same name, or an undo log file and a data file with the same name. You can verify that the UNDO files were created and obtain information about them by querying the Information ... ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement adds an UNDO file named 'file_name' to an existing log file group ...