PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/myisam-check.html
To check a MyISAM table, use the following commands: myisamchk tbl_name This finds 99.99% of all errors. myisamchk -e tbl_name This does a complete and thorough check of all data (-e means “extended check”). This may take a long time for a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-delete-all.html
In some cases, this can be much faster than DELETE or even TRUNCATE TABLE. Usage ndb_delete_all -c connection_string tbl_name -d db_name This deletes all rows from the table named tbl_name in the database named db_name. --ndb-nodeid Command-Line ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndbmtd.html
This can be done by setting an appropriate value in the config.ini file for the MaxNoOfExecutionThreads configuration parameter or the ThreadConfig configuration parameter. The names of these files have the following pattern: ... ndbmtd is a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-general.html
For example, this means that in the case of a replication setup with two replication channels (to provide an extra channel for redundancy), there should be a total of four replication nodes, two per cluster. Replication of an NDB Cluster as ... A ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-configuration-variables.html
Because the default is to buffer all types of data change operations, only change this setting if you need to reduce the amount of buffering. You might change this setting during periods of unusual activity, then restore it to its original setting.
https://dev.mysql.com/doc/refman/5.7/en/packet-too-large.html
Both the client and the server have their own max_allowed_packet variable, so if you want to handle big packets, you must increase this variable both in the client and in the server. To set a larger value, start mysql like this: $> mysql ... A ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-statements-current-table.html
END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the event ends. This enables you to check the source to determine exactly what code is involved. This value is computed in microseconds ...The table stores one row per thread showing the current status of the thread's most recent monitored statement event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-current-table.html
END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the event ends. This is because immediately after the XA transaction is prepared, it is detached from the replication applier thread, ...The table stores one row per thread showing the current status of the thread's most recent monitored transaction event, so there is no system variable for configuring the table ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-waits-current-table.html
END_EVENT_ID This column is set to NULL when the event starts and updated to the thread current event number when the event ends. This enables you to check the source to determine exactly what code is involved. For example, if a mutex or lock is ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-examples.html
The Performance Schema is a tool to help a DBA do performance tuning by taking real measurements instead of “wild guesses.” This section demonstrates some ways to use the Performance Schema for this purpose. At each iteration, the Performance ...The discussion here relies on the use of event filtering, which is described in Section 25.4.2, “Performance Schema Event ...