Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-benchmarking.html
Since changing the default storage engine only affects newly created tables, run your application installation and setup steps to confirm that everything installs properly, then exercise the application features to make sure the data loading, ...If ... If InnoDB is not the default storage engine, you can determine if your database server and applications work correctly with InnoDB by restarting the server with --default-storage-engine=InnoDB defined on the command line or with default-storage-engine=innodb defined in the [mysqld] section of the MySQL server option ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-transaction-isolation-levels.html
InnoDB offers all four transaction isolation levels described by the SQL:1992 standard: READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE. You can enforce a high degree of consistency with the default REPEATABLE READ level, for ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-queries.html
To tune queries for InnoDB tables, create an appropriate set of indexes on each table. If you have many queries for the same table, testing different combinations of columns, try to create a small number of concatenated indexes rather than a large ...Follow these guidelines for InnoDB indexes: Because each InnoDB table has a primary key (whether you request one or not), specify a set of primary key columns for each table, columns that are used in the most important and time-critical ...
https://dev.mysql.com/doc/refman/8.4/en/scalar-subqueries.html
The preceding query can also be written like this, using TABLE: SELECT (TABLE t2) FROM t1; A scalar subquery can be part of an expression, but remember the parentheses, even if the subquery is an operand that provides an argument for a function. For ... In its simplest form, a subquery is a scalar subquery that returns a single ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-backup-restore-fewer-data-nodes.html
The backup cluster command also creates a logical backup for the metadata of the NDB tables (see Logical Backup for NDB Table Metadata, for details). The process starts with creating a backup for the original cluster using the backup cluster command. Next, create a new cluster with fewer data nodes using the create cluster ... Sometimes, you want to transfer data from your cluster to another one that has fewer data nodes—for example, when you want to scale ...
https://dev.mysql.com/doc/connectors/en/connector-j-usagenotes-spring-config-transactional.html
The downloaded script explicitly creates MyISAM tables, which do not support transactional semantics. To use transactional database access, we will need to change the storage engine of the tables in the world database. ALTER TABLE City ... Spring ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mysql-process-discovery-advisor-ref.html
Admin User The root user of the instance, or a user that has the SUPER, CREATE, and INSERT privileges on the schema in which the inventory table is created. The inventory table stores unique identifiers for the instance, and is created in the mysql ... The MySQL Process Discovery Advisor enables you to find and, optionally, establish a connection with unmonitored MySQL ...If you choose not to attempt a ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-transactional.html
The downloaded script explicitly creates MyISAM tables, which do not support transactional semantics. To use transactional database access, we will need to change the storage engine of the tables in the world database. ALTER TABLE City ... Spring ...
https://dev.mysql.com/doc/refman/8.4/en/copying-databases.html
In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. Note If GTIDs are in use on the server where you create the dump (gtid_mode=ON), by default, mysqldump ...You can then transfer the file to the other machine and feed it as input to the mysql ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-usagenotes-apptips-microsoft-access.html
Include a TIMESTAMP column in all tables that you want to be able to update. Include a primary key in each MySQL table you want to use with Access. If you are using Connector/ODBC to link to a table that has a BIGINT column, the results are ... To ...