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/creating-many-tables.html
If you execute SELECT statements on many different tables, there is a little overhead when the table cache is full, because for every table that has to be opened, another must be closed. If you have many MyISAM tables in the same database ...
https://dev.mysql.com/doc/refman/5.7/en/obtaining-loadable-function-information.html
dl The name of the function library file containing the executable function code. The mysql.func system table shows which loadable functions have been registered using CREATE FUNCTION: SELECT * FROM mysql.func; The func table has these columns: ...
https://dev.mysql.com/doc/refman/5.7/en/example-auto-increment.html
Use the smallest integer data type for the AUTO_INCREMENT column that is large enough to hold the maximum sequence value you need. For example, if you use TINYINT, the maximum permissible sequence number is 127. MyISAM Notes For MyISAM tables, you ...You can also explicitly assign 0 to the column to generate sequence numbers, unless the NO_AUTO_VALUE_ON_ZERO SQL mode is ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-ngram.html
Full-text-related configuration options, except for minimum and maximum word length options (innodb_ft_min_token_size, innodb_ft_max_token_size, ft_min_word_len, ft_max_word_len) are also applicable. ngram token size is configurable using the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-server.html
By default, these are latin1 and latin1_swedish_ci, but they can be set explicitly at server startup on the command line or in an option file and changed at runtime. MySQL Server has a server character set and a server collation. Initially, the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync-installation.html
On the source: [mysqld] rpl_semi_sync_master_enabled=1 rpl_semi_sync_master_timeout=1000 # 1 second On each replica: [mysqld] rpl_semi_sync_slave_enabled=1 . For example: mysql> SELECT PLUGIN_NAME, PLUGIN_STATUS FROM INFORMATION_SCHEMA.PLUGINS WHERE ... Semisynchronous replication is implemented using plugins, so the plugins must be installed into the server to make them ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-windows-binary.html
For this example, we refer to ndbd.exe as the data node executable, but you can install ndbmtd.exe, the multithreaded version of this program, instead, in exactly the same way. Note As with other Windows programs, NDB Cluster executables are named ...You should also have the MySQL client (mysql.exe) on this ...
https://dev.mysql.com/doc/refman/5.7/en/monitoring-performance-schema.html
You can query the tables in the performance_schema database to see real-time information about the performance characteristics of your server and the applications it is running.
https://dev.mysql.com/doc/refman/5.7/en/verifying-package-integrity.html
If you notice that the MD5 checksum or GPG signatures do not match, first try to download the respective package one more time, perhaps from another mirror site. After downloading the MySQL package that suits your needs and before attempting to ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html
If an attempted runtime assignment to keyring_encrypted_file_data results in an error, the variable value remains unchanged. If an attempted runtime assignment to keyring_file_data results in an error, the variable value remains unchanged. If an ...