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/multibyte-characters.html
If you want to add support for a new character set named MYSET that includes multibyte characters, you must use multibyte character functions in the ctype-MYSET.c source file in the strings directory. The existing character sets provide the best ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-memory-model.html
Memory used depends on the load actually seen, not the load estimated or explicitly configured for. As the Performance Schema collects data, memory is allocated in the corresponding buffer. The buffer size is unbounded, and may grow with the load.
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-options.html
Runtime configuration is also possible in many cases (see Section 25.4, “Performance Schema Runtime Configuration”), but startup configuration must be used when runtime configuration is too late to affect instruments that have already been ...
https://dev.mysql.com/doc/refman/5.7/en/caching-sha2-pluggable-authentication.html
For example: $> mysql --ssl-mode=DISABLED -u sha2user -p Enter password: password For this connection attempt by sha2user, the server determines that caching_sha2_password is the appropriate authentication plugin and invokes it (because that was the ... MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: sha256_password: Implements basic SHA-256 ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math.html
These features have several implications for numeric operations and provide a high degree of compliance with standard SQL: Precise calculations: For exact-value numbers, calculations do not introduce floating-point errors. For example, MySQL treats ... MySQL provides support for precision math: numeric value handling that results in extremely accurate results and a high degree control over invalid ...
https://dev.mysql.com/doc/refman/5.7/en/sys-format-statement.html
This function is useful for formatting possibly lengthy statements retrieved from Performance Schema tables to a known fixed maximum length. Configuration Options format_statement() operation can be modified using the following configuration options ... Given a string (normally representing an SQL statement), reduces it to the length given by the statement_truncate_len configuration option, and returns the ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication.html
Groups can operate in a single-primary mode with automatic primary election, where only one server accepts updates at a time. There is a built-in group membership service that keeps the view of the group consistent and available for all servers at ... This chapter explains MySQL Group Replication and how to install, configure and monitor ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-table-close.html
The counter works as follows: The first time a table is updated in MySQL, a counter in the header of the index files is incremented. (The table may still be okay because MySQL always issues writes for everything between each statement.) A table was ... Each MyISAM index file (.MYI file) has a counter in the header that can be used to check whether a table has been closed ...
https://dev.mysql.com/doc/refman/5.7/en/using-gdb-on-mysqld.html
In this case, you can only have one thread active at a time. It is very hard to debug MySQL under gdb if you do a lot of new connections the whole time as gdb does not free the memory for old threads. On most systems you can also start mysqld from ...
https://dev.mysql.com/doc/refman/5.7/en/what-is-mysql.html
We use the phrase “the SQL standard” to mean the current version of the SQL Standard at any time. It is the only cloud service that combines transactions, real-time analytics across data warehouses and data lakes, and machine learning in one ...