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-programs-ndb-top.html
For measured load, blue is used for execution time, yellow for send time, red for time spent in send buffer full waits, and blank spaces for idle time. The display updates once per second; to set a different delay interval, use --sleep-time (-s).
https://dev.mysql.com/doc/refman/5.7/en/option-modifiers.html
For example, with --maximum-back_log=200, the server produces this error: Maximum value of 'back_log' cannot be set . The --maximum prefix is available for mysqld only and permits a limit to be placed on how large client programs can set session ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-disk-io.html
InnoDB uses asynchronous disk I/O where possible, by creating a number of threads to handle I/O operations, while permitting other database operations to proceed while the I/O is still in progress. On Linux and Windows platforms, InnoDB uses the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-read_ahead.html
A read-ahead request is an I/O request to prefetch multiple pages in the buffer pool asynchronously, in anticipation that these pages are needed soon. InnoDB uses two read-ahead algorithms to improve I/O performance: Linear read-ahead is a ...
https://dev.mysql.com/doc/refman/5.7/en/using-innodb-tables.html
For example, in a table containing information about people, you would not create a primary key on (firstname, lastname) because more than one person can have the same name, a name column may be left blank, and sometimes people change their names.
https://dev.mysql.com/doc/refman/5.7/en/show-triggers.html
This is a TIMESTAMP(2) value (with a fractional part in hundredths of seconds) for triggers created in MySQL 5.7.2 or later, NULL for triggers created prior to 5.7.2. row *************************** Trigger: ins_sum Event: INSERT Table: account ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-generated-columns.html
Adding or dropping a secondary index on a virtual generated column is an in-place operation. For more information, see Section 13.1.18.8, “Secondary Indexes and Generated Columns”. However, later reads from the table might report warnings or ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-sorting.html
total_latency The total wait time of timed occurrences of the statement. last_seen The time at which the statement was most recently seen. The statements_with_sorting and x$statements_with_sorting views have these columns: query The normalized ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-starting.html
This section outlines the procedure for starting NDB Cluster replication using a single replication channel. Start the MySQL replication source server by issuing this command, where id is this server's unique ID (see Section 21.7.2, “General ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-safe.html
mysqld_safe adds some safety features such as restarting the server when an error occurs and logging runtime information to an error log. mysqld_safe tries to use the sleep and date system utilities to determine how many times per second it has ...A ... mysqld_safe is the recommended way to start a mysqld server on ...