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/optimize-benchmarking.html
This section progresses from simple and direct measurement techniques that a single developer can do, to more complicated ones that require additional expertise to perform and interpret the results. To measure performance, consider the following ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-blob.html
Do not use this technique when the entire table is compressed by InnoDB or MyISAM. When storing a large blob containing textual data, consider compressing it first. For a table with several columns, to reduce memory requirements for queries that do ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-logging.html
This option defines the write-ahead block size for the redo log. Consider the following guidelines for optimizing redo logging: Make your redo log files big, even as big as the buffer pool. When InnoDB has written the redo log files full, it must ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-queries.html
When an index contains unnecessary data, the I/O to read this data and memory to cache it reduce the performance and scalability of the server. To tune queries for InnoDB tables, create an appropriate set of indexes on each table. Follow these ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb.html
This section explains how to optimize database operations for InnoDB tables. InnoDB is the storage engine that MySQL customers typically use in production databases where reliability and concurrency are important.
https://dev.mysql.com/doc/refman/5.7/en/out-of-memory.html
This causes it to use the mysql_use_result() C API function to retrieve the result set, which places less of a load on the client (but more on the server). Is it reasonable that it should return so many rows? If not, correct the query and try again.
https://dev.mysql.com/doc/refman/5.7/en/partitioning-columns.html
(This is the same as with partitioning by RANGE and LIST.) Other numeric data types (such as DECIMAL or FLOAT) are not supported as partitioning columns. The next two sections discuss COLUMNS partitioning, which are variants on RANGE and LIST ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-hash-key.html
For that reason, this section addresses the modification of tables partitioned by hash or by key only. Tables which are partitioned by hash or by key are very similar to one another with regard to making changes in a partitioning setup, and both ...
https://dev.mysql.com/doc/refman/5.7/en/password-security-admin.html
Access to this table should never be granted to any nonadministrative accounts. Database administrators should use the following guidelines to keep passwords secure. MySQL stores passwords for user accounts in the mysql.user system table. Account ...
https://dev.mysql.com/doc/refman/5.7/en/password-too-long.html
This occurs when the library provided by the system to read passwords limits password values to a small number of characters (typically eight). That is a problem with the system library, not with MySQL. To work around it, change your MySQL password ...