PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/history.html
This API was designed to enable third-party code that was written for use with mSQL to be ported easily for use with MySQL. We started out with the intention of using the mSQL database system to connect to our tables using our own fast low-level ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-columns-table.html
The POS value for a virtual generated column encodes the column sequence number and ordinal position of the column. PRTYPE The InnoDB “precise type”, a binary value with bits representing MySQL data type, character set code, and nullability. For ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-metrics-table.html
Each monitor represents a point within the InnoDB source code that is instrumented to gather counter information. The INNODB_METRICS table provides a wide variety of InnoDB performance information, complementing the specific focus areas of the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-optimization.html
Consider this statement, which identifies collations for the utf8mb4 character set: mysql> SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATION_CHARACTER_SET_APPLICABILITY WHERE CHARACTER_SET_NAME = 'utf8mb4'; +----------------------------+ | ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-profiling-table.html
SOURCE_FUNCTION, SOURCE_FILE, and SOURCE_LINE Information indicating where in the source code the profiled state executes. Its contents correspond to the information produced by the SHOW PROFILE and SHOW PROFILES statements (see Section 15.7.7.30, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-benefits.html
For InnoDB-specific tuning techniques you can apply to your MySQL server and application code, see Section 10.5, “Optimizing for InnoDB Tables”. InnoDB tables have the following benefits: If the server unexpectedly exits because of a hardware ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-fulltext-index.html
Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those columns. A full-text index is defined as part of a CREATE TABLE statement or added to an ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-system-tables.html
You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA tables. Traditionally, you would get this type of information using the techniques from Section 17.17, “InnoDB Monitors”, setting up InnoDB monitors ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-transaction-model.html
To implement a large-scale, busy, or highly reliable database application, to port substantial code from a different database system, or to tune MySQL performance, it is important to understand InnoDB locking and the InnoDB transaction model. This ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-benefits.html
The serialization features of memcached, which can turn complex data structures, binary files, or even code blocks into storable strings, offer a simple way to get such objects into a database. The combination of InnoDB tables and memcached offers ...