Search Results
https://dev.mysql.com/doc/refman/8.4/en/internal-locking.html
If transactions modify or lock more than one table, issue the applicable statements in the same order within each transaction. These storage engines avoid deadlocks by always requesting all needed locks at once at the beginning of a query and always ... This section discusses internal locking; that is, locking performed within the MySQL server itself to manage contention for table contents by multiple ...
https://dev.mysql.com/doc/refman/8.4/en/load-data.html
The file can be read from the server host or the client host, depending on whether the LOCAL modifier is given. INTO Statement”.) To write data from a table to a file, use SELECT ... To read the file back into a table, use LOAD DATA. The syntax of ...
https://dev.mysql.com/doc/refman/8.4/en/loading-tables.html
You could create a text file pet.txt containing one record per line, with values separated by tabs, and given in the order in which the columns were listed in the CREATE TABLE statement. In its simplest form, you supply values for each column, in ...
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
Also, if it is important that locks are granted in a certain order, be aware that result set order may differ depending on which execution plan the optimizer chooses. MySQL distributions provide a locking interface that is accessible at two levels: ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-optimization.html
This improves join performance by enabling the join optimizer to better choose the order in which to join the tables and which indexes it should use. This makes your data much more localized and may speed up range-based SELECT and ORDER BY ... To ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk-repair-options.html
--safe-recover, -o Command-Line Format --safe-recover Do a repair using an old recovery method that reads through all rows in order and updates all index trees based on the rows found. This is an order of magnitude slower than --recover, but can ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk.html
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). You can also use the CHECK TABLE and ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-example-data.html
mysqli_connect_error()); $query = "SELECT Name, Population FROM City ORDER BY Population DESC LIMIT 5"; # if no errors... if( $result = $link->query($query) ) { ?> <table border="1" width="40%" cellpadding="4" cellspacing ="1"> <tbody> <tr> <th ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-limits.html
For example, the maximum number of ordered indexes in the cluster is determined by MaxNoOfOrderedIndexes, and the maximum number of ordered indexes per table is 16. In this section, we list limits found in NDB Cluster that either differ from limits ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-config-values.html
The config_values table provides information about the current state of node configuration parameter values. Each row in the table corresponds to the current value of a parameter on a given node. The config_values table contains the following ...