admin74

mariadb 158M

Oct 12th, 2016
138
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 2.43 KB | None | 0 0
  1. [client]
  2. #158M minimal ram usage for mysql.exe ( version 10.1.9-MariaDB )
  3. #/prog/xamp/mysql/bin/mysql.exe -u root -e "show variables;" > /variables.sql.log
  4. port=3306
  5. socket="C:/prog/xamp/mysql/mysql.sock"
  6. [mysqld]
  7. max_connections=3
  8. interactive_timeout=300
  9. lock_wait_timeout=30
  10. wait_timeout=30
  11. port= 3306
  12. socket = "C:/prog/xamp/mysql/mysql.sock"
  13. basedir = "C:/prog/xamp/mysql"
  14. tmpdir = "C:/prog/xamp/tmp"
  15. datadir = "C:/prog/xamp/mysql/data"
  16. pid_file = "mysql.pid"
  17. key_buffer = 2M
  18. max_allowed_packet = 1M
  19. sort_buffer_size = 512K
  20. net_buffer_length = 8K
  21. read_buffer_size = 256K
  22. read_rnd_buffer_size = 512K
  23. myisam_sort_buffer_size = 2M
  24. log_error = "mysql_error.log"
  25. plugin_dir = "C:/prog/xamp/mysql/lib/plugin/"
  26. innodb_data_home_dir = "C:/prog/xamp/mysql/data"
  27. innodb_data_file_path = ibdata1:10M:autoextend
  28. innodb_log_group_home_dir = "C:/prog/xamp/mysql/data"
  29. innodb_buffer_pool_size = 2M
  30. innodb_additional_mem_pool_size = 1M
  31. innodb_log_file_size = 1M
  32. innodb_log_buffer_size = 1M
  33. innodb_flush_log_at_trx_commit = 1
  34. #{tests
  35.  
  36.  
  37. #}FALSE GOOD IDEAS{
  38. #thread_stack=1K
  39. #host_cache_size=1K
  40. #innodb_ft_cache_size=1K
  41. #innodb_ft_total_cache_size=1K
  42. #innodb_sort_buffer_size=1K
  43. #performance_schema=0
  44. #skip_external_locking
  45. #skip_name_resolve
  46. #table_definition_cache=20
  47. #innodb_sort_buffer_size=64K
  48. #binlog_cache_size=4K
  49. #binlog_stmt_cache_size=4K
  50. #read_rnd_buffer_size=8K
  51. #max_heap_table_size=16K
  52. #tmp_table_size=1K
  53. #join_buffer_size=128
  54. #thread_stack=131K
  55. #sort_buffer_size=32K
  56. #read_buffer_size=8K
  57. #tmp_table_size=1M
  58. #bind-address="127.0.0.1"
  59. #open_files_limit=30
  60. #innodb_ft_cache_size=1M
  61. #innodb_ft_total_cache_size=1M
  62. #innodb_lock_wait_timeout = 50
  63. #max_binlog_cache_size=20M
  64.  
  65.  
  66. #}cause crashes{
  67. #sql_log_bin=OFF
  68. #skip_parallel_replication
  69. #skip_show_database
  70. #skip_replication
  71.  
  72. #}no impact{
  73. #server-id  = 1
  74. #performance_schema=OFF
  75. #}
  76.  
  77.  
  78.  
  79. ## UTF 8 Settings
  80. #init-connect=\'SET NAMES utf8\'
  81. #collation_server=utf8_unicode_ci
  82. #character_set_server=utf8
  83. #skip-character-set-client-handshake
  84. #character_sets-dir="C:/prog/xamp/mysql/share/charsets"
  85. [mysqldump]
  86. quick
  87. max_allowed_packet = 16M
  88. [mysql]
  89. no-auto-rehash
  90. # Remove the next comment character if you are not familiar with SQL
  91. #safe-updates
  92. [isamchk]
  93. key_buffer = 1M
  94. sort_buffer_size = 1M
  95. read_buffer = 2M
  96. write_buffer = 2M
  97. [myisamchk]
  98. key_buffer = 1M
  99. sort_buffer_size = 1M
  100. read_buffer = 2M
  101. write_buffer = 2M
  102. [mysqlhotcopy]
  103. interactive-timeout
Add Comment
Please, Sign In to add comment