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/innodb-statistics-estimation.html
Configuring the Number of Sampled Pages The MySQL query optimizer uses estimated statistics about key distributions to choose the indexes for an execution plan, based on the relative selectivity of the index. Optimizer statistics are not persisted ...
https://dev.mysql.com/doc/refman/5.7/en/installing-mysql-shell-linux-quick.html
This is an example of the subrepository's default entry in the file (the baseurl entry in your file might look different, depending on your Linux distribution): [mysql-tools-preview] name=MySQL Tools Preview ... Note Installation packages for MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/internal-locking.html
This section discusses internal locking; that is, locking performed within the MySQL server itself to manage contention for table contents by multiple sessions. This type of locking is internal because it is performed entirely by the server and ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-rpm.html
An SSL certificate and key files are generated in the data directory. The recommended way to install MySQL on RPM-based Linux distributions is by using the RPM packages provided by Oracle. There are two sources for obtaining them, for the Community ...
https://dev.mysql.com/doc/refman/5.7/en/memory-use.html
MySQL allocates buffers and caches to improve performance of database operations. The default configuration is designed to permit a MySQL server to start on a virtual machine that has approximately 512MB of RAM. You can improve MySQL performance by ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-column-indexes.html
MySQL can create composite indexes (that is, indexes on multiple columns). For certain data types, you can index a prefix of the column (see Section 8.3.4, “Column Indexes”). MySQL can use multiple-column indexes for queries that test all the ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-crash-recovery.html
In this case, myisamchk does not abort on some errors (such as duplicate-key errors) but instead tries to resolve them by modifying the .MYD file. This section describes how to check for and deal with data corruption in MySQL databases. If your ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-ftdump.html
Example: Suppose that the test database contains a table named mytexttable that has the following definition: CREATE TABLE mytexttable ( id INT NOT NULL, txt TEXT NOT NULL, PRIMARY KEY (id), FULLTEXT (txt) ) ENGINE=MyISAM; The index on id is index 0 ...It reads the MyISAM index file directly, so it must be run on the server host where the table is ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html
Note If you want a repair operation to go much faster, you should set the values of the sort_buffer_size and key_buffer_size variables each to about 25% of your available memory when running myisamchk. The discussion in this section describes how ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-linux-source.html
Building NDB Cluster from source is similar to building the standard MySQL Server, although it differs in a few key respects discussed here. This section provides information about compiling NDB Cluster on Linux and other Unix-like platforms. For ...