title: best mysql configuration file's variable for 2GB DB
body: <p>I have a 2GB DB and it is very slow below my configuration file variable , what I shall change to make it faster </p>
  
  <pre><code>read_buffer_size=1M
  read_rnd_buffer_size=256K
  sort_buffer_size=256K
  innodb_additional_mem_pool_size=2M
  innodb_flush_log_at_trx_commit=1
  innodb_log_buffer_size=1M
  innodb_buffer_pool_size=16M
  innodb_log_file_size=10M
  innodb_thread_concurrency=8
  max_connections=151
  old_passwords=0
  max_user_connections=30
  thread_cache_size=4
  thread_stack=196608
  binlog_cache_size=32768
  net_read_timeout=30
  net_retry_count=10
  net_write_timeout=30
  thread_concurrency=10
  open_files_limit=4161
  table_definition_cache=400
  </code></pre>
  
  <hr>
  
  <pre><code>Threads_cached  2
  Threads_connected   2
  Threads_created     12
  Threads_running     1
  </code></pre>