Search Results
https://dev.mysql.com/doc/refman/8.4/en/partitioning-linear-hash.html
MySQL also supports linear hashing, which differs from regular hashing in that linear hashing utilizes a linear powers-of-two algorithm whereas regular hashing employs the modulus of the hashing function's value. We call this value V; it can be ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-quick-start.html
| stage/sql/end | NO | NO | | stage/sql/executing | NO | NO | | stage/sql/init | NO | NO | | stage/sql/insert | NO | NO | ... There are some miscellaneous tables that do not fall into any of the previous groups. This section briefly introduces the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-status-monitoring.html
When the server cannot create a mutex instrument, these results occur: No row for the instrument is inserted into the setup_instruments table. Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many ...
https://dev.mysql.com/doc/refman/8.4/en/plugin-loading.html
Server plugins must be loaded into the server before they can be used. For this reason, INSTALL PLUGIN requires the INSERT privilege for the mysql.plugin table. It is also possible to control the activation state of loaded plugins at startup, and ...
https://dev.mysql.com/doc/refman/8.4/en/query-attributes.html
The most visible part of an SQL statement is the text of the statement. Clients can also define query attributes that apply to the next statement sent to the server for execution: Attributes are defined prior to sending the statement. Attributes ...
https://dev.mysql.com/doc/refman/8.4/en/replication-snapshot-method.html
This can be more efficient than using mysqldump and importing the file on each replica, because it skips the overhead of updating indexes as the INSERT statements are replayed. Once the data dump has been completed, import this data into the replica ... If the source database contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/8.4/en/resource-groups.html
MySQL supports creation and management of resource groups, and permits assigning threads running within the server to particular groups so that threads execute according to the resources available to the group. Group attributes enable control over ...
https://dev.mysql.com/doc/refman/8.4/en/rewriter-query-rewrite-plugin.html
These statements are subject to rewriting: SELECT, INSERT, REPLACE, UPDATE, and DELETE. The query_rewrite database contains a stored procedure named flush_rewrite_rules() that loads the contents of the rules table into the plugin. MySQL supports ...
https://dev.mysql.com/doc/refman/8.4/en/select-optimization.html
Besides SELECT statements, the tuning techniques for queries also apply to constructs such as CREATE TABLE...AS SELECT, INSERT INTO...SELECT, and WHERE clauses in DELETE statements. Queries, in the form of SELECT statements, perform all the lookup ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-event.html
SHOW CREATE EVENT event_name This statement displays the CREATE EVENT statement needed to re-create a given event. It requires the EVENT privilege for the database from which the event is to be shown. For example (using the same event e_daily ...