PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/delete-optimization.html
To delete rows more quickly, you can increase the size of the key cache by increasing the key_buffer_size system variable. The time required to delete individual rows in a MyISAM table is exactly proportional to the number of indexes. To delete all ...Truncate operations are not transaction-safe; an error occurs when attempting one in the course of an active transaction or active table ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-data-encryption.html
row *************************** SPACE: 4294967294 NAME: mysql SPACE_TYPE: General ENCRYPTION: Y *************************** 2. row *************************** SPACE: 2 NAME: test/t1 SPACE_TYPE: Single ENCRYPTION: Y *************************** 3. row ... InnoDB supports data-at-rest encryption for file-per-table tablespaces, general tablespaces, the mysql system tablespace, redo logs, and undo ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-replication.html
mysql> SELECT * FROM test.demo_test; +----+--------------+------+------+------+ | c1 | c2 | c3 | c4 | c5 | +----+--------------+------+------+------+ | AA | HELLO, HELLO | 8 | 0 | 0 | +----+--------------+------+------+------+ Remove all rows from ... Because the daemon_memcached plugin supports the MySQL binary log, source server through the memcached interface can be replicated for backup, balancing intensive read workloads, and high ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-disk-data-storage-requirements.html
For each row, this is equal to the space required to store the largest possible value for that column. Each row in a Disk Data table uses 8 bytes in memory to point to the data stored on disk. For example, converting a CHAR(4) column from ... The ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-prepared-statements-instances-table.html
To control the size of this table, set the performance_schema_max_prepared_statements_instances system variable at server startup. If the statement is successfully instrumented, a new row is added to the prepared_statements_instances table. Prepared ... The Performance Schema provides instrumentation for prepared statements, for which there are two protocols: The binary ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-maintenance-schedule.html
If you are performing many updates to MyISAM tables with dynamic-sized rows (tables with VARCHAR, BLOB, or TEXT columns) or have tables with many deleted rows you may want to defragment/reclaim space from the tables from time to time. Alternatively, ... It is a good idea to perform table checks on a regular basis rather than waiting for problems to ...
https://dev.mysql.com/doc/refman/8.0/en/select-optimization.html
Depending on how the query is structured, a function could be called once for every row in the result set, or even once for every row in the table, greatly magnifying any inefficiency. (When you reach a certain level of expertise, reading the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-innodb-buffer-stats-by-schema.html
These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema. Warning Querying views that access the INNODB_BUFFER_PAGE table can affect performance. Do not query these views on a production system ...
https://dev.mysql.com/doc/refman/8.0/en/sys-innodb-buffer-stats-by-table.html
These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema and table. Warning Querying views that access the INNODB_BUFFER_PAGE table can affect performance. Do not query these views on a production ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-buffer-pool-stats-table.html
The INNODB_BUFFER_POOL_STATS table provides much of the same buffer pool information provided in SHOW ENGINE INNODB STATUS output. Much of the same information may also be obtained using InnoDB buffer pool server status variables. The idea of ...