daily pastebin goal
44%
SHARE
TWEET

mariadb 158M

admin74 Oct 12th, 2016 21 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top