title: How to set memory limit in my.cnf file
body: <p>How to set memory limit in <code>my.cnf</code> file. I tried with <code>memory_limit = 64M</code> . But its showing error while restarting MYSQL server. Any one please help...</p>
  
  <p><strong>my.cnf</strong></p>
  
  <pre><code>[mysqld]
  datadir=/home/mysql/
  tmpdir=/home/mysqltmp
  #max_connections = 175 #was 175
  max_connections = 80
  #max_connect_errors = 350 #was 250
  max_connect_errors = 250
  safe-show-database
  skip-locking
  key_buffer = 1024M # was 128M
  max_allowed_packet = 6M
  myisam_sort_buffer_size = 64M
  
  #old settings, for 900 ish max maxconn
  #sort_buffer_size = 32M
  #read_buffer_size = 32M
  #read_rnd_buffer_size = 32M
  
  sort_buffer_size = 5M
  read_buffer_size = 5M
  read_rnd_buffer_size = 5M
  
  query_cache_size= 1024M
  query_cache_limit= 16M
  max_heap_table_size = 128M
  tmp_table_size = 128M
  thread_concurrency = 16
  wait_timeout = 10
  innodb_file_per_table
  innodb_log_file_size = 10485760
  open_files_limit = 8192
  low_priority_updates = 1 
  #log_slow_queries = /var/log/mysql_slow.log
  #log_queries_not_using_indexes = 1
  #slow_queries_log_file = /var/log/mysql_slow.log
  memory_limit = 64M 
  # who set these? these are NOT memory settings, but rather integer settings.
  #table_cache = 1024M
  #thread_cache_size = 8M
  
  table_cache = 512
  thread_cache_size = 8
  
  [mysqldump]
  quick
  max_allowed_packet = 16M
  
  [mysql]
  no-auto-rehash
  
  [isamchk]
  key_buffer = 128M
  sort_buffer_size = 128M
  read_buffer = 2M
  write_buffer = 2M
  
  [myisamchk]
  key_buffer = 128M
  sort_buffer_size = 128M
  read_buffer = 2M
  write_buffer = 2M
  </code></pre>