diff options
Diffstat (limited to 'support-files/my-innodb-heavy-4G.cnf.sh')
| -rw-r--r-- | support-files/my-innodb-heavy-4G.cnf.sh | 28 |
1 files changed, 5 insertions, 23 deletions
diff --git a/support-files/my-innodb-heavy-4G.cnf.sh b/support-files/my-innodb-heavy-4G.cnf.sh index 60b8138880e..e9390a5b9e8 100644 --- a/support-files/my-innodb-heavy-4G.cnf.sh +++ b/support-files/my-innodb-heavy-4G.cnf.sh @@ -80,7 +80,7 @@ max_connect_errors = 10 # Therefore you have to make sure to set the amount of open files # allowed to at least 4096 in the variable "open-files-limit" in # section [mysqld_safe] -table_cache = 2048 +table_open_cache = 2048 # Enable external file level locking. Enabled file locking will have a # negative impact on performance, so only use it in case you have @@ -167,7 +167,7 @@ ft_min_word_len = 4 # Table type which is used by default when creating new tables, if not # specified differently during the CREATE TABLE statement. -default_table_type = MYISAM +default-storage-engine = MYISAM # Thread stack size to use. This amount of memory is always reserved at # connection time. MySQL itself usually needs no more than 64K of @@ -211,10 +211,10 @@ binlog_format=mixed # Log slow queries. Slow queries are queries which take more than the # amount of time defined in "long_query_time" or which do not use -# indexes well, if log_long_format is enabled. It is normally good idea +# indexes well, if log_short_format is not enabled. It is normally good idea # to have this turned on if you frequently add new queries to the # system. -log_slow_queries +slow_query_log # All queries taking more than this amount of time (in seconds) will be # trated as slow. Do not use "1" as a value here, as this will result in @@ -222,11 +222,6 @@ log_slow_queries # currently measures time with second accuracy only). long_query_time = 2 -# Log more information in the slow query log. Normally it is good to -# have this turned on. This will enable logging of queries that are not -# using indexes in addition to long running queries. -log_long_format - # The directory used by MySQL for storing temporary files. For example, # it is used to perform disk based large sorts, as well as for internal # and explicit temporary tables. It might be good to put it on a @@ -345,12 +340,6 @@ myisam_sort_buffer_size = 128M # through the key cache (which is slower). myisam_max_sort_file_size = 10G -# If the temporary file used for fast index creation would be bigger -# than using the key cache by the amount specified here, then prefer the -# key cache method. This is mainly used to force long character keys in -# large tables to use the slower key cache method to create the index. -myisam_max_extra_sort_file_size = 10G - # If a table has more than one index, MyISAM can use more than one # thread to repair them by sorting in parallel. This makes sense if you # have multiple CPUs and plenty of memory. @@ -359,7 +348,6 @@ myisam_repair_threads = 1 # Automatically check and repair not properly closed MyISAM tables. myisam_recover - # *** INNODB Specific options *** # Use this option if you have a MySQL server with InnoDB support enabled @@ -482,14 +470,8 @@ no-auto-rehash # Only allow UPDATEs and DELETEs that use keys. #safe-updates -[isamchk] -key_buffer = 512M -sort_buffer_size = 512M -read_buffer = 8M -write_buffer = 8M - [myisamchk] -key_buffer = 512M +key_buffer_size = 512M sort_buffer_size = 512M read_buffer = 8M write_buffer = 8M |