Search Results
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-data-masking.html
As of MySQL 8.0.13, MySQL Enterprise Edition provides data masking and de-identification capabilities, which permit: Transforming existing data to mask it and remove identifying characteristics, such as changing all digits of a credit card number ...Applications that require properly formatted data, but not necessarily the original data, can synthesize sample ...
https://dev.mysql.com/doc/refman/8.4/en/access-control.html
The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to associate that user with privileges on a database such as SELECT, INSERT, UPDATE, and DELETE. MySQL enables the creation of accounts ...Additional functionality includes the ability to grant privileges for administrative ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-generated-columns.html
ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and CHANGE. CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED; The data type and expression of generated columns can be modified.
https://dev.mysql.com/doc/refman/8.4/en/charset-server.html
By default, these are utf8mb4 and utf8mb4_0900_ai_ci, but they can be set explicitly at server startup on the command line or in an option file and changed at runtime. MySQL Server has a server character set and a server collation. Initially, the ...If you don't specify a character set, that is the same as saying ...
https://dev.mysql.com/doc/refman/8.4/en/charset-table.html
Every table has a table character set and a table collation. The CREATE TABLE and ALTER TABLE statements have optional clauses for specifying the table character set and collation: CREATE TABLE tbl_name (column_list) [[DEFAULT] CHARACTER SET ...To ...
https://dev.mysql.com/doc/refman/8.4/en/index-btree-hash.html
Understanding the B-tree and hash data structures can help predict how different queries perform on different storage engines that use these data structures in their indexes, particularly for the MEMORY storage engine that lets you choose B-tree or ...B-Tree Index Characteristics Hash Index Characteristics B-Tree Index Characteristics A B-tree index can be used for column comparisons in expressions that use the =, >, >=, <, <=, or BETWEEN ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-javascript-documents-collections.html
Collections contain JSON documents that you can add, find, update, and remove. Internally, they are stored in an efficient binary format that enables fast lookups and updates. When you are using MySQL as a Document Store, collections are containers ...The examples in this section use the countryinfo collection in the world_x ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-shell-tutorial-python-documents-collections.html
Collections contain JSON documents that you can add, find, update, and remove. Internally, they are stored in an efficient binary format that enables fast lookups and updates. When you are using MySQL as a Document Store, collections are containers ...The examples in this section use the countryinfo collection in the world_x ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-temptables.html
Because of the differences in behavior between row-based or mixed replication mode and statement-based replication mode regarding temporary tables, you cannot switch the replication format at runtime, if the change applies to a context (global or ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/monitoring-support-advisors-ref.html
To display these graphs, set the target selectors to Global Summaries, select MEM Service Manager from the All Targets menu, and select Timeseries Graphs from the Metrics menu. Checks the timestamps of data collected by the agent to ensure the time ...The critical event contains information on the assets whose time is incorrectly ...HTTP Server Performance Service Manager Health Support Diagnostics Unsupported Agent Version Advisor HTTP Server ...