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/partitioning-info.html
This section discusses obtaining information about existing partitions, which can be done in a number of ways. Methods of obtaining such information include the following: Using the SHOW CREATE TABLE statement to view the partitioning clauses used ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-overview.html
Partition selection is also supported for the data modification statements DELETE, INSERT, REPLACE, UPDATE, and LOAD DATA, LOAD XML. This section provides a conceptual overview of partitioning in MySQL 5.7. For information on partitioning ...
https://dev.mysql.com/doc/refman/5.7/en/password-logging.html
In particular, INSERT or UPDATE statements for the mysql.user system table that refer to literal passwords are logged as is, so you should avoid such statements. Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT, ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrument-filtering.html
| stage/sql/end | NO | NO | | stage/sql/executing | NO | NO | | stage/sql/init | NO | NO | | stage/sql/insert | NO | NO | ... The setup_instruments table lists the available instruments: mysql> SELECT * FROM performance_schema.setup_instruments; ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-quick-start.html
| stage/sql/end | NO | NO | | stage/sql/executing | NO | NO | | stage/sql/init | NO | NO | | stage/sql/insert | NO | NO | ... This section briefly introduces the Performance Schema with examples that show how to use it. For additional examples, see ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-instruments-table.html
| stage/sql/end | NO | NO | | stage/sql/executing | NO | NO | | stage/sql/init | NO | NO | | stage/sql/insert | NO | NO | ... The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-stage-tables.html
The Performance Schema instruments stages, which are steps during the statement-execution process, such as parsing a statement, opening a table, or performing a filesort operation. Stages correspond to the thread states displayed by SHOW ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-monitoring.html
When the server cannot create a mutex instrument, these results occur: No row for the instrument is inserted into the setup_instruments table. Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-table-characteristics.html
Some of the setup tables have columns that can be modified to affect Performance Schema operation; some also permit rows to be inserted or deleted. The name of the performance_schema database is lowercase, as are the names of tables within it. Many ...