Search Results
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-general-options.html
key_buffer_size is used when you are checking the table with --extend-check or when the keys are repaired by inserting keys row by row into the table (like when doing normal inserts). The options described in this section can be used for any type ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-limits.html
Memory consumed when data is inserted into an NDB table is not automatically recovered when deleted, as it is with other storage engines. Instead, the following rules hold true: A DELETE statement on an NDB table makes the memory formerly used by ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-info.html
When insertions, deletions, or updates are made to partitioned tables, the binary log records information about the partition and (if any) the subpartition in which the row event took place. This section discusses obtaining information about ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-range.html
A table that is partitioned by range is partitioned in such a way that each partition contains rows for which the partitioning expression value lies within a given range. Ranges should be contiguous but not overlapping, and are defined using the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-instrument-naming.html
This instrument comes into play when a scheduled event begins executing. For example, an insert might activate a trigger that causes an update. An instrument name consists of a sequence of elements separated by '/' characters. Example names: ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-query-profiling.html
The following example demonstrates how to use Performance Schema statement events and stage events to retrieve data comparable to profiling information provided by SHOW PROFILES and SHOW PROFILE statements. The setup_actors table can be used to ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-objects-table.html
Rows can be inserted into or deleted from setup_objects by users with the INSERT or DELETE privilege on the table. The setup_objects table controls whether the Performance Schema monitors particular objects. This table has a maximum size of 100 ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-sql-mode.html
It may also cause inserts into partitioned tables that succeed on the source to fail on the replica. Using different server SQL mode settings on the source and the replica may cause the same INSERT statements to be handled differently on the source ...For best results, you should always use the same server SQL mode on the source and on the ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
--safe-user-create Command-Line Format --safe-user-create[={OFF|ON}] Deprecated Yes Type Boolean Default Value OFF If this option is enabled, a user cannot create new MySQL users by using the GRANT statement unless the user has the INSERT privilege ... When you start the mysqld server, you can specify program options using any of the methods described in Section 6.2.2, “Specifying Program ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects-security.html
A view cannot be referenced by a user who does not have the appropriate privilege for it (SELECT to select from it, INSERT to insert into it, and so forth). Stored programs (procedures, functions, triggers, and events) and views are defined prior ...