Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/database-connection-example.html
Applications that use Session objects by default can be deployed on both single server setups and database clusters with no code changes. The code that is needed to connect to a MySQL document store looks a lot like the traditional MySQL connection ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-genai-database-llms.html
MySQL HeatWave GenAI In-Database LLMs 14.2.2 MySQL HeatWave GenAI In-Database LLMs MySQL HeatWave GenAI supports LLMs hosted and executed within the database. When in-database LLMs are used, data does not leave your MySQL HeatWave Cluster, which ...
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/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/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/privileges-provided.html
DROP Enables use of statements that drop (remove) existing databases, tables, and views. This also means that database objects created by users with the SYSTEM_USER privilege cannot be modified or dropped by users without the privilege. DROP for the ...These privileges are global because they are not specific to a particular ... The ...
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 ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-connections-pages-database-processes.html
Table 3.1 Database Processes Dashboard Name Description Thread ID The thread ID. Database The default database for the thread, or NULL if there is none. Important This report retrieves data from the processlist view of the sys schema. If the sys ...
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 ...