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/event-scheduler-thread-states.html
Waiting for scheduler to stop The thread issued SET GLOBAL event_scheduler=OFF and is waiting for the scheduler to stop. These states occur for the Event Scheduler thread, threads that are created to execute scheduled events, or threads that ...
https://dev.mysql.com/doc/refman/5.7/en/fetch.html
To detect this condition, you can set up a handler for it (or for a NOT FOUND condition). This statement fetches the next row for the SELECT statement associated with the specified cursor (which must be open), and advances the cursor pointer. If a ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog-server-id.html
You can use mysqlbinlog to request log files from a server in several ways: Specify an explicitly named set of files: For each file, mysqlbinlog connects and issues a Binlog dump command. Specify the beginning file and --to-last-log: mysqlbinlog ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-table.html
The maximum number of retries for a given transaction is set by the slave_transaction_retries system variable. The table provides information about general aspects of transaction applier status that are not specific to any thread involved. This ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-troubleshooting.html
You should check that there is enough memory allocated for the backup. Important If you have set BackupDataBufferSize and BackupLogBufferSize and their sum is greater than 4MB, then you must also set BackupMemory as well. This is due to the fact ...
https://dev.mysql.com/doc/refman/5.7/en/primary-key-optimization.html
The primary key for a table represents the column or set of columns that you use in your most vital queries. Query performance benefits from the NOT NULL optimization, because it cannot include any NULL values. If your table is big and important, ...With the InnoDB storage engine, the table data is physically organized to do ultra-fast lookups and sorts based on the primary key column or ...
https://dev.mysql.com/doc/refman/5.7/en/alter-logfile-group.html
This includes any default value implied for this option by the setting of the InitialLogFileGroup data node configuration parameter. For example, you cannot have a tablespace and an undo log file with the same name, or an undo log file and a data ...
https://dev.mysql.com/doc/refman/5.7/en/analyze-table.html
In the few cases that ANALYZE TABLE does not produce values good enough for your particular tables, you can use FORCE INDEX with your queries to force the use of a particular index, or set the max_seeks_for_key system variable to ensure that MySQL ...ANALYZE TABLE performs a key distribution analysis and stores the distribution for the named table or ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-comments.html
Standard SQL uses the C syntax /* this is a comment */ for comments, and MySQL Server supports this syntax as well. In this case, the generated statement looks like this: UPDATE account SET balance=balance--1 WHERE account_id=5752; balance--1 is ...
https://dev.mysql.com/doc/refman/5.7/en/column-indexes.html
For example: CREATE TABLE test (blob_col BLOB, INDEX(blob_col(10))); Prefixes can be up to 1000 bytes long (767 bytes for InnoDB tables, unless you have innodb_large_prefix set). Take this into account when specifying a prefix length for a nonbinary ... The most common type of index involves a single column, storing copies of the values from that column in a data structure, allowing fast lookups for the rows with the corresponding column ...