MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 81 to 90 of 99 total results

4.6.3 myisamchk — MyISAM Table-Maintenance Utility

https://dev.mysql.com/doc/refman/5.7/en/myisamchk.html

The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). You can also use the CHECK TABLE and ...

B.3.7 Known Issues in MySQL

https://dev.mysql.com/doc/refman/5.7/en/known-issues.html

The server uses only the first max_sort_length bytes when comparing data values. This means that values cannot reliably be used in GROUP BY, ORDER BY, or DISTINCT if they differ only after the first max_sort_length bytes. The default value of ...

11.5 The JSON Data Type

https://dev.mysql.com/doc/refman/5.7/en/json.html

It is important to keep in mind that the size of any JSON document stored in a JSON column is limited to the value of the max_allowed_packet system variable. A maximum of 3 JSON columns per NDB table is supported. Sort keys for JSON values are bound ...The JSON data type provides these advantages over storing JSON-format strings in a string column: Automatic validation of JSON documents stored in JSON ...

14.6.3.5 The Temporary Tablespace

https://dev.mysql.com/doc/refman/5.7/en/innodb-temporary-tablespace.html

row *************************** FILE_NAME: ./ibtmp1 TABLESPACE_NAME: innodb_temporary ENGINE: InnoDB INITIAL_SIZE: 12582912 TotalSizeBytes: 12582912 DATA_FREE: 6291456 MAXIMUM_SIZE: NULL The TotalSizeBytes value reports the current size of the ...

14.6.3.1 The System Tablespace

https://dev.mysql.com/doc/refman/5.7/en/innodb-system-tablespace.html

The system tablespace is the storage area for the InnoDB data dictionary, the doublewrite buffer, the change buffer, and undo logs. It may also contain table and index data if tables are created in the system tablespace rather than file-per-table ...

21.5.24 ndb_restore — Restore an NDB Cluster Backup

https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html

--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...

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.

B.3.5 Optimizer-Related Issues

https://dev.mysql.com/doc/refman/5.7/en/optimizer-issues.html

For example, start mysqld with the --max-seeks-for-key=1000 option or use SET max_seeks_for_key=1000 to tell the optimizer to assume that no key scan causes more than 1,000 key seeks. MySQL uses a cost-based optimizer to determine the best way to ...

14.21.1 Benefits of the InnoDB memcached Plugin

https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-benefits.html

Because you can access the underlying data through SQL, you can produce reports, search or update across multiple keys, and call functions such as AVG() and MAX() on memcached data. The combination of InnoDB tables and memcached offers advantages ...

14.23 InnoDB Limits

https://dev.mysql.com/doc/refman/5.7/en/innodb-limits.html

A table can contain a maximum of 1017 columns (raised in MySQL 5.6.9 from the earlier limit of 1000). For example, you might hit this limit with a column prefix index of more than 255 characters on a TEXT or VARCHAR column, assuming a utf8mb3 ...

Displaying 81 to 90 of 99 total results