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/partitioning-overview.html
Important Partitioning applies to all data and indexes of a table; you cannot partition only the data and not the indexes, or vice versa, nor can you partition only a portion of the table. This section provides a conceptual overview of partitioning ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html
It is important to remember—regardless of the type of partitioning that you use—that partitions are always numbered automatically and in sequence when created, starting with 0. This section discusses the types of partitioning which are ...
https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
(However, permitting connections by old clients is not recommended and should be avoided if possible.) This information is of particular importance to PHP programmers migrating MySQL databases from versions older than 4.1 to 4.1 or higher. Note The ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-examples.html
The mutex_instances.LOCKED_BY_THREAD_ID and rwlock_instances.WRITE_LOCKED_BY_THREAD_ID columns are extremely important for investigating performance bottlenecks or deadlocks. The Performance Schema is a tool to help a DBA do performance tuning by ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instance-tables.html
The mutex_instances.LOCKED_BY_THREAD_ID and rwlock_instances.WRITE_LOCKED_BY_THREAD_ID columns are extremely important for investigating performance bottlenecks or deadlocks. They provide event names and explanatory notes or status information: ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
Important For thread information sources other than the threads table, information about threads for other users is shown only if the current user has the PROCESS privilege. The threads table contains a row for each server thread. Each row contains ...
https://dev.mysql.com/doc/refman/5.7/en/perl-installation.html
Change location into the top-level directory of the unpacked distribution: $> cd DBI-VERSION Build the distribution and compile everything: $> perl Makefile.PL $> make $> make test $> make install The make test command is important because it ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication.html
When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the appropriate account row from the mysql.user system table. The server then authenticates the client, determining from ...
https://dev.mysql.com/doc/refman/5.7/en/primary-key-optimization.html
If your table is big and important, but does not have an obvious column or set of columns to use as a primary key, you might create a separate column with auto-increment values to use as the primary key. The primary key for a table represents the ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
Important Some MySQL releases introduce changes to the grant tables to add new privileges or features. The privileges granted to a MySQL account determine which operations the account can perform. MySQL privileges differ in the contexts in which ...