PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-error-reporter.html
It is highly recommended that you make use of this utility when filing reports of bugs in NDB Cluster. ndb_error_reporter also accepts the options listed here: --connection-timeout=timeout Command-Line Format --connection-timeout=# Type Integer ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installation-windows-path.html
Dismiss this dialogue, and each dialogue in turn, by clicking OK until all of the dialogues that were opened have been dismissed. This includes the servers, the mysql client, and all MySQL command-line utilities such as mysqladmin and mysqldump.
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-delimited-text.html
This section describes how to use mysqldump to create delimited-text dump files. INTO OUTFILE to write the files, so you must have the FILE privilege to perform this operation, and an error occurs if a given .txt file already exists. But this ...
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-sql-format.html
This section describes how to use mysqldump to create SQL-format dump files. Without this option, mysqldump treats the first name as a database name and those following as table names. This ensures that when the dump file is reloaded, it creates ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-overview.html
Does each table use an appropriate row format? This choice also depends on the storage engine used for the table. With modern disks, the mean time for this is usually lower than 10ms, so we can in theory do about 100 seeks a second. This time ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-bulk-data-loading.html
SET unique_checks=1; For big tables, this saves a lot of disk I/O because InnoDB can use its change buffer to write secondary index records in a batch. SET foreign_key_checks=1; For big tables, this can save a lot of disk I/O. Use the multiple-row ... These performance tips supplement the general guidelines for fast inserts in Section 8.2.4.1, “Optimizing INSERT ...
https://dev.mysql.com/doc/refman/5.7/en/password-logging.html
For security reasons, this option is not recommended for production use. For security reasons, this file should be written to a directory accessible only to the MySQL server and users with a legitimate reason to view the log. In this case, the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-socket-instances-table.html
Information available in this table provides a real-time snapshot of the active connections to the server. row *************************** EVENT_NAME: wait/io/socket/sql/server_tcpip_socket OBJECT_INSTANCE_BEGIN: 4316699040 THREAD_ID: 1 SOCKET_ID: ... The socket_instances table provides a real-time snapshot of the active connections to the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-variable-tables.html
An application that wants only global values should use this table. An application that wants all status variable values for its own session should use this table. An application that wants to know the session variable values for specific sessions ... Note The value of the show_compatibility_56 system variable affects the information available from the tables described ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-tables.html
Use this instrument to enable or disable collection of individual transaction event classes. There are subtle implications to this approach: Transaction events in the Performance Schema do not fully include the statement events associated with the ...Within the event hierarchy, wait events nest within stage events, which nest within statement events, which nest within transaction ...