daily pastebin goal
15%
SHARE
TWEET

Untitled

a guest Nov 22nd, 2017 49 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
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