Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-usage-differences.html
Use of a data dictionary-enabled MySQL server entails some operational differences compared to a server that does not have a data dictionary: Previously, enabling the innodb_read_only system variable prevented creating and dropping tables only for ...As of MySQL 8.4, enabling innodb_read_only prevents these operations for all storage ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-components-installation.html
While the mysql system schema is the traditional storage option, creating a dedicated schema for this purpose is also permitted. A user or role requires no mysql schema privileges when preforming related data-masking tasks in the dedicated schema.
https://dev.mysql.com/doc/refman/8.4/en/events-syntax.html
MySQL provides several SQL statements for working with scheduled events: New events are defined using the CREATE EVENT statement. An event can be dropped by any user having the EVENT privilege for the database on which the event is defined. The ...
https://dev.mysql.com/doc/refman/8.4/en/explain-output.html
If so, create an appropriate index and check the query with EXPLAIN again. Plan isn't ready yet (JSON property: none) This value occurs with EXPLAIN FOR CONNECTION when the optimizer has not finished creating the execution plan for the statement ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-mapping.html
If you are using tablespaces with InnoDB, then the specific tablespace files you create are used instead. MySQL encodes any characters that are problematic in the corresponding file system objects when it creates database directories or table files: ... There is a correspondence between database and table identifiers and names in the file ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-tables-table.html
Names of databases and user tables are in the same case as they were originally defined, possibly influenced by the lower_case_table_names setting. The number reported includes three hidden columns that are created by InnoDB (DB_ROW_ID, DB_TRX_ID, ...For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-analyze-table-complexity.html
To set the number of pages sampled for an individual table, use the STATS_SAMPLE_PAGES option with CREATE TABLE or ALTER TABLE. For the nonunique indexes, the primary key columns (a,b) are counted in addition to the user defined columns. ANALYZE ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-locks-set.html
If you have no indexes suitable for your statement and MySQL must scan the entire table to process the statement, every row of the table becomes locked, which in turn blocks all inserts by other users to the table. It is important to create good ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-error-reporter.html
ndb_error_reporter creates an archive from data node and management node log files that can be used to help diagnose bugs or other problems with a cluster. Usage ndb_error_reporter path/to/config-file [username] [options] This utility is intended ...It is highly recommended that you make use of this utility when filing reports of bugs in NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-oci-marketplace-deploy.html
See To create a Linux instance for information on how to complete the fields. By default, the MySQL server listens on port 3306 and is configured with a single user, root. /etc/my.cnf.d/perf-tuning.cnf is created by /usr/bin/mkcnf based on the ...