![]() For this we click on the button.Oracle today released a 7.0 maintenance release which improves stability and fixes regressions. Now we should set a password for the MySQL root user. Now both modules should be highlighted in green. If necessary, a firewall popup will appear. We click on the button for Apache and MySQL. Innodb_lru_scan_depth = 2048 table_definition_cache = 1024 table_open_cache = 2048 # Only if your have MySQL 5.6 or higher, do not use with MariaDB! #table_open_cache_instances = 4 innodb_stats_on_metadata = 0 innodb_thread_concurrency = 0 # Disable this (= 0) if you have slow harddisks innodb_flush_log_at_trx_commit = 1 innodb_flush_method = O_DIRECT Max_connections = 200 innodb_file_per_table = 1 # Disable this (= 0) if you have only one to two CPU cores, change it to 4 for a quad core. Query_cache_min_res_unit = 4096 query_cache_type = 1 query_cache_limit = 5M Sort_buffer_size = 262144 # default join_buffer_size = 262144 # default max_allowed_packet = 128M # MySQL/MariaDB writes two of these log files in a default installation. # Use multiple instances if you have innodb_buffer_pool_size > 10G, 1 every 4GB innodb_buffer_pool_instances = 1 # Redo log file size, the higher the better. # This is the number 1 setting to look at for any performance optimization # It is where the data and indexes are cached: having it as large as possible will # ensure MySQL uses memory and not disks for most read operations. We also add the following settings here at the end of the file and save: Normally, this file should also be opened automatically with the editor. For this we click on the button Config → my.ini. Separate settings for the Apache web server are not necessary here. Also, under Dynamic Extensions, the extension=ldap must be freed from the leading semicolon. ![]() Max_execution_time = 300 max_file_uploads = 42 max_input_time = 60 max_input_vars = 10000 memory_limit = 256MĮrror_reporting = E_ALL
0 Comments
Leave a Reply. |