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/sys-ps-setup-show-enabled.html
Displays all currently enabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display enabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display enabled threads. Example mysql> ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-use-cases.html
Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of servers. Depending on the number of servers which fail the group might have degraded performance or scalability, but it is ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-key-column-usage-table.html
CONSTRAINT_SCHEMA The name of the schema (database) to which the constraint belongs. TABLE_SCHEMA The name of the schema (database) to which the table belongs. If the constraint is a foreign key, then this is the column of the foreign key, not the ...The KEY_COLUMN_USAGE table has these columns: CONSTRAINT_CATALOG The name of the catalog to which the constraint ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-crash-recovery.html
This section describes how to check for and deal with data corruption in MySQL databases. When performing crash recovery, it is important to understand that each MyISAM table tbl_name in a database corresponds to the three files in the database ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups.html
There are therefore two choices: If you are using replication as a solution to enable you to back up the data on the source, and the size of your database is not too large, the mysqldump tool may be suitable. For larger databases, where mysqldump ...
https://dev.mysql.com/doc/refman/5.7/en/begin-end.html
END syntax is used for writing compound statements, which can appear within stored programs (stored procedures and functions, triggers, and events). Changing the ; end-of-statement delimiter (for example, to //) permit ; to be used in a program body. This means that no transactional savepoint is set at the start of the instruction block and the BEGIN clause used in this context has no effect on the current ...
https://dev.mysql.com/doc/refman/5.7/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/5.7/en/error-lost-connection.html
Sometimes the “during query” form happens when millions of rows are being sent as part of one or more queries. If you know that this is happening, you should try increasing net_read_timeout from its default of 30 seconds to 60 seconds or longer, ...Usually it indicates network connectivity trouble and you should check the condition of your network if this error occurs ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-server-config.html
The MySQL server listens on a single network socket for TCP/IP connections. This socket is bound to a single address, but it is possible for an address to map onto multiple network interfaces. To specify an address, set bind_address=addr at server ...
https://dev.mysql.com/doc/refman/5.7/en/key-cache-block-size.html
But setting the size of key nodes equal to the size of the I/O buffer does not always ensure the best overall performance. It is possible to specify the size of the block buffers for an individual key cache using the key_cache_block_size variable.