PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-log-statistics.html
This is the number of 32-bit data words received in the last reporting interval for primary key operations using this TC as the transaction coordinator. For inserts and updates, this is proportional to the number of columns written, and the size of ... The NDB management client's CLUSTERLOG STATISTICS command can provide a number of useful statistics in its ...Because some transactions committed in this reporting interval ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-memory.html
This space must be available on the same file system as the original data file, as the copy is created in the same directory as the original. This space must be available on the same file system as the original data file. When performing repair ...
https://dev.mysql.com/doc/refman/8.0/en/internal-locking.html
Deadlocks affect performance rather than representing a serious error, because InnoDB automatically detects deadlock conditions by default and rolls back one of the affected transactions. The tradeoff is that this strategy reduces concurrency; other ...For locking performed on MySQL files by other programs, see Section 10.11.5, “External ... This section discusses internal locking; that is, locking ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-drop-table.html
--core-file Command-Line Format --core-file Removed 8.0.31 Write core file on error; used in debugging. --database, -d Command-Line Format --database=name Type String Default Value TEST_DB Name of the database in which the table resides. Usage ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-preparation.html
ndb-connectstring=management_host[:port] In the event that you are not using NDB Cluster on the replica, you can create a backup with this command on the source: shellS> mysqldump --master-data=1 Then import the resulting data dump onto the replica ...To provide replication backup capability, you also need to add an --ndb-connectstring option to the replica's my.cnf file prior to starting the replication ... Preparing the NDB Cluster for ...
https://dev.mysql.com/doc/refman/8.0/en/problems-with-alias.html
In the select list of a query, a quoted column alias can be specified using identifier or string quoting characters: SELECT 1 AS `one`, 2 AS 'two'; Elsewhere in the statement, quoted references to the alias must use identifier quoting or the ...This ... An alias can be used in a query select list to give a column a different ...
https://dev.mysql.com/doc/refman/8.0/en/option-defaults-equals.html
080111 22:53:32 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var 080111 22:53:34 mysqld_safe mysqld from pid file /usr/local/mysql/var/tonfisk.pid ended [1]+ Done ./mysqld_safe --log-error my-errors The server attempted to ...080112 12:53:40 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql/var $> After shutting down the server, restart it as follows: $> mysqld_safe --log-error & [1] 11699 $> 080112 12:53:40 mysqld_safe Logging to ...
https://dev.mysql.com/doc/refman/8.0/en/table-size-limit.html
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits. For example, you are using MyISAM tables on an operating system that supports files only up to ...For up-to-date information operating system file size limits, refer to the documentation specific to your operating ...
https://dev.mysql.com/doc/refman/8.0/en/column-count-limit.html
The maximum row size for an InnoDB table, which applies to data stored locally within a database page, is slightly less than half a page for 4KB, 8KB, 16KB, and 32KB innodb_page_size settings. InnoDB restricts row size (for data stored locally ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-monitoring.html
For example, if you do not care about performance data for file I/O, you can start the server with all Performance Schema parameters related to file I/O set to 0. The mutex still functions as a synchronization object (that is, the server continues ...Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type xxx could not be ...