PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/miscellaneous-optimization-tips.html
If possible, classify reports as “live” or as “statistical”, where data needed for statistical reports is created only from summary tables that are generated periodically from the live data. This section lists a number of miscellaneous tips ...
https://dev.mysql.com/doc/refman/8.0/en/monitor-innodb-mutex-waits-performance-schema.html
A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to a common resource. When two or more threads executing in the server need to access the same resource, the threads compete ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-servers.html
To achieve better performance, you can specify the following option differently for each server, to spread the load between several physical disks: --tmpdir=dir_name Having different temporary directories also makes it easier to determine which ...
https://dev.mysql.com/doc/refman/8.0/en/my-print-defaults.html
To create or modify a login path file, use the mysql_config_editor utility. my_print_defaults displays the options that are present in option groups of option files. The output indicates what options are used by programs that read the specified ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-ftdump.html
Example: Suppose that the test database contains a table named mytexttable that has the following definition: CREATE TABLE mytexttable ( id INT NOT NULL, txt TEXT NOT NULL, PRIMARY KEY (id), FULLTEXT (txt) ) ENGINE=MyISAM; The index on id is index 0 ...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/8.0/en/myisamlog.html
To create such a file, start the server with a --log-isam=log_file option. Invoke myisamlog like this: myisamlog [options] [file_name [tbl_name] ...] The default operation is update (-u). If a recovery is done (-r), all writes and possibly updates ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-batch-commands.html
To do so, create a text file text_file that contains the statements you wish to execute. The mysql client typically is used interactively, like this: mysql db_name However, it is also possible to put your SQL statements in a file and then tell ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-added-deprecated-removed.html
PartitionsPerNode: Determines the number of table partitions created on each data node; not used if ClassicFragmentation is enabled. Parameters Introduced in NDB 8.0 The following node configuration parameters have been added in NDB 8.0.
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-concepts.html
In the listing just shown, backup_id stands for the backup identifier and node_id is the unique identifier for the node creating the file. A backup is a snapshot of the database at a given time. The data actually stored in the database tables at ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-backup-parallel-data-nodes.html
To force creation of a single-threaded backup that can easily be imported by ndb_restore from an NDB release prior to 8.0, you can set EnableMultithreadedBackup = 0 for all data nodes (you can do this by setting the parameter in the [ndbd default] ... It is possible in NDB 8.0 to take a backup with multiple local data managers (LDMs) acting in parallel on the data ...