Search Results
https://dev.mysql.com/doc/refman/8.4/en/event-scheduler.html
Section 27.4.3, “Event Syntax”, discusses the SQL statements for creating, altering, and dropping MySQL Events. Stored routines require the events data dictionary table in the mysql system database. If you are upgrading to MySQL 8.4 from an ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-partitions-table.html
TABLE_SCHEMA The name of the schema (database) to which the table belongs. The indexing can change as partitions are added, dropped, and reorganized; the number shown is this column reflects the current order, taking into account any indexing ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-create-table-external.html
This requirement permits database administrators to control where tablespace data files are created and ensures that data files can be found during recovery (see Tablespace Discovery During Crash Recovery). In this case, you can restore the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-space.html
Pages, Extents, Segments, and Tablespaces Each tablespace consists of database pages. Dropping a table or deleting all rows from it is guaranteed to release the space to other users, but remember that deleted rows are physically removed only by the ... The data files that you define in the configuration file using the innodb_data_file_path configuration option form the InnoDB system ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-read-only-instance.html
For example: --innodb-temp-data-file-path=../../../tmp/ibtmp1:12M:autoextend Enabling innodb_read_only prevents table creation and drop operations for all storage engines. These operations modify data dictionary tables in the mysql system database, ... You can query InnoDB tables where the MySQL data directory is on read-only media by enabling the --innodb-read-only configuration option at server ...
https://dev.mysql.com/doc/refman/8.4/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Some keywords which are otherwise ...
https://dev.mysql.com/doc/refman/8.4/en/partial-revokes.html
It is possible to grant privileges that apply globally if the partial_revokes system variable is enabled. Specifically, for users who have privileges at the global level, partial_revokes enables privileges for specific schemas to be revoked while ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-host-cache-table.html
For example, the database does not exist or the user has no privileges to access it. The MySQL server maintains an in-memory host cache that contains client host name and IP address information and is used to avoid Domain Name System (DNS) lookups.
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks.html
You want to have an administrator account that enables an administrator to perform only operations that are directly relevant to the replication channel and the databases it replicates, rather than having wide privileges on the server instance. By ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-best-practices.html
For a current list of supported platforms, see: https://www.mysql.com/support/supportedplatforms/database.html Understand MySQL Server Changes Each major version comes with new features, changes in behavior, deprecations, and removals. Run Upgrade ... MySQL supports upgrading between minor versions (within an LTS series) and to the next major version (across an LTS ...