MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 451 to 460 of 470 total results

15.2.3.1 Static (Fixed-Length) Table Characteristics

https://dev.mysql.com/doc/refman/5.7/en/static-format.html

It is used when the table contains no variable-length columns (VARCHAR, VARBINARY, BLOB, or TEXT). Of the three MyISAM storage formats, static format is the simplest and most secure (least subject to corruption). It is also the fastest of the ...

Chapter 15 Alternative Storage Engines

https://dev.mysql.com/doc/refman/5.7/en/storage-engines.html

For information about features offered in commercial MySQL Server binaries, see MySQL Editions, on the MySQL website. Storage engines are MySQL components that handle the SQL operations for different table types. InnoDB is the default and most ...

11.3 String Data Types

https://dev.mysql.com/doc/refman/5.7/en/string-types.html

The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For information about storage requirements of the string data types, see Section 11.7, “Data Type Storage Requirements”. For descriptions of functions that ...

26.4.4.2 The diagnostics() Procedure

https://dev.mysql.com/doc/refman/5.7/en/sys-diagnostics.html

Creates a report of the current server status for diagnostic purposes. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. That is a restricted operation, so the ...

26.4.4.12 The ps_setup_reload_saved() Procedure

https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-reload-saved.html

Reloads a Performance Schema configuration saved earlier within the same session using ps_setup_save(). This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. That is a ...

26.4.4.14 The ps_setup_save() Procedure

https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-save.html

This enables you to alter the configuration temporarily for debugging or other purposes, then restore it to the previous state by invoking the ps_setup_reload_saved() procedure. To prevent other simultaneous calls to save the configuration, ...

26.4.4.22 The ps_trace_statement_digest() Procedure

https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-statement-digest.html

Traces all Performance Schema instrumentation for a specific statement digest. If you find a statement of interest within the Performance Schema events_statements_summary_by_digest table, specify its DIGEST column MD5 value to this procedure and ...

26.4.4.23 The ps_trace_thread() Procedure

https://dev.mysql.com/doc/refman/5.7/en/sys-ps-trace-thread.html

Dumps all Performance Schema data for an instrumented thread to a .dot formatted graph file (for the DOT graph description language). Each result set returned from the procedure should be used for a complete graph. This procedure disables binary ...

26.4.4.25 The statement_performance_analyzer() Procedure

https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html

Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system ...

5.3 The mysql System Database

https://dev.mysql.com/doc/refman/5.7/en/system-schema.html

It contains tables that store information required by the MySQL server as it runs. Warning Do not convert MySQL system tables in the mysql database from MyISAM to InnoDB tables. If you do this, MySQL does not restart until you restore the old system ...

Displaying 451 to 460 of 470 total results