Autor | Zpráva | ||
---|---|---|---|
jtfcobra Profil |
#1 · Zasláno: 28. 4. 2017, 21:43:09
Mysql 5.6 nastavení prosím o radu zda je to optimalně nastaveny
Mám VPS 1xCPU 1x4GB RAM 30GB HDD WINDOWS 2012 Databaze ma velikost 1GB [client] no-beep port=3306 [mysql] default-character-set=utf8 [mysqld] port=3306 datadir=C:/ProgramData/MySQL/MySQL Server 5.6/Data character-set-server=utf8 default-storage-engine=INNODB sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" log-output=FILE general-log=0 general_log_file="VM14831.log" slow-query-log=1 slow_query_log_file="VM14831-slow.log" long_query_time=10 log-error="VM14831.err" server-id=1 secure-file-priv="C:/ProgramData/MySQL/MySQL Server 5.6/Uploads" max_connections = 200 query_cache_size = 256M table_open_cache=2000 tmp_table_size=270M thread_cache_size=10 myisam_max_sort_file_size=100G myisam_sort_buffer_size = 128M key_buffer_size=8M read_buffer_size=64K read_rnd_buffer_size=256K innodb_additional_mem_pool_size=32M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size = 8M innodb_buffer_pool_size = 2G innodb_log_file_size=48M innodb_thread_concurrency=8 innodb_autoextend_increment=64 innodb_buffer_pool_instances=8 innodb_concurrency_tickets=5000 innodb_old_blocks_time=1000 innodb_stats_on_metadata=0 innodb_file_per_table=1 innodb_checksum_algorithm=0 back_log=80 flush_time=0 join_buffer_size=256K max_allowed_packet=4M max_connect_errors=100 open_files_limit=4161 query_cache_type=1 sort_buffer_size=256K table_definition_cache=1400 binlog_row_event_max_size=8K sync_master_info=10000 sync_relay_log=10000 sync_relay_log_info=10000 |
||
Časová prodleva: 7 let
|
0