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/procedure-analyse.html
The arguments are optional and are used as follows: max_elements (default 256) is the maximum number of distinct values that ANALYSE() notices per column. max_memory (default 8192) is the maximum amount of memory that ANALYSE() should allocate per ... ANALYSE([max_elements[,max_memory]]) Note PROCEDURE ANALYSE() is deprecated as of MySQL 5.7.18, and is removed in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/setting-environment-variables.html
For csh and tcsh, use setenv to make the shell variable available to the environment: setenv MYSQL_TCP_PORT 3306 The commands to set environment variables can be executed at your command prompt to take effect immediately, but the settings persist ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
gtid_executed_compression_period Command-Line Format --gtid-executed-compression-period=# System Variable gtid_executed_compression_period Scope Global Dynamic Yes Type Integer Default Value 1000 Minimum Value 0 Maximum Value 4294967295 Compress the ...The set of transactions that can be found in the binary logs at any given time is equal to GTID_SUBTRACT(@@GLOBAL.gtid_executed, @@GLOBAL.gtid_purged); that is, to all transactions in the binary log that have not yet been ...
https://dev.mysql.com/doc/refman/5.7/en/show-plugins.html
row *************************** Name: binlog Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL *************************** 2. row *************************** Name: CSV Status: ACTIVE Type: STORAGE ENGINE Library: NULL License: GPL ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-fine-tuning.html
Most full-text variables described in this section must be set at server startup time. Note Minimum and maximum word length full-text parameters do not apply to FULLTEXT indexes created using the ngram parser. The innodb_ft_num_word_optimize option ...You can exert more control over full-text searching behavior if you have a MySQL source distribution because some changes require source code ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-server-clients.html
If you normally use a specific socket file or port number, you can place commands to set these environment variables in your .login file so that they apply each time you log in. Start the client with --protocol=TCP to connect using TCP/IP, ...
https://dev.mysql.com/doc/refman/5.7/en/external-locking.html
If the server is run with external locking enabled, you can use myisamchk at any time for read operations such a checking tables. External locking affects server performance because the server must sometimes wait for other processes before it can ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-logs-cluster-log.html
LCPFragmentCompleted Checkpoint 11 INFO Node node_id: ACC Blocked num_1 and TUP Blocked num_2 times last second Undo logging is blocked because the log buffer is close to overflowing. [Occurred during startphase start_phase.] [ Initiated by signal.] ... The following table lists the most common NDB cluster log ...
https://dev.mysql.com/doc/refman/5.7/en/reset-master.html
RESET MASTER Warning Use this statement with caution to ensure you do not lose any wanted binary log file data and GTID execution history. For a server where GTIDs are in use (gtid_mode is ON), issuing RESET MASTER resets the GTID execution history. The value of the gtid_purged system variable is set to an empty string (''), the global value (but not the session value) of the gtid_executed system variable is set to an empty string, and the mysql.gtid_executed table is cleared (see mysql.gtid_executed ...
https://dev.mysql.com/doc/refman/5.7/en/history.html
We started out with the intention of using the mSQL database system to connect to our tables using our own fast low-level (ISAM) routines. However, after some testing, we came to the conclusion that mSQL was not fast enough or flexible enough for ...