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-online-ddl-single-multi.html
If the specific changes were different each time, you might have to construct a new complex ALTER TABLE for each slightly different scenario. Before the introduction of online DDL, it was common practice to combine many DDL operations into a single ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-disk-management.html
Sometimes, I/O is postponed until the database is not busy, or until everything needs to be brought to a consistent state, such as during a database restart after a fast shutdown. As a DBA, you must manage disk I/O to keep the I/O subsystem from ...
https://dev.mysql.com/doc/refman/5.7/en/sys-memory-global-by-current-bytes.html
These views summarize memory use, grouped by allocation type (that is, by event). By default, rows are sorted by descending amount of memory used. The memory_global_by_current_bytes and x$memory_global_by_current_bytes views have these columns: ...
https://dev.mysql.com/doc/refman/5.7/en/packet-too-large.html
When a MySQL client or the mysqld server receives a packet bigger than max_allowed_packet bytes, it issues an ER_NET_PACKET_TOO_LARGE error and closes the connection. With some clients, you may also get a Lost connection to MySQL server during query ... A communication packet is a single SQL statement sent to the MySQL server, a single row that is sent to the client, or a binary log event sent from a replication source server to a ...
https://dev.mysql.com/doc/refman/5.7/en/windows-and-ssh.html
Save everything; otherwise you must to redo it the next time. This section describes how to get an encrypted connection to a remote MySQL server with SSH. This userid value might not be the same as the user name of your MySQL account. Either do a ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-engines-table.html
In the latter case, the error log should contain a reason indicating why the option is disabled. This is particularly useful for checking whether a storage engine is supported, or to see what the default engine is. The ENGINES table has these ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-performance.html
If necessary, you can employ USE INDEX or FORCE INDEX to alter the execution plan. The following performance issues are specific to or especially pronounced in NDB Cluster: Range scans. There are query performance issues due to sequential access to ...
https://dev.mysql.com/doc/refman/5.7/en/charset-configuration.html
The MySQL server has a compiled-in default character set and collation. To change these defaults, use the --character-set-server and --collation-server options when you start the server. The collation must be a legal collation for the default ...
https://dev.mysql.com/doc/refman/5.7/en/MySQLInstallerConsole.html
On success, the catalog is applied the next time either MySQLInstaller or MySQLInstallerConsole.exe is executed. This reference includes: MySQL Product Names Command Syntax Command Actions The console is installed when MySQL Installer is initially ... MySQLInstallerConsole.exe provides command-line functionality that is similar to MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-restrictions.html
As of MySQL 5.7.8, the default value for this directory can be set at build time with the INSTALL_SECURE_FILE_PRIV_EMBEDDEDDIR CMake option. The embedded server has the following limitations: No loadable functions. You cannot set this up as a ...