Search Results
https://dev.mysql.com/doc/refman/8.4/en/custom-benchmarks.html
After fixing one bottleneck (or by replacing it with a “dummy” module), you can proceed to identify the next bottleneck. Benchmark your application and database to find out where the bottlenecks are. Even if the overall performance for your ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-schema.html
If an upgrade is necessary and supported, the server creates data dictionary tables with updated definitions, copies persisted metadata to the new tables, atomically replaces the old tables with the new ones, and reinitializes the data dictionary.
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-function-reference.html
Table 8.46 MySQL Enterprise Data Masking and De-Identification Component Functions Name Description gen_blocklist() Perform dictionary term replacement gen_dictionary() Return random term from dictionary gen_range() Generate random number within ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking.html
A variant of this scenario may be that the real city name is replaced only if it exists in usa_city_names. Note MySQL Enterprise Data Masking and De-Identification is an extension included in MySQL Enterprise Edition, a commercial product. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default value for a column. Examples: CREATE TABLE t1 ( i INT DEFAULT -1, c VARCHAR(10) DEFAULT '', ...
https://dev.mysql.com/doc/refman/8.4/en/ddl-rewriter.html
Within statements considered for rewrite, instances of the following clauses are rewritten and each instance replaced by a single space: ENCRYPTION DATA DIRECTORY (at the table and partition levels) INDEX DIRECTORY (at the table and partition ...
https://dev.mysql.com/doc/refman/8.4/en/delete.html
DELETE QUICK is most useful for applications where index values for deleted rows are replaced by similar index values from rows inserted later. DELETE is a DML statement that removes rows from a table. A DELETE statement can start with a WITH ...
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-getting-started.html
Warning The MySQL Docker images maintained by the MySQL team are built specifically for Linux platforms. Other platforms are not supported, and users using these MySQL Docker images on them are doing so at their own risk. See the discussion here ...
https://dev.mysql.com/doc/refman/8.4/en/docker-mysql-more-topics.html
A MySQL Docker installation is different from a common, non-Docker installation in the following aspects: Only a limited number of binaries are included. Warning Any software updates or installations users perform to the Docker container (including ...
https://dev.mysql.com/doc/refman/8.4/en/features.html
Support for DELETE, INSERT, REPLACE, and UPDATE to return the number of rows that were changed (affected), or to return the number of rows matched instead by setting a flag when connecting to the server. This section describes some of the important ...