Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-migrate-keyring.html
If the file does not exist or is otherwise inaccessible, an error occurs. If the file does not exist or is otherwise inaccessible, an error occurs. mysql_migrate_keyring supports the following options, which can be specified on the command line or ... The mysql_migrate_keyring utility migrates keys between one keyring component and ...Note --component-dir, --source-keyring, and ...
https://dev.mysql.com/doc/internals/en/myisam-concurrent-insert.html
The copy back is done in mi_update_status(), which is called from mi_lock_database() when unlocking from a write lock. To support concurrent inserts, every statement starts with copying MYISAM_SHARE::state.state to MI_INFO::save_state and lets ...
https://dev.mysql.com/doc/internals/en/windows-native-authentication.html
Authentication::WindowsAuth: Name authentication_windows_client Requires CLIENT_PLUGIN_AUTH The Windows Native Authentication method is more complex than the other methods and extends the auth protocol as it has to send more data forth and back ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
For InnoDB tables, the Information Schema INNODB_TABLESPACES and INNODB_DATAFILES tables provide tablespace metadata. As part of the installation process in MySQL 8.4.0 and later, a file in JSON format named mysql_upgrade_history is created in the ...To enable it, start the server with --mysql-native-password=ON (added in MySQL 8.4.0), or by including mysql_native_password=ON in the [mysqld] section of your MySQL configuration file (added in MySQL ...Features Added or Changed in ...
https://dev.mysql.com/doc/internals/en/threads.html
The mysql_install_db script starts a server with an option telling it to start this thread and read commands in from a file. InnoDB has a separate maintenance thread, but BDB also uses this one to occasionally call berkeley_cleanup_log_files(). In ... Threads in mysqld can run at four different priorities, defined in mysql_priv.h: #define INTERRUPT_PRIOR 10 #define CONNECT_PRIOR 9 #define WAIT_PRIOR 8 #define QUERY_PRIOR 6 Some threads try to set their priority; others ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-roles-dynamic-privileges.html
For example, a user who must be able to modify global system variables can be granted SYSTEM_VARIABLES_ADMIN rather than SUPER. Privilege management is an important aspect of managing the security of a MySQL installation. Following the principle of ...To facilitate effective privilege management, MySQL 8.0 provides two new privilege-related features: MySQL Roles and Dynamic ...
https://dev.mysql.com/doc/x-devapi-userguide/en/sql-crud-functions.html
It is used to store data in a relational table in the database. The following SQL CRUD functions are available in X DevAPI. Table.insert() The Table.insert() method works like an INSERT statement in SQL. The example assumes that the test schema ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-summarize-content.html
In this case, the algorithm must identify patterns and relationships ', 'in the data on its own. One of the most significant developments in AI in recent years has been the rise of machine learning, a subset of AI that allows computers to learn from ... The following sections in this topic describe how to summarize exiting content using the GenAI: Before You Begin Summarizing Content Running Batch Queries What's Next Before You Begin Review the GenAI requirements and ...
https://dev.mysql.com/doc/workbench/en/wb-configuration-additional.html
This affects the generated syntax and database structure in relation to how MySQL changed over time. Related behavior: Right-click on an SQL tab and choose either Save tab (to save the tab to a file) or Close Other Tabs to close all other SQL editor ... Commonly used configuration options and preferences include: Rescan for Local MySQL Instances: Right-click on the home screen, and this option will scan your system for MySQL instances and add connection tiles to the home ...
https://dev.mysql.com/doc/internals/en/flush-tables.html
This is mainly to ensure that if someone adds a new table outside of MySQL (for example, by copying files into a database directory with cp), all threads will start using the new table. The idea of FLUSH TABLES is to force all tables to be closed.