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/memory-use.html
MySQL allocates buffers and caches to improve performance of database operations. The default configuration is designed to permit a MySQL server to start on a virtual machine that has approximately 512MB of RAM. You can improve MySQL performance by ...
https://dev.mysql.com/doc/refman/5.7/en/merge-storage-engine.html
The tables do not have to be in the same database as the MERGE table. The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as one. “Identical” means that all tables have ...
https://dev.mysql.com/doc/refman/5.7/en/monitor-alter-table-performance-schema.html
In this example, a middle_name column is added to the employees table of the employees sample database. You can monitor ALTER TABLE progress for InnoDB tables using Performance Schema. There are seven stage events that represent different phases of ...
https://dev.mysql.com/doc/refman/5.7/en/monitoring-performance-schema.html
You can query the tables in the performance_schema database to see real-time information about the performance characteristics of your server and the applications it is running.
https://dev.mysql.com/doc/refman/5.7/en/multiple-data-directories.html
Warning Normally, you should never have two servers that update data in the same databases. Each MySQL Instance on a machine should have its own data directory. There are different methods of setting up a data directory for a new instance: Create a ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-servers.html
Or you might run multiple instances of the current production version, each managing a different set of databases. In some cases, you might want to run multiple instances of MySQL on a single machine. You might want to test a new MySQL release ...
https://dev.mysql.com/doc/refman/5.7/en/multiple-windows-command-line-servers.html
Use this procedure: Make sure that each data directory exists, including its own copy of the mysql database that contains the grant tables. The procedure for starting a single MySQL server manually from the command line is described in Section ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-start.html
You should have a cron script that automatically moves these files from the database directories to backup media. The following options to mysqld can be used to change the behavior of MyISAM tables. bulk_insert_buffer_size The size of the tree ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-storage-engine.html
Table 15.2 MyISAM Storage Engine Features Feature Support B-tree indexes Yes Backup/point-in-time recovery (Implemented in the server, rather than in the storage engine.) Yes Cluster database support No Clustered indexes No Compressed data Yes ...
https://dev.mysql.com/doc/refman/5.7/en/myisam-table-maintenance.html
You can use myisamchk to check, repair, or optimize database tables. This section discusses how to use myisamchk to check or repair MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). For general myisamchk background, ...