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/linux-installation-sles-repo.html
A password for the superuser is set and stored in the error log file. The MySQL SLES repository provides RPM packages for installing and managing the MySQL server, client, and other components on SUSE Enterprise Linux Server. Adding the MySQL SLES ...
https://dev.mysql.com/doc/refman/8.4/en/linux-installation-yum-repo.html
A password for the superuser is set and stored in the error log file. Before You Start As a popular, open-source software, MySQL, in its original or re-packaged form, is widely installed on many systems from various sources, including different ...
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 ...