Search Results
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-myisam-category.html
Keep Files On Create Enabled Whether to overwrite MyISAM MYD/MYI files or return an error if no DATA DIRECTORY / INDEX DIRECTORY option is set, and the files already exist. Myisam Max Sort File Size The maximum size of the temporary file that MySQL ... Lists the Myisam configuration metrics and provides a brief description of ...
https://dev.mysql.com/doc/refman/8.4/en/full-table.html
If a table-full error occurs, it may be that the disk is full or that the table has reached its maximum size. The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/gis-class-geometry.html
For computations on multiple geometry values, all values must have the same SRID or an error occurs. This is the bounding geometry, formed by the minimum and maximum (X,Y) coordinates: ((MINX MINY, MAXX MINY, MAXX MAXY, MINX MAXY, MINX MINY)) ...It ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-transporters.html
When a given transporter is in a state of overload, any new transaction that tries to use this transporter fails with Error 1218 (Send Buffers overloaded in NDB kernel). Notes For each running data node in the cluster, the transporters table ...
https://dev.mysql.com/doc/refman/8.4/en/socket-pluggable-authentication.html
With this plugin-loading method, the option must be given each time the server starts. Alternatively, to load the plugin at runtime, use this statement: INSTALL PLUGIN auth_socket SONAME 'auth_socket.so'; INSTALL PLUGIN loads the plugin immediately, ... The server-side auth_socket authentication plugin authenticates clients that connect from the local host through the Unix socket ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-statistics-estimation.html
Values much larger than 8 (say, 100), can cause a significant slowdown in the time it takes to open a table or execute SHOW TABLE STATUS. Because the statistics are automatically recalculated at various times other than on execution of ANALYZE ...
https://dev.mysql.com/doc/refman/8.4/en/update.html
Each matching row is updated once, even if it matches the conditions multiple times. The UPDATE statement supports the following modifiers: With the LOW_PRIORITY modifier, execution of the UPDATE is delayed until no other clients are reading from ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-mixed.html
A warning is added to the SHOW WARNINGS table each time such a statement is executed. Type binlog_format SLC RLC Error / Warning Logged as * * No No Error: Cannot execute statement: Binary logging is impossible since at least one engine is involved ...The following system variables, when used with session scope (only), do not cause the logging format to switch: auto_increment_increment auto_increment_offset character_set_client character_set_connection character_set_database character_set_server collation_connection collation_database collation_server foreign_key_checks identity last_insert_id lc_time_names pseudo_thread_id sql_auto_is_null time_zone timestamp unique_checks For information about determining system variable scope, see Section 7.1.9, “Using System ...
https://dev.mysql.com/doc/internals/en/cowork-with-dbug-facility.html
Sometimes it is also useful to see, which synchronization points have been run through (hit) with or without executing actions. The following shell commands proved very useful in extracting relevant information: egrep 'query:|debug_sync_exec:' ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-transaction-inconsistencies.html
When using a multithreaded replica, workers which have not received an error complete their queues, so it may take time to stop all threads. Inconsistencies in the sequence of transactions that have been executed from the relay log can occur ...