The bulk_insert_buffer_size parameter caches data on bulk inserts to increase performance.For the table load, this setting is important. The myisam_sort_buffer_size parameter is the buffer size for creating indexes on myisam tables.The default size is 0, so the query cache is disabled by default. This should be adjusted upward as the database increases in size. The query_cache_size parameter sets the amount of memory globally available for the query cache.If the query results exceed the query cache limit, the results or data will not be cached.
The query_cache_limit parameter set the maximum size of each query that will be cached.The read_buffer_size parameter determines that amount of memory to allocate for each sequential scan of a table.The sort_buffer_size parameter determines how much area in memory MySQL has to sort data before they are returned.To allocate a buffer size of 500MB use:.Make sure this parameter is not set to high for MySQL may run out of file descriptors and refuse connections or fail to execute queries. The table_cache parameter informs MySQL about how many tables it can have open at any given time.
This buffer should be large enough to hold all indexes.
#MYSQL CREATE DATABASE UTF8 INNODB SOFTWARE#
Recommended Software Version: MySQL Server 5.5 You may also generate these files after creating your subset: Select "Advanced" then "Copy Database Load Scripts to Hard Drive" from the MetamorphoSys welcome screen. To generate the necessary files and scripts while creating your subset, select the MySQL database in the “Write Database Load Scripts” section of the "Output Options" tab. This document is a guide to loading an RRF subset of the UMLS Metathesaurus into a MySQL database by using the scripts and files created by MetamorphoSys.