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/faqs-mysql-cluster.html
How do I import an existing MySQL database into an NDB Cluster? A.10.28. What do “NDB” and “NDBCLUSTER” mean? “NDB” stands for “Network Database”. There must be sufficient memory on machines used for data nodes to hold each node's ...
https://dev.mysql.com/doc/refman/5.7/en/features.html
This section describes some of the important characteristics of the MySQL Database Software. This is useful if you want to provide an SQL interface for an in-house database. Support for DELETE, INSERT, REPLACE, and UPDATE to return the number of ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-binary-package.html
In-Place Upgrade Logical Upgrade In-Place Upgrade An in-place upgrade involves shutting down the old MySQL server, replacing the old MySQL binaries or packages with the new ones, restarting MySQL on the existing data directory, and upgrading any ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-mysql-privileges.html
This includes all MySQL privilege types (SELECT privilege, UPDATE privilege, DELETE privilege, and so on) granted on the database, table, and column level. As with any other MySQL Server, user and privilege information is stored in the mysql system ... In this section, we discuss how the MySQL privilege system works in relation to NDB Cluster and the implications of this for keeping an NDB Cluster ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-overview.html
Database performance depends on several factors at the database level, such as tables, queries, and configuration settings. As you work on database performance, you start by learning the high-level rules and guidelines for the software side, and ...
https://dev.mysql.com/doc/refman/5.7/en/windows-postinstallation.html
Windows distributions prior to MySQL 5.7.7 include a data directory with a set of preinitialized accounts in the mysql database. Use mysqlshow to see what databases exist: C:\> bin\mysqlshow +--------------------+ | Databases | ... GUI tools exist ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-more-topics.html
For example: docker run --name mysql1 -d mysql/mysql-server:tag --character-set-server=utf8mb4 --collation-server=utf8mb4_col The command starts your MySQL Server with utf8mb4 as the default character set and utf8mb4_col as the default collation for ...A MySQL Docker installation is different from a common, non-Docker installation in the following aspects: Included binaries are limited to: /usr/bin/my_print_defaults /usr/bin/mysql /usr/bin/mysql_config /usr/bin/mysql_install_db /usr/bin/mysql_tzinfo_to_sql /usr/bin/mysql_upgrade /usr/bin/mysqladmin /usr/bin/mysqlcheck /usr/bin/mysqldump /usr/bin/mysqlpump /usr/sbin/mysqld All binaries are stripped; they contain no debug ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-recovery.html
Recovery from Data Corruption or Disk Failure If your database becomes corrupted or disk failure occurs, you must perform the recovery using a backup. In some cases of database corruption, it is enough to dump, drop, and re-create one or a few ...To ...
https://dev.mysql.com/doc/refman/5.7/en/innochecksum.html
In this example, an innodb checksum is rewritten to replace an invalid checksum: innochecksum --no-check --write innodb ../data/test/tab1.ibd --allow-mismatches, -a Command-Line Format --allow-mismatches=# Type Integer Default Value 0 Minimum Value ...This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locks-set.html
FROM is a consistent read, reading a snapshot of the database and setting no locks unless the transaction isolation level is set to SERIALIZABLE. REPLACE is done like an INSERT if there is no collision on a unique key. Otherwise, an exclusive ... A ...