Search Results
https://dev.mysql.com/doc/refman/8.4/en/spatial-geohash-functions.html
If any argument has a longitude or latitude that is out of range, an error occurs: If a longitude value is not in the range (−180, 180], an ER_GEOMETRY_PARAM_LONGITUDE_OUT_OF_RANGE error occurs. If a latitude value is not in the range [−90, 90], ... Geohash is a system for encoding latitude and longitude coordinates of arbitrary precision into a text ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-logging.html
innodb_log_wait_for_flush_spin_hwm: Defines the maximum average log flush time beyond which user threads no longer spin while waiting for flushed redo. On a system with a multi-core processor, a value of 150 represents 100% usage of one CPU core ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-query-plan-improvement.html
When a new query shares query execution plan nodes with previously executed queries, the statistics collected from previously executed queries are used instead of estimated statistics, which improves query execution plans, cost estimations, ... The ...When cache capacity is reached, the least recently used entries are evicted from the cache as new entries are ...
https://dev.mysql.com/doc/refman/8.4/en/show-profile.html
For example, SHOW PROFILING is an illegal statement, and a syntax error occurs if you try to execute it, but it shows up in the profiling list. Without the FOR QUERY n clause, the output pertains to the most recently executed statement. Note The ...
https://dev.mysql.com/doc/refman/8.4/en/user-variables.html
A reference to a user variable in a prepared statement has its type determined when the statement is first prepared, and retains this type each time the statement is executed thereafter. Similarly, the type of a user variable employed in a statement ... You can store a value in a user-defined variable in one statement and refer to it later in another ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-key-caches.html
If you want the association to take effect each time the server starts, one way to accomplish this is to use an option file: Include variable settings that configure your key caches, and an init_file system variable that names a file containing ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-tp-thread-state-table.html
PROCESS_COUNT The 10ms interval in which the statement that uses this thread is currently executing. 0 means no statement is executing, 1 means it is in the first 10ms, and so forth. The value shown in this column is one of ... The tp_thread_state ...
https://dev.mysql.com/doc/internals/en/opening-a-table.html
The second parameter determines what file to open or what operation to take. Before any read or write operations are performed on a table, the MySQL server will call the [custom-engine.html#custom-engine-api-reference-open handler::open()] method ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnectionpool-constructor.html
It is not an error for multiple pools to have the same name. Syntax: MySQLConnectionPool(pool_name=None, pool_size=5, pool_reset_session=True, **kwargs) This constructor instantiates an object that manages a connection pool. If this argument is not ...
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnectionpool-constructor.html
It is not an error for multiple pools to have the same name. Syntax: MySQLConnectionPool(pool_name=None, pool_size=5, pool_reset_session=True, **kwargs) This constructor instantiates an object that manages a connection pool. If this argument is not ...