Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [client]
- #158M minimal ram usage for mysql.exe ( version 10.1.9-MariaDB )
- #/prog/xamp/mysql/bin/mysql.exe -u root -e "show variables;" > /variables.sql.log
- port=3306
- socket="C:/prog/xamp/mysql/mysql.sock"
- [mysqld]
- max_connections=3
- interactive_timeout=300
- lock_wait_timeout=30
- wait_timeout=30
- port= 3306
- socket = "C:/prog/xamp/mysql/mysql.sock"
- basedir = "C:/prog/xamp/mysql"
- tmpdir = "C:/prog/xamp/tmp"
- datadir = "C:/prog/xamp/mysql/data"
- pid_file = "mysql.pid"
- key_buffer = 2M
- max_allowed_packet = 1M
- sort_buffer_size = 512K
- net_buffer_length = 8K
- read_buffer_size = 256K
- read_rnd_buffer_size = 512K
- myisam_sort_buffer_size = 2M
- log_error = "mysql_error.log"
- plugin_dir = "C:/prog/xamp/mysql/lib/plugin/"
- innodb_data_home_dir = "C:/prog/xamp/mysql/data"
- innodb_data_file_path = ibdata1:10M:autoextend
- innodb_log_group_home_dir = "C:/prog/xamp/mysql/data"
- innodb_buffer_pool_size = 2M
- innodb_additional_mem_pool_size = 1M
- innodb_log_file_size = 1M
- innodb_log_buffer_size = 1M
- innodb_flush_log_at_trx_commit = 1
- #{tests
- #}FALSE GOOD IDEAS{
- #thread_stack=1K
- #host_cache_size=1K
- #innodb_ft_cache_size=1K
- #innodb_ft_total_cache_size=1K
- #innodb_sort_buffer_size=1K
- #performance_schema=0
- #skip_external_locking
- #skip_name_resolve
- #table_definition_cache=20
- #innodb_sort_buffer_size=64K
- #binlog_cache_size=4K
- #binlog_stmt_cache_size=4K
- #read_rnd_buffer_size=8K
- #max_heap_table_size=16K
- #tmp_table_size=1K
- #join_buffer_size=128
- #thread_stack=131K
- #sort_buffer_size=32K
- #read_buffer_size=8K
- #tmp_table_size=1M
- #bind-address="127.0.0.1"
- #open_files_limit=30
- #innodb_ft_cache_size=1M
- #innodb_ft_total_cache_size=1M
- #innodb_lock_wait_timeout = 50
- #max_binlog_cache_size=20M
- #}cause crashes{
- #sql_log_bin=OFF
- #skip_parallel_replication
- #skip_show_database
- #skip_replication
- #}no impact{
- #server-id = 1
- #performance_schema=OFF
- #}
- ## UTF 8 Settings
- #init-connect=\'SET NAMES utf8\'
- #collation_server=utf8_unicode_ci
- #character_set_server=utf8
- #skip-character-set-client-handshake
- #character_sets-dir="C:/prog/xamp/mysql/share/charsets"
- [mysqldump]
- quick
- max_allowed_packet = 16M
- [mysql]
- no-auto-rehash
- # Remove the next comment character if you are not familiar with SQL
- #safe-updates
- [isamchk]
- key_buffer = 1M
- sort_buffer_size = 1M
- read_buffer = 2M
- write_buffer = 2M
- [myisamchk]
- key_buffer = 1M
- sort_buffer_size = 1M
- read_buffer = 2M
- write_buffer = 2M
- [mysqlhotcopy]
- interactive-timeout
Add Comment
Please, Sign In to add comment