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/sys-io-global-by-wait-by-latency.html
These views summarize global I/O consumers to display amount of I/O and time waiting for I/O, grouped by event. avg_read The average number of bytes per read for the I/O event. avg_written The average number of bytes per write for the I/O event.
https://dev.mysql.com/doc/refman/5.7/en/sys-memory-by-host-by-current-bytes.html
Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. current_count_used The current number of allocated memory blocks that have ...
https://dev.mysql.com/doc/refman/5.7/en/where-optimization.html
This section discusses optimizations that can be made for processing WHERE clauses. 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 is ...You might be tempted to rewrite your queries to make arithmetic operations faster, while sacrificing ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-problems.html
If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new column collation maps two keys to the same value or that the table is corrupted. In the latter ...
https://dev.mysql.com/doc/refman/5.7/en/csv-storage-engine.html
When you create a CSV table, the server creates a table format file in the database directory. If you examine the test.CSV file in the database directory created by executing the preceding statements, its contents should look like this: "1","record ... The CSV storage engine stores data in text files using comma-separated values ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-ftdump.html
--dump, -d Command-Line Format --dump Dump the index, including data offsets and word weights. Before using myisam_ftdump, be sure to issue a FLUSH TABLES statement first if the server is running. If you do not invoke myisam_ftdump in the directory ...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/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. For these reasons, hot backups are desirable when your database ...
https://dev.mysql.com/doc/refman/5.7/en/error-creating-innodb.html
If you already created some InnoDB tables, also delete the corresponding .frm files for these tables, and any .ibd files if you are using multiple tablespaces, from the MySQL database directories. The troubleshooting steps for InnoDB I/O problems ...Initialization Problems If something goes wrong when InnoDB attempts to initialize its tablespace or its log files, delete all files created by InnoDB: all ibdata files and all ib_logfile ...
https://dev.mysql.com/doc/refman/5.7/en/example-storage-engine.html
When you create an EXAMPLE table, the server creates a table format file in the database directory. mysql> CREATE TABLE test (i INT) ENGINE = EXAMPLE; Query OK, 0 rows affected (0.78 sec) mysql> INSERT INTO test VALUES(1),(2),(3); ERROR 1031 ...To ... The EXAMPLE storage engine is a stub engine that does ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-view-changes.html
Figure 17.10 Stable Group View Change: a Member Joins Whenever a new member joins the group and therefore a view change is performed, every online server queues a view change log event for execution. This is queued because before the view change, ...