Search Results
https://dev.mysql.com/doc/refman/8.4/en/other-vendor-data-types.html
If you create a table with types used by other vendors and then issue a DESCRIBE tbl_name statement, MySQL reports the table structure using the equivalent MySQL types. To facilitate the use of code written for SQL implementations from other ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-limitations-functions.html
This section discusses limitations in MySQL Partitioning relating specifically to functions used in partitioning expressions. Each of these functions returns an integer only if it is passed an argument of an exact numeric type, such as one of the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-group-state-table.html
This is where most threads end up when the thread group has created more threads than needed for normal operation. TIME_OF_LAST_THREAD_CREATION The point in time when the thread was last created. The tp_thread_group_state table has one row per ...
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery-positions.html
These are some sample steps to achieve that: Restore the last full backup created before the point-in-time of interest (call it tp, which is 20:06:00 on March 11, 2020 in our example). The last section, Section 9.5.1, “Point-in-Time Recovery ...
https://dev.mysql.com/doc/refman/8.4/en/populating-spatial-columns.html
After you have created spatial columns, you can populate them with spatial data. Values should be stored in internal geometry format, but you can convert them to that format from either Well-Known Text (WKT) or Well-Known Binary (WKB) format. For ...
https://dev.mysql.com/doc/refman/8.4/en/query-attributes.html
Because installing and uninstalling the query_attributes component installs and uninstalls the mysql_query_attribute_string() function that the component implements, it is not necessary to use CREATE FUNCTION or DROP FUNCTION to do so. The most ...
https://dev.mysql.com/doc/refman/8.4/en/query-log.html
The server creates the file in the data directory unless an absolute path name is given to specify a different directory. To rename the file and create a new one, use the following commands: $> mv host_name.log host_name-old.log $> mysqladmin ...
https://dev.mysql.com/doc/refman/8.4/en/range-optimization.html
The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value intervals. The following sections describe conditions under which the optimizer uses range access. Additionally, for ...
https://dev.mysql.com/doc/refman/8.4/en/reloading-delimited-text-dumps.html
For backups produced with mysqldump --tab, each table is represented in the output directory by an .sql file containing the CREATE TABLE statement for the table, and a .txt file containing the table data. To reload a table, first change location ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-relaylog.html
Successive relay log files are created using successive sequence numbers, beginning with 000001. On a Unix system, this can be done as shown here: $> cat new_relay_log_name.index >> old_relay_log_name.index $> mv old_relay_log_name.index ... The ...