PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cpustat.html
The cpustat table provides per-thread CPU statistics gathered each second, for each thread running in the NDB kernel.
https://dev.mysql.com/doc/refman/5.7/en/innodb-online-ddl-failure-conditions.html
The operation takes a long time and concurrent DML modifies the table so much that the size of the temporary online log exceeds the value of the innodb_online_alter_log_max_size configuration option. A timeout occurs while waiting for an exclusive ... The failure of an online DDL operation is typically due to one of the following conditions: An ALGORITHM clause specifies an algorithm that is not compatible with the particular type of DDL operation or storage ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-introduction.html
InnoDB is a general-purpose storage engine that balances high reliability and high performance. Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. Key ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-disk-data.html
Disk data objects are subject to the following maximums and minimums: Maximum number of tablespaces: 232 (4294967296) Maximum number of data files per tablespace: 216 (65536) The minimum and maximum possible sizes of extents for tablespace data ...
https://dev.mysql.com/doc/refman/5.7/en/program-options.html
This is common for options that you want the program to use each time it runs. This method is useful for options that you want to apply each time the program runs. Options are processed in order, so if an option is specified multiple times, the last ... There are several ways to specify options for MySQL programs: List the options on the command line following the program ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-sys-tablespaces-table.html
FILE_SIZE The apparent size of the file, which represents the maximum size of the file, uncompressed. The INNODB_SYS_TABLESPACES table provides metadata about InnoDB file-per-table and general tablespaces, equivalent to the information in the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-wait-tables.html
The Performance Schema instruments waits, which are events that take time. The setup_timers table contains a row with a NAME value of wait that indicates the unit for wait event timing. Within the event hierarchy, wait events nest within stage ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-processlist-table.html
row *************************** ID: 10 USER: me HOST: localhost:58834 DB: test COMMAND: Query TIME: 0 STATE: executing INFO: SELECT * FROM performance_schema.processlist ... See Section 5.1.9, “Server Status Variables” TIME The time in seconds ...The MySQL process list indicates the operations currently being performed by the set of threads executing within the ... Note ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-compression-oltp.html
The rise of SSD storage devices, which are fast but relatively small and expensive, makes compression attractive also for OLTP workloads: high-traffic, interactive websites can reduce their storage requirements and their I/O operations per second ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-connection-status-table.html
LAST_ERROR_TIMESTAMP A timestamp in YYMMDD hh:mm:ss format that shows when the most recent I/O error took place. replication_connection_status Column SHOW SLAVE STATUS Column SOURCE_UUID Master_UUID THREAD_ID None SERVICE_STATE Slave_IO_Running ...