daily pastebin goal
62%
SHARE
TWEET

Untitled

a guest Nov 22nd, 2017 48 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [mysqld]
  2.  
  3.     local-infile=0
  4.     datadir=/var/lib/mysql
  5.     socket=/var/lib/mysql/mysql.sock
  6.     long_query_time=1
  7.     log-slow-queries=/var/log/mysql/log-slow-queries.log
  8.     interactive_timeout=180
  9.     wait_timeout=180
  10.     max_connections=100
  11.     innodb_buffer_pool_size=256M
  12.     query_cache_size=256M
  13.     key_buffer_size=256M
  14.     sort_buffer_size=20M
  15.     innodb_flush_log_at_trx_commit=0
  16.     innodb_flush_method=O_DIRECT
  17.     query_cache_type=1
  18.     query_cache_limit=2M
  19.     table_cache=1024
  20.     join_buffer_size=4M
  21.     thread_cache_size=4
  22.     tmp_table_size=40M
  23.     max_heap_table_size=256MB
  24.  
  25.     user=mysql
  26.     symbolic-links=0
  27.     #bind-address=127.0.0.1
  28.  
  29.     [mysqld_safe]
  30.  
  31.     log-error=/var/log/mysqld.log
  32.     pid-file=/var/run/mysqld/mysqld.pid
  33.    
  34. [mysqld]
  35.  
  36.     local-infile=0
  37.     datadir=/var/lib/mysql
  38.     socket=/var/lib/mysql/mysql.sock
  39.     long_query_time=1
  40.     log-slow-queries=/var/log/mysql/log-slow-queries.log
  41.     interactive_timeout=180
  42.     wait_timeout=180
  43.     max_connections=100
  44.     innodb_buffer_pool_size=256M
  45.     query_cache_size=256M
  46.     key_buffer_size=256M
  47.     sort_buffer_size=20M
  48.     innodb_flush_log_at_trx_commit=0
  49.     innodb_flush_method=O_DIRECT
  50.     query_cache_type=1
  51.     query_cache_limit=2M
  52.     table_cache=1024
  53.     join_buffer_size=4M
  54.     thread_cache_size=4
  55.     tmp_table_size=40M
  56.     max_heap_table_size=256MB
  57.  
  58.     user=mysql
  59.     symbolic-links=0
  60.     #bind-address=127.0.0.1
  61.  
  62.     [mysqld_safe]
  63.  
  64.     log-error=/var/log/mysqld.log
  65.     pid-file=/var/run/mysqld/mysqld.pid
  66.    
  67. innodb_buffer_pool_size=256M
  68.    
  69. max_heap_table_size=256MB    needs to be
  70. max_heap_table_size=40M # from 256MB to correct MB and match tmp_table_size
RAW Paste Data
Top