Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-autocommit-commit-rollback.html
$> mysql test mysql> CREATE TABLE customer (a INT, b CHAR (20), INDEX (a)); Query OK, 0 rows affected (0.00 sec) mysql> -- Do a transaction with autocommit turned on. If autocommit mode is enabled, each SQL statement forms a single transaction on ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlocks.html
FOR UPDATE) in each transaction; create indexes on the columns used in SELECT ... To view the last deadlock in an InnoDB user transaction, use SHOW ENGINE INNODB STATUS. A deadlock is a situation in which multiple transactions are unable to proceed ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-statistics-estimation.html
Optimizer statistics are not persisted to disk when innodb_stats_persistent=OFF or when individual tables are created or altered with STATS_PERSISTENT=0. The auto-rehash feature enables automatic name completion of database, table, and column names ...Instead, statistics are stored in memory, and are lost when the server is shut ...
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-pkg.html
Define a password for the root user, and also toggle whether MySQL Server should start after the configuration step is complete. Note The macOS installation process does not create nor install a sample my.cnf MySQL configuration file. The package ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-servers.html
Or you might want to give different users access to different mysqld servers that they manage themselves. To achieve better performance, you can specify the following option differently for each server, to spread the load between several physical ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-batch-commands.html
To do so, create a text file text_file that contains the statements you wish to execute. file_name Sometimes you may want your script to display progress information to the user. The mysql client typically is used interactively, like this: mysql ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-linux-source.html
If you compile MySQL with clustering support, and perform the default installation (using make install as the system root user), mysqld is placed in /usr/local/mysql/bin. In Section 25.3.3, “Initial Configuration of NDB Cluster”, we create ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-windows-source.html
Oracle provides precompiled NDB Cluster binaries for Windows which should be adequate for most users. Once the build process is complete, you can create a Zip archive containing the compiled binaries; Section 2.8.4, “Installing MySQL Using a ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-management.html
See Section 25.6.8.2, “Using The NDB Cluster Management Client to Create a Backup”, for more information. Managing an NDB Cluster involves a number of tasks, the first of which is to configure and start NDB Cluster. This is covered in Section ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-locks-per-fragment.html
This table also shows the total time spent waiting for locks successfully and unsuccessfully since fragment or table creation, or since the most recent restart. The values shown in all of the columns ex_req, ex_req_imm_ok, ex_wait_ok, ex_wait_fail, ... The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and ...