PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/drop-tablespace.html
ENGINE sets the storage engine that uses the tablespace, where engine_name is the name of the storage engine. For an InnoDB tablespace, all tables must be dropped from the tablespace prior to a DROP TABLESPACE operation. As with the InnoDB system ...
https://dev.mysql.com/doc/refman/5.7/en/functions.html
Rather than showing examples in this format: mysql> SELECT MOD(29,9); +-----------+ | mod(29,9) | +-----------+ | 2 | +-----------+ 1 rows in set (0.00 sec) This format is used instead: mysql> SELECT MOD(29,9); -> 2 . Expressions can be used at ...
https://dev.mysql.com/doc/refman/5.7/en/option-modifiers.html
The --maximum prefix is available for mysqld only and permits a limit to be placed on how large client programs can set session system variables. For example, with --maximum-back_log=200, the server produces this error: Maximum value of 'back_log' ...For example, the mysql client supports a --column-names option that determines whether or not to display a row of column names at the beginning of query ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-limitations-locking.html
For example, a SELECT from a partitioned MyISAM table locks only those partitions actually containing rows that satisfy the SELECT statement's WHERE condition are locked. For statements affecting partitioned tables using storage engines such as ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-stages-history-table.html
To set the number of rows per thread explicitly, set the performance_schema_events_stages_history_size system variable at server startup. When the table contains the maximum number of rows for a given thread, the oldest thread row is discarded when ... The events_stages_history table contains the N most recent stage events that have ended per ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-history-table.html
To set the number of rows per thread explicitly, set the performance_schema_events_statements_history_size system variable at server startup. When the table contains the maximum number of rows for a given thread, the oldest thread row is discarded ... The events_statements_history table contains the N most recent statement events that have ended per ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-history-table.html
To set the number of rows per thread explicitly, set the performance_schema_events_transactions_history_size system variable at server startup. When the table contains the maximum number of rows for a given thread, the oldest thread row is discarded ... The events_transactions_history table contains the N most recent transaction events that have ended per ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-history-table.html
To set the number of rows per thread explicitly, set the performance_schema_events_waits_history_size system variable at server startup. When the table contains the maximum number of rows for a given thread, the oldest thread row is discarded when a ... The events_waits_history table contains the N most recent wait events that have ended per ...
https://dev.mysql.com/doc/refman/5.7/en/function-loading.html
For this reason, CREATE FUNCTION requires the INSERT privilege for the mysql system database. For this reason, DROP FUNCTION requires the DELETE privilege for the mysql system database. Loadable functions, as the name implies, must be loaded into ...MySQL supports automatic function loading during server startup and manual loading ...
https://dev.mysql.com/doc/refman/5.7/en/sys-table-exists.html
Parameters in_db VARCHAR(64): The name of the database in which to check for table existance. Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, ...