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/myisam-table-problems.html
The file format that MySQL uses to store data has been extensively tested, but there are always circumstances that may cause database tables to become corrupted. The following discussion describes how this can happen and how to handle it.
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-memory-summary-tables.html
Operation counts help to understand or tune the overall pressure the server is putting on the memory allocator, which has an impact on performance. Allocating a single byte one million times is not the same as allocating one million bytes a single ...Low and high water marks are critical to detect workload spikes, overall workload stability, and possible memory ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-mutex-instances-table.html
The mutex_instances table lists all the mutexes seen by the Performance Schema while the server executes. A mutex is a synchronization mechanism used in the code to enforce that only one thread at a given time can have access to some common ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-ndb-sync-pending-objects-table.html
This table provides information about NDB database objects for which mismatches have been detected and which are waiting to be synchronized between the NDB dictionary and the MySQL data dictionary.
https://dev.mysql.com/doc/refman/8.0/en/replication-solutions.html
For information on using replication in a backup environment, including notes on the setup, backup procedure, and files to back up, see Section 19.4.1, “Using Replication for Backups”. See Section 19.4.6, “Replicating Different Databases to ...
https://dev.mysql.com/doc/refman/8.0/en/server-administration.html
MySQL Server (mysqld) is the main program that does most of the work in a MySQL installation.
https://dev.mysql.com/doc/refman/8.0/en/table.html
With INTO to populate user variables, and with INTO OUTFILE or INTO DUMPFILE to write table data to a file. TABLE is a DML statement introduced in MySQL 8.0.19 which returns rows and columns of the named table. Given the existence of a table named ...TABLE does not allow for any arbitrary filtering of rows; that is, TABLE does not support any WHERE ...
https://dev.mysql.com/doc/refman/8.0/en/where-optimization.html
In some cases, MySQL can read rows from the index without even consulting the data file. The examples use SELECT statements, but the same optimizations apply for WHERE clauses in DELETE and UPDATE statements. Note Because work on the MySQL optimizer ... This section discusses optimizations that can be made for processing WHERE ...
https://dev.mysql.com/doc/refman/8.0/en/automatic-start.html
The following table shows which option groups the server and startup scripts read from option files. To be current, you should update your option files to use the [mysql.server] and [mysqld_safe] groups instead. For more information on MySQL ...On ...
https://dev.mysql.com/doc/refman/8.0/en/debugging-client.html
Before running a client, you should set the MYSQL_DEBUG environment variable: $> MYSQL_DEBUG=d:t:O,/tmp/client.trace $> export MYSQL_DEBUG This causes clients to generate a trace file in /tmp/client.trace. To be able to debug a MySQL client with ...