Search Results
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
To specify more than one database, use this option multiple times, once for each database; however, doing so does not replicate cross-database statements such as UPDATE some_db.some_table SET foo='bar' while a different database (or no database) is ...--replicate-do-db=db_name Command-Line Format --replicate-do-db=name Type String Creates a replication filter using the name of a ... This section explains the server options and system variables that apply to replica servers and contains the following: Startup ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-genai-database-llms.html
For MySQL 9.3.2 and later, see View Available Models on how to view a list of the supported in-database LLMs. MySQL HeatWave GenAI In-Database LLMs 14.2.2 MySQL HeatWave GenAI In-Database LLMs MySQL HeatWave GenAI supports LLMs hosted and executed ...llama3-8b-instruct-v1: supports English (en), French (fr), German (de), Hindi (hi), Italian (it), Portuguese (pt), Spanish (es), and Thai ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-performanceschema-activity-category.html
Table 6.22 Performance Schema Activity Metrics NameDescriptionCond Classes Lost (Delta) How many instruments of type cond could not be loaded. Cond Instances Lost (Delta) How many instances of object type cond could not be created. File Classes Lost ... Lists the Performance Schema Activity metrics and provides a brief description of ...
https://dev.mysql.com/doc/refman/8.4/en/creating-accounts.html
To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and remove accounts. This section discusses the following topics: Creating Accounts and Granting Privileges Checking Account Privileges and ...GRANT and REVOKE assign privileges to and revoke privileges from ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-database.html
This property sets the current (default) database by executing a USE statement. The property can also be used to retrieve the current database name. >>> cnx.database = 'test' >>> cnx.database = 'mysql' >>> cnx.database u'mysql' Returns a string.
https://dev.mysql.com/doc/connector-python/en/connector-python-api-mysqlconnection-database.html
This property sets the current (default) database by executing a USE statement. The property can also be used to retrieve the current database name. >>> cnx.database = 'test' >>> cnx.database = 'mysql' >>> cnx.database u'mysql' Returns a string.
https://dev.mysql.com/doc/refman/8.4/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). Statements that affect mysql database tables are written to the binary log ...This pertains to statements such as INSERT, UPDATE, DELETE, REPLACE, DO, LOAD DATA, SELECT, and TRUNCATE ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-database-objects.html
Some database objects such as tables and indexes have different limitations when using the NDBCLUSTER storage engine: Number of database objects. The maximum number of all NDB database objects in a single NDB Cluster—including databases, tables, ...The maximum number of attributes (that is, columns and indexes) that can belong to a given table is ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-database-structure.html
In your role as a database designer, look for the most efficient way to organize your schemas, tables, and columns. Starting with an efficient database design makes it easier for team members to write high-performing application code, and makes the ...As when tuning application code, you minimize I/O, keep related items together, and plan ahead so that performance stays high as the data volume ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-graphs-database-fileio-lock-wait.html
This chapter describes the Database File I/O and Lock Waits reports. Important The Database File I/O requires the MySQL sys schema, which is supported on MySQL 5.6 and 5.7, only. Note This graph is displayed only if a MySQL instance is selected in ...These reports identify I/O hot spots and lock wait contention in your application using the sys schema, thereby enabling you to tune the performance of your ...