Search Results
https://dev.mysql.com/doc/refman/8.4/en/constant-folding-optimization.html
Consider the table created by the following statement: CREATE TABLE t (c TINYINT UNSIGNED NOT NULL); The WHERE condition in the query SELECT * FROM t WHERE c < 256 contains the integral constant 256 which is out of range for a TINYINT UNSIGNED ...
https://dev.mysql.com/doc/refman/8.4/en/examples.html
Some of the examples use the table shop to hold the price of each article (item number) for certain traders (dealers). Here are examples of how to solve some common problems with MySQL. Supposing that each trader has a single fixed price per ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-memory.html
If you are going to use myisamchk on very large tables, you should first decide how much memory you want it to use. This space is not needed if you do a repair with --quick; in this case, only the index file is re-created. This space must be ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-rolling-restart.html
Create a backup using the ndb_mgm client START BACKUP command prior to performing the restart. Use mysqldump to create a backup prior to the upgrade; afterward, restore the dump using LOAD DATA. To free memory previously allocated to a table by ...
https://dev.mysql.com/doc/refman/8.4/en/obtaining-loadable-function-information.html
The Performance Schema user_defined_functions table contains information about the currently installed loadable functions: SELECT * FROM performance_schema.user_defined_functions; The mysql.func system table also lists installed loadable functions, ...This difference makes user_defined_functions preferable to mysql.func for checking which loadable functions are ...
https://dev.mysql.com/doc/refman/8.4/en/query-attributes.html
INSTALL COMPONENT loads the component, and also registers it in the mysql.component system table to cause it to be loaded during subsequent server startups. To uninstall the query_attributes component, use this statement: UNINSTALL COMPONENT ... The ...
https://dev.mysql.com/doc/refman/8.4/en/query-log.html
Each line that shows when a client connects also includes using connection_type to indicate the protocol used to establish the connection. connection_type is one of TCP/IP (TCP/IP connection established without SSL), SSL/TLS (TCP/IP connection ...
https://dev.mysql.com/doc/refman/8.4/en/replica-logs.html
The mysql.slave_master_info and mysql.slave_relay_log_info tables are created using the transactional storage engine InnoDB. A replica server creates several repositories of information to use for the replication process: The replica's relay log, ...The transactions in the relay log are applied on the replica by the replication SQL (applier) ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-reference-systems.html
MySQL maintains information about available spatial reference systems for spatial data in the data dictionary mysql.st_spatial_reference_systems table, which can store entries for projected and geographic SRSs. This data dictionary table is ... A ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-7.html
InnoDB Notes Creating a thread for parallel scan may fail, resulting in assertion failures when it fell back to single-thread mode. (Bug #37602657) If the row size exceeded the maximum allowed size due to innodb_strict_mode=OFF, confusing warning ...