1. [mysqld]
  2. innodb_file_per_table=1
  3. concurrent_insert=2
  4. query_cache_limit=1M
  5. query_cache_size=256M
  6. query_cache_type=1
  7. max_user_connections=50
  8. max_connections=256
  9. interactive_timeout=300
  10. wait_timeout=300
  11. local-infile=0
  12. connect_timeout=300
  13. thread_cache_size=32
  14. key_buffer=512M
  15. innodb_buffer_pool_size=512M
  16. join_buffer_size=1M
  17. max_allowed_packet=16M
  18. table_cache=1024
  19. table_definition_cache=1024
  20. sort_buffer_size=1M
  21. read_buffer_size=1M
  22. max_connect_errors=1000
  24. open_files_limit=50000
  25. [mysqld_safe]