Search Results
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/replication-options-replica.html
--replicate-do-db=db_name Command-Line Format --replicate-do-db=name Type String Creates a replication filter using the name of a database. Tell the replication SQL thread to restrict replication to statements where the default database (that is, ...
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 ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/dashboard-overview-database-availability-ref.html
The Database Availability statistics show an aggregate of availability statistics, generated by the MySQL Availability Advisor, for all MySQL Instances within the selected group, and allows you to monitor your availability. Database Availability is ...Note The MySQL Availability Advisor must be enabled for this functionality to ...
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. These reports identify I/O hot spots and lock wait contention in your ...
https://dev.mysql.com/doc/refman/8.4/en/database-count-limit.html
The underlying file system may have a limit on the number of directories. The underlying file system may have a limit on the number of files that represent tables.
https://dev.mysql.com/doc/refman/8.4/en/mysqldump-copying-database.html
$> mysqldump db1 > dump.sql $> mysqladmin create db2 $> mysql db2 < dump.sql Do not use --databases on the mysqldump command line because that causes USE db1 to be included in the dump file, which overrides the effect of naming db2 on the mysql ...
https://dev.mysql.com/doc/connectors/en/connector-net-entityframework-core-scaffold-example.html
Scaffolding a database produces an Entity Framework model from an existing database. The resulting entities are created and mapped to the tables in the specified database. There are two different ways to scaffold an existing database: Scaffolding a ...For an overview of the requirements to use EF Core with MySQL, see Table 4.3, “Connector/NET Versions and Entity Framework Core ...