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/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/creating-spatial-indexes.html
For InnoDB and MyISAM tables, MySQL can create spatial indexes using syntax similar to that for creating regular indexes, but using the SPATIAL keyword. For storage engines that support nonspatial indexing of spatial columns, the engine creates a ...
https://dev.mysql.com/doc/refman/5.7/en/csv-storage-engine.html
The CSV storage engine stores data in text files using comma-separated values format. The CSV storage engine is always compiled into the MySQL server. To examine the source for the CSV engine, look in the storage/csv directory of a MySQL source ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
If you always use many columns when selecting from the table, the first column in the index should be the one with the most duplicates, to obtain better compression of the index. Design your tables to minimize their space on the disk. This can ...
https://dev.mysql.com/doc/refman/5.7/en/diagnostics-area.html
SQL statements produce diagnostic information that populates the diagnostics area. Standard SQL has a diagnostics area stack, containing a diagnostics area for each nested execution context. Standard SQL also supports GET STACKED DIAGNOSTICS syntax ...
https://dev.mysql.com/doc/refman/5.7/en/document-store-setting-up.html
To use MySQL 5.7 as a document store, the X Plugin needs to be installed. Then you can use X Protocol to communicate with the server. Without the X Plugin running, X Protocol clients cannot connect to the server. The X Plugin is supplied with MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/encrypted-connections.html
The tls_version system variable on the server side and --tls-version option on the client side enable the level of support to be selected. With an unencrypted connection between the MySQL client and the server, someone with access to the network ...
https://dev.mysql.com/doc/refman/5.7/en/error-log.html
For information about selecting the error message character set and language, see Section 10.6, “Error Message Character Set”, and Section 10.12, “Setting the Error Message Language”. This section discusses how to configure the MySQL server ...
https://dev.mysql.com/doc/refman/5.7/en/error-message-language.html
To select the language in which the server writes error messages, follow the instructions in this section. By default, mysqld produces error messages in English, but they can be displayed instead in any of several other languages: Czech, Danish, ...
https://dev.mysql.com/doc/refman/5.7/en/events-configuration.html
Events are executed by a special event scheduler thread; when we refer to the Event Scheduler, we actually refer to this thread. When running, the event scheduler thread and its current state can be seen by users having the PROCESS privilege in the ...