Search Results
https://dev.mysql.com/doc/refman/8.4/en/numeric-types.html
The BIT data type stores bit values and is supported for MyISAM, MEMORY, InnoDB, and NDB tables. These types include the exact numeric data types (INTEGER, SMALLINT, DECIMAL, and NUMERIC), as well as the approximate numeric data types (FLOAT, REAL, ...
https://dev.mysql.com/doc/refman/8.4/en/optimization-indexes.html
The index entries act like pointers to the table rows, allowing the query to quickly determine which rows match a condition in the WHERE clause, and retrieve the other column values for those rows. The best way to improve the performance of SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-features-to-trace.html
They are: Greedy search: With an N-table join, this could explore factorial(N) plans. Some features in the optimizer can be invoked many times during statement optimization and execution, and thus can make the trace grow beyond reason. Range ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-tracing-typical-usage.html
To perform optimizer tracing entails the following steps: Enable tracing by executing SET optimizer_trace="enabled=ON". See Section 10.15.3, “Traceable Statements”, for a listing of statements which can be traced. To examine traces for multiple ...
https://dev.mysql.com/doc/refman/8.4/en/optimizer-tracing.html
The MySQL optimizer includes the capability to perform tracing; the interface is provided by a set of optimizer_trace_xxx system variables and the INFORMATION_SCHEMA.OPTIMIZER_TRACE table.
https://dev.mysql.com/doc/refman/8.4/en/optimizing-database-structure.html
In your role as a database designer, look for the most efficient way to organize your schemas, tables, and columns. As when tuning application code, you minimize I/O, keep related items together, and plan ahead so that performance stays high as the ...
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
To specify an alternate login path file name, set the MYSQL_TEST_LOGIN_FILE environment variable. Most MySQL programs that support option files handle the following options. Because these options affect option-file handling, they must be given on ...
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 ...