These settings are in the my.cnf file, in the [mysqld] section. query_cache_type=1 query_cache_limit=5M query_cache_size=100M key_buffer=200M join_buffer=4M sort_buffer=4M read_buffer=4M read_rnd_buffer=4M record_buffer=4M wait_timeout=15 table_cache=128 thread_cache=32 max_connections=300 thread_concurrency=10 innodb_buffer_pool_size=40M innodb_additional_mem_pool_size=40M key_buffer=128M