Search Results
https://dev.mysql.com/doc/refman/8.4/en/merge-table-advantages.html
For example, you can put data from different months into separate tables, compress some of them with myisampack, and then create a MERGE table to use them as one. MERGE tables can help you solve the following problems: Easily manage a set of log ...
https://dev.mysql.com/doc/refman/8.4/en/mrr-optimization.html
The accessed rows are packed into packages and sent back to the central node. Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-data-directories.html
You can unpack such a distribution into a temporary location, then copy it data directory to where you are setting up the new instance. Each MySQL Instance on a machine should have its own data directory. There are different methods of setting up a ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-server-clients.html
Start the client with --protocol=TCP to connect using TCP/IP, --protocol=SOCKET to connect using a Unix socket file, --protocol=PIPE to connect using a named pipe, or --protocol=MEMORY to connect using shared memory. For TCP/IP connections, you may ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-tables.html
The pet table keeps track of which pets you have. If you want to record other information about them, such as events in their lives like visits to the vet or when litters are born, you need another table. What should this table look like? It needs ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-key-cache.html
That is, it reads from the cache or writes into it rather than reading from or writing to disk. To minimize disk I/O, the MyISAM storage engine exploits a strategy that is used by many database management systems. It employs a cache mechanism to ...
https://dev.mysql.com/doc/refman/8.4/en/myisam-maintenance-schedule.html
Alternatively, if you can stop the mysqld server for a while, change location into the data directory and use this command while the server is stopped: $> myisamchk -r -s --sort-index --myisam_sort_buffer_size=16M */*.MYI . It is a good idea to ...
https://dev.mysql.com/doc/refman/8.4/en/myisamchk.html
You can copy the files that correspond to a database table into some other location and perform recovery operations on them there. The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-backup-concepts.html
During backup, each node saves these three parts into three files on disk: BACKUP-backup_id.node_id.ctl A control file containing control information and metadata. A backup is a snapshot of the database at a given time. The data actually stored in ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-compared.html
In many instances, decisions about when and where to use NDB Cluster must be made on a case-by-case basis, taking all factors into consideration. MySQL Server offers a number of choices in storage engines. Since both NDB and InnoDB can serve as ...