PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-objects-table.html
(Tables in the INFORMATION_SCHEMA database are not instrumented regardless of the contents of setup_objects; the row for information_schema.% simply makes this default explicit.) When the Performance Schema checks for a match in setup_objects, it ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-metadata-locks-table.html
Metadata locking applies not just to tables, but also to schemas, stored programs (procedures, functions, triggers, scheduled events), tablespaces, user locks acquired with the GET_LOCK() function (see Section 12.14, “Locking Functions”), and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-internal-data.html
Because InnoDB must temporarily stall while the transaction and locking data is collected, too frequent queries of these tables can negatively impact performance as seen by other users. As these tables contain sensitive information (at least ...This ...For performance reasons, and to minimize the chance of misleading joins between the transaction and locking tables, InnoDB collects the required transaction and locking information into an intermediate buffer whenever a SELECT on any of the tables is ...
https://dev.mysql.com/doc/refman/5.7/en/federated-create-connection.html
For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) NOT NULL DEFAULT '0', PRIMARY KEY (id), INDEX name (name), INDEX other_key (other) ) ENGINE=FEDERATED DEFAULT ...This ...The connection string specifies the server name, login credentials, port number and database/table ...The CONNECTION string contains the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-prepared-statements-instances-table.html
For the text protocol, this column is the external statement name assigned by the user. To control the size of this table, set the performance_schema_max_prepared_statements_instances system variable at server startup. The Performance Schema ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-tables.html
The setup_timers table contains a row with a NAME value of transaction that indicates the unit for transaction event timing. The cost of transaction instrumentation can be reduced various ways, such as enabling or disabling transaction ...These ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-tablespace-encryption.html
Is data decrypted for users who are authorized to see it? A.17.2. Is data decrypted for users who are authorized to see it? Yes. For example, assets such as pharmaceutical research results, oil field exploration results, financial contracts, or ...
https://dev.mysql.com/doc/refman/5.7/en/binary-varbinary.html
Instead, it causes the binary (_bin) collation for the column character set (or the table default character set if no column character set is specified) to be used, and the column itself stores nonbinary character strings rather than binary byte ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
Any partition-level MAX_ROWS setting for p must be the same as the table-level MAX_ROWS value set for nt. The setting for any partition-level MIN_ROWS setting for p must also be the same any table-level MIN_ROWS value set for nt. EXCHANGE PARTITION ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html
DATE_FORMAT() returns a string with a character set and collation given by character_set_connection and collation_connection so that it can return month and weekday names containing non-ASCII characters. This means, for example, that “zero” ...