Search Results
https://dev.mysql.com/doc/refman/9.7/en/optimizing-spatial-analysis.html
For MyISAM and InnoDB tables, search operations in columns containing spatial data can be optimized using SPATIAL indexes. The most typical operations are: Point queries that search for all objects that contain a given point Region queries that ...
https://dev.mysql.com/doc/refman/9.7/en/option-file-options.html
Most MySQL programs that support option files handle the following options. Because these options affect option-file handling, they must be given on the command line and not in an option file. To work properly, each of these options must be given ...
https://dev.mysql.com/doc/refman/9.7/en/option-modifiers.html
For example, --maximum-max_heap_table_size=32M prevents any client from making the heap table size limit larger than 32M. Some options are “boolean” and control behavior that can be turned on or off. For example, the mysql client supports a ...
https://dev.mysql.com/doc/refman/9.7/en/option-tracker-component-system-variables.html
Table 7.10 Option Tracker System Variable Summary Variable Name Variable Type Variable Scope component_option_tracker.mysql_shell_support Boolean Global component_option_tracker.mysql_shell_support Reserved for future development. The Option ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-and-plugins.html
The associated event information, including aggregate information, remains readable in performance_schema database tables. Removing a plugin with UNINSTALL PLUGIN does not affect information already collected for code in that plugin. Time spent ...
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-options.html
Consumer names in the setup_consumers table use underscores, but for consumers set at startup, dashes and underscores within the name are equivalent. Performance Schema parameters can be specified at server startup on the command line or in option ...
https://dev.mysql.com/doc/refman/9.7/en/pluggable-storage-common-layer.html
Physical Storage: This involves everything from the overall page size for tables and indexes as well as the format used for storing data to physical disk. A MySQL pluggable storage engine is the component in the MySQL database server that is ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-decimal-characteristics.html
The storage required for remaining digits is given by the following table. This section discusses the characteristics of the DECIMAL data type (and its synonyms), with particular regard to the following topics: Maximum number of digits Storage ...
https://dev.mysql.com/doc/refman/9.7/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...
https://dev.mysql.com/doc/refman/9.7/en/problems-with-null.html
For example, the following statements are completely different: mysql> INSERT INTO my_table (phone) VALUES (NULL); mysql> INSERT INTO my_table (phone) VALUES (''); Both statements insert a value into the phone column, but the first inserts a NULL ...