Search Results
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 ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-table-statistics-with-buffer.html
insert_latency The total wait time of timed insert I/O events for the table. These views summarize table statistics, including InnoDB buffer pool statistics. By default, rows are sorted by descending total wait time (tables with most contention ...
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-table-statistics.html
insert_latency The total wait time of timed insert I/O events for the table. By default, rows are sorted by descending total wait time (tables with most contention first). The schema_table_statistics and x$schema_table_statistics views have these ...
https://dev.mysql.com/doc/refman/8.4/en/with.html
Immediately preceding SELECT for statements that include a SELECT statement: INSERT ... A common table expression (CTE) is a named temporary result set that exists within the scope of a single statement and that can be referred to later within that ...