PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/optimization.html
Depending on your job role (developer, DBA, or a combination of both), you might optimize at the level of individual SQL statements, entire applications, a single database server, or multiple networked database servers. Optimizing CPU and memory ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-diskio.html
If you follow best practices for database design and tuning techniques for SQL operations, but your database is still slow due to heavy disk I/O activity, consider these disk I/O optimizations. If database write performance is an issue, conduct ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-transaction-management.html
The default MySQL setting AUTOCOMMIT=1 can impose performance limitations on a busy database server. InnoDB must flush the log to disk at each transaction commit if that transaction made modifications to the database. Killing the database process ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
EXCHANGE PARTITION operation does not perform row-by-row validation when exchanging a partition a nonpartitioned table, allowing database administrators to assume responsibility for ensuring that rows are within the boundaries of the partition ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-types.html
A very common use of database partitioning is to segregate data by date. Some database systems support explicit date partitioning, which MySQL does not implement in 5.7. Names of partitions generally follow the rules governing other MySQL ... This ...
https://dev.mysql.com/doc/refman/5.7/en/password-hashing.html
MySQL lists user accounts in the user table of the mysql database. (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 ... Note The information in this section applies fully only before MySQL 5.7.5, and only for accounts that use the mysql_native_password or mysql_old_password authentication ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema.html
It is implemented using the PERFORMANCE_SCHEMA storage engine and the performance_schema database. Performance Schema configuration can be modified dynamically by updating tables in the performance_schema database through SQL statements. The MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-storage-overview.html
The MySQL pluggable storage engine architecture enables a database professional to select a specialized storage engine for a particular application need while being completely shielded from the need to manage any specific application coding ...The ...
https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery-positions.html
Find the precise binary log event position corresponding to the point in time up to which you want to restore your database. Your database has now been restored to the point-in-time of interest, tp, right before the table pets.cats was dropped. The ...
https://dev.mysql.com/doc/refman/5.7/en/privilege-changes.html
Database privilege changes take effect the next time the client executes a USE db_name statement. Note Client applications may cache the database name; thus, this effect may not be visible to them without actually changing to a different database.