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/windows-restrictions.html
Alternatively, to use more than 2GB, use a 64-bit version of Windows. File system aliases When using MyISAM tables, you cannot use aliases within Windows link to the data files on another volume and then link back to the main MySQL datadir location.
https://dev.mysql.com/doc/refman/5.7/en/events-metadata.html
Value mysql.event EVENTS Table SHOW EVENTS Execute at UTC ETZ ETZ Starts UTC ETZ ETZ Ends UTC ETZ ETZ Last executed UTC ETZ n/a Created STZ STZ n/a Last altered STZ STZ n/a . To obtain metadata about events: Query the event table of the mysql ...
https://dev.mysql.com/doc/refman/5.7/en/firewall-installation.html
$> mysql -u root -p < linux_install_firewall.sql Enter password: (enter root password here) Note As of MySQL 5.7.21, for a new installation of MySQL Enterprise Firewall, InnoDB is used instead of MyISAM for the firewall tables. MySQL Enterprise ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-setting.html
Examples include all DDL (data definition language) statements such as CREATE TABLE, ALTER TABLE, or DROP TABLE. If the session is currently in row-based replication mode and has open temporary tables. Switching the replication format at runtime is ... You can select the binary logging format explicitly by starting the MySQL server with ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-benchmarking.html
If you did not make a deliberate decision about the storage engine, and you want to preview how certain tables work when created using InnoDB, issue the command ALTER TABLE table_name ENGINE=InnoDB; for each table. Alternatively, to run test queries ...Since changing the default storage engine only affects newly created tables, run your application installation and setup steps to confirm that everything installs properly, then exercise the application features to make sure the data loading, editing, and querying features ... If InnoDB is not the default ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-rpm.html
For Red Hat Enterprise Linux/Oracle Linux/CentOS systems: $> sudo yum install mysql-community-{client,common,libs}-* mysql-5.* A standard installation of MySQL using the RPM packages result in files and resources created under the system ... The ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html
There are multiple ways to cause MySQL to accept the query: Alter the table to make name a primary key or a unique NOT NULL column. The following examples use HEX() to display the INET6_ATON() result in printable form: mysql> SELECT ...The function ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-catalog-dashboard.html
For upgrades, a check box enables you to skip the upgrade check and process for system tables, while checking and processing data dictionary tables normally. This behavior represents a change in how MySQL Server performs an upgrade (see What the ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-partitioning.html
Replication is supported between partitioned tables as long as they use the same partitioning scheme and otherwise have the same structure except where an exception is specifically allowed (see Section 16.4.1.10, “Replication with Differing Table ...DROP PARTITION) acting directly on partitions in such cases may produce different results on source and ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-source.html
On the source and each replica, you must set the server_id system variable to establish a unique replication ID. If their values have already been modified from the default, Group Replication does not alter them. It is not possible to restrict the ... This section describes the server options and system variables that you can use on replication source ...