Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-security-mysql-privileges.html
This includes all MySQL privilege types (SELECT privilege, UPDATE privilege, DELETE privilege, and so on) granted on the database, table, and column level. As with any other MySQL Server, user and privilege information is stored in the mysql system ... In this section, we discuss how the MySQL privilege system works in relation to NDB Cluster and the implications of this for keeping an NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/rebuilding-tables.html
This can be a more convenient means of repairing tables because you can use the --databases or --all-databases option to repair all tables in specific databases or all databases, respectively: mysqlcheck --repair --databases db_name ... This ...
https://dev.mysql.com/doc/refman/8.4/en/reloading-sql-format-dumps.html
To reload a dump file written by mysqldump that consists of SQL statements, use it as input to the mysql client.
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-partial-options.html
For example, --include-tables=^mydb\.t[12]$ matches the tables t1 and t2 in the database mydb. While mysqlbackup understands the MySQL convention of quoting the database or the table name (or both) by backticks (see Schema Object Names), there is no ... To select specific data to be backed up or restored, use the partial backup and restore options described in this ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-errors.html
Transactions are supported within MySQL when using the InnoDB database engine, which is the default storage engine in MySQL 5.5 and higher. Check the following before continuing: Verify that your MySQL server supports a transactional database engine. Verify that the tables you are updating use a transactional database ... The following section ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-errors.html
Transactions are supported within MySQL when using the InnoDB database engine, which is the default storage engine in MySQL 5.5 and higher. Check the following before continuing: Verify that your MySQL server supports a transactional database engine. Verify that the tables you are updating use a transactional database ... The following section ...
https://dev.mysql.com/doc/internals/en/files-in-innodb-sources.html
\buf (BUFFERING) File Name What Name Stands For Size Comment Inside File --------- -------------------- ------ ------------------- buf0buf.c Buffering / Buffering 65,582 The database buffer buf_pool buf0flu.c Buffering / Flush 29,583 ... \db ... The ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-natural-language.html
It is possible to write a plugin that replaces the built-in full-text parser. By default or with the IN NATURAL LANGUAGE MODE modifier, the MATCH() function performs a natural language search for a string against a text collection. A collection is ...
https://dev.mysql.com/doc/refman/8.4/en/identifier-mapping.html
There is a correspondence between database and table identifiers and names in the file system. For the basic structure, MySQL represents each database as a directory in the data directory, and depending upon the storage engine, each table may be ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
A broad categorization is that the mysql schema contains data dictionary tables that store database object metadata, and system tables used for other operational purposes. Previously, these tables were created in individual tablespace files in the ...It contains tables that store information required by the MySQL server as it ...