Search Results
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-configuration-variables.html
Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that experience spikes of high activity. Preventing one-time operations such as table scans from interfering ...Because the InnoDB storage engine performs many of its optimizations automatically, many performance-tuning tasks involve monitoring to ensure that the database is performing well, and changing configuration options when performance ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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/8.4/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 ...