Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-8-0-connection-options.html
AllowLoadLocalInfile , Allow Load Local Infile Default: false Disables (by default) or enables the server functionality to load the data local infile. Connector/NET 8.0 exposes the options in this section as properties in both the ... This chapter ...For instructions about how to use connection strings, see Section 4.1, “Creating a Connector/NET Connection ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-sql-editor.html
Show Metadata and Internal Schemas Whether to show metadata and internal schemas in the schema tree, such as INFORMATION_SCHEMA, mysql, and schemas starting with the period character (.). DBMS connection read timeout interval (in seconds):[30] The ... This section provides configuration options that affect the SQL editor functionality in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-component-installation.html
MySQL provides these keyring component choices: component_keyring_file: Stores keyring data in a file local to the server host. component_keyring_encrypted_file: Stores keyring data in an encrypted, password-protected file local to the server host.
https://dev.mysql.com/doc/ndbapi/en/ndb-dictionary.html
An error occurs if a transaction is already active, or if the kernel metadata is locked. Dictionary::getDatafile() Description This method is used to retrieve a Datafile object, given the node ID of the data node where a data file is located and the ...You must use Column class methods for this purpose—see Section 2.3.1, “The Column Class”, for ...
https://dev.mysql.com/doc/refman/8.4/en/analyze-table.html
If the innodb_read_only system variable is enabled, ANALYZE TABLE may fail because it cannot update statistics tables in the data dictionary, which use InnoDB. The InnoDB storage engine provides its own sampling implementation for data stored in ...
https://dev.mysql.com/doc/internals/en/myisam-introduction.html
These files will be in the directory: /<datadir>/<database>/ For example, if you use Linux, you might find the files in the /usr/local/var/test directory (assuming your database name is test). if you use Windows, you might find the files in the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/bugs.backup.html
If autocommit is turned off, and both InnoDB tables and non-transactional tables are modified within the same transaction, data can be written to the non-transactional table before the binary log position is updated. Hot backups for large databases ...The binary log position is updated when the transaction is committed, but the non-transactional data is written ...Backup of a partitioned table ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-tools-with-access-linked-tables.html
Click either the File Data Source or Machine Data Source tab, and then double-click the Connector/ODBC DSN you want to link your table to. When a query is requested on a table within Access, ODBC is used to execute the queries on the MySQL database.
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-linked-tables.html
Click either the File Data Source or Machine Data Source tab, and then double-click the Connector/ODBC DSN you want to link your table to. When a query is requested on a table within Access, ODBC is used to execute the queries on the MySQL database.
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-0.html
For InnoDB tables, the Information Schema INNODB_TABLESPACES and INNODB_DATAFILES tables provide tablespace metadata. (WL #15822) InnoDB: Changed the default values for the following InnoDB configuration options: innodb_adaptive_hash_index, ...The ...(Bug #36301441) Audit log filtering by type, using error as the type, did not work ...(Bug #36118809) C API Notes Important Change: The following MySQL C API functions, removed in MySQL 8.3, have been reimplemented and restored in MySQL 8.4.0: mysql_kill(): In place of COM_PROCESS_KILL (removed), ...