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/myisam-ftdump.html
If you do not invoke myisam_ftdump in the directory where the table files are located, the table or index file name must be preceded by the path name to the table's database directory. Example: Suppose that the test database contains a table named ...It reads the MyISAM index file directly, so it must be run on the server host where the table is ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html
Before you begin, you should change location to the database directory and check the permissions of the table files. If you do not have a backup but know exactly how the table was created, create a copy of the table in another database. Remove the ... The discussion in this section describes how to use myisamchk on MyISAM tables (extensions .MYI and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup-concepts.html
A backup is a snapshot of the database at a given time. The data actually stored in the database tables at the time that the backup was made Transaction log. A sequential record telling how and when data was stored in the database Each of these ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-ndbd.html
MaxNoOfAttributes: Suggests total number of attributes stored in database (sum over all tables). TimeBetweenLocalCheckpoints: Time between taking snapshots of database (expressed in base-2 logarithm of bytes). The listings in this section provide ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-drop-table.html
--database, -d Command-Line Format --database=name Type String Default Value TEST_DB Name of the database in which the table resides. Usage ndb_drop_table -c connection_string tbl_name -d db_name Options that can be used with ndb_drop_table are ...
21.7.9.1 NDB Cluster Replication: Automating Synchronization of the Replica to the Source Binary Log
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-auto-sync.html
It is possible to automate much of the process described in the previous section (see Section 21.7.9, “NDB Cluster Backups With NDB Cluster Replication”). The following Perl script reset-replica.pl serves as an example of how you can do this.
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-backup.html
MySQL Enterprise Backup performs hot backup operations for MySQL databases. Hot backups are performed while the database is running and applications are reading and writing to it. This type of backup does not block normal database operations, and ...The product is architected for efficient and reliable backups of tables created by the InnoDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/password-logging.html
For example, the following statement is logged as shown because a password hash value is expected: CREATE USER 'user1'@'localhost' IDENTIFIED BY PASSWORD 'not-so-secret'; To guard log files against unwarranted exposure, locate them in a directory ...
https://dev.mysql.com/doc/refman/5.7/en/query-cache-operation.html
Queries that use different databases, different protocol versions, or different default character sets are considered different queries and are cached separately. A table can be changed by many types of statements, such as INSERT, UPDATE, DELETE, ...
https://dev.mysql.com/doc/refman/5.7/en/replica-logs-status.html
Access to the replica's connection metadata repository file or table should be restricted to the database administrator, because it contains the replication user account name and password for connecting to the source. Use a restricted access mode to ... A replica server creates two replication metadata repositories, the connection metadata repository and the applier metadata ...