Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
When a tablespace is encrypted, a tablespace key is encrypted and stored in the tablespace header. All MySQL editions provide a component_keyring_file component, which stores keyring data in a file local to the server host. MySQL Enterprise Edition ... InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system tablespace, redo logs, and undo ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-storage-engine.html
MyISAM tables have the following characteristics: All data values are stored with the low byte first. All numeric key values are stored with the high byte first to permit better index compression. myisamchk --analyze stores statistics for portions ... MyISAM is based on the older (and no longer available) ISAM storage engine but has many useful ...
https://dev.mysql.com/doc/refman/8.4/en/numeric-type-attributes.html
Whether it is used is up to the application.) The display width does not constrain the range of values that can be stored in the column. If you store values larger than the display width in an integer column that has the ZEROFILL attribute, you may ... MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-range.html
Since 5 is not less than 5 and 12 is not less than 12, (5,12) is considered not less than (5,12), and is stored in partition p1. Range columns partitioning is similar to range partitioning, but enables you to define partitions using ranges based on ...
https://dev.mysql.com/doc/refman/8.4/en/show-warnings.html
To change the number of messages the server can store, change the value of max_error_count. max_error_count controls only how many messages are stored, not how many are counted. In this case, warning_count still indicates how many warnings occurred, ... SHOW WARNINGS [LIMIT [offset,] row_count] SHOW COUNT(*) WARNINGS SHOW WARNINGS is a diagnostic statement that displays information about the conditions (errors, warnings, and notes) resulting from executing a statement in the current ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-how-to-import-onnx.html
For example: mysql> CREATE DATABASE onnx_model; mysql> USE onnx_model; Create a table with only one column to store the string. For example: mysql> CREATE DATABASE onnx_model; mysql> USE onnx_model; Create a table to store the model. The table must ... This topic describes how to import an external ONNX ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-generate-content.html
InputTableName: the name of the table that contains the column where your input queries are stored. OutputDBName: the name of the database that contains the table where you want to store the generated outputs. OutputTableName: the name of the table ... The following sections in this topic describe how to generate new text-based content using the GenAI feature of MySQL AI: Before You Begin Generating Content Running Batch Queries What's Next Before You Begin Review the GenAI requirements and ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-datetime-types-processing.html
With that no intermediate conversion between JVM default time zone and connection time zone is needed to store correct milliseconds value of instant Java objects such as 'java.sql.Timestamp' or 'java.time.OffsetDateTime' when stored in TIMESTAMP ...
https://dev.mysql.com/doc/internals/en/integer.html
The MySQL Protocol has a set of possible encodings for integers: Fixed-length integers Length-encoded integers 14.1.1.1.1 Fixed-Length Integer Types Protocol::FixedLengthInteger A fixed-length integer stores its value in a series of bytes with the ...Note Up to MySQL 3.22, 0xfe was followed by a 4-byte ...
https://dev.mysql.com/doc/internals/en/join-buffer-size.html
Accepted row combinations of tables before the ALL/index are stored in the cache and are used to compare against each read row in the ALL table. We only store the used columns in the join buffer, not the whole rows. (In other words, we store the ...