PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 296.4Kb
Man Pages (Zip)
- 401.7Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations-storage-engines.html
The maximum amount of fixed-size data that can be stored per partition in an NDB table is 128 TB. In MySQL 8.0, partitioning support is not actually provided by the MySQL Server, but rather by a table storage engine's own or native partitioning ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-pruning.html
For example, this statement cannot use pruning because dob is a DATE column: SELECT * FROM t4 WHERE dob >= '2001-04-14' AND dob <= '2005-10-15'; However, if the table stores year values in an INT column, then a query having WHERE year_col >= 2001 ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-subpartitions.html
However, due to the action of the PARTITION BY RANGE clause, the first 2 of these store only those records with a value less than 1990 in the purchased column. Subpartitioning—also known as composite partitioning—is the further division of each ...
https://dev.mysql.com/doc/refman/8.0/en/password-security-admin.html
MySQL stores passwords for user accounts in the mysql.user system table. Database administrators should use the following guidelines to keep passwords secure. Access to this table should never be granted to any nonadministrative accounts. Account ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-data-locks-table.html
(This event might have occurred before this particular lock request occurred, if the data structure is used to store multiple locks.) EVENT_ID The Performance Schema event that caused the lock. For information about which lock requests are blocked ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-stages-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored stage event, so there is no system variable for configuring the table size. Of the tables that contain stage event rows, events_stages_current is ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-transactions-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table size. For example: mysql> SELECT * FROM ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-events-waits-current-table.html
The table stores one row per thread showing the current status of the thread's most recent monitored wait event, so there is no system variable for configuring the table size. Of the tables that contain wait event rows, events_waits_current is the ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-functions.html
As of MySQL 8.0.16, MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored functions. The built-in functions can be invoked in any schema ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-naming.html
An instrument name consists of a sequence of elements separated by '/' characters. Example names: wait/io/file/myisam/log wait/io/file/mysys/charset wait/lock/table/sql/handler wait/synch/cond/mysys/COND_alarm ...