i have an old server running redhat 32bit on dual 2GHz and 2GBRAM with mysql4 am thinking to improve mysql with the following parameter can you check it please. skip-locking skip-innodb query_cache_type=1 query_cache_limit=1M query_cache_size=32M max_connections=200 interactive_timeout=100 # Reduced wait_timeout to prevent idle clients holding connections. wait_timeout=15 connect_timeout=10 # Checked opened tables and adjusted accordingly after running for a while. table_cache=512 tmp_table_size=32M # Reduced it to 32 to prevent memory hogging. Also, see notes below. thread_cache=32 # Reduced it by checking current size of *.MYI files, see notes below. key_buffer=128M # Commented out the buffer sizes and keeping the default. sort_buffer_size=2M #read_buffer # 1Mb of read_rnd_buffer_size for 1GB RAM -- see notes below. read_rnd_buffer_size=1M read_buffer_size=1M # myisam_sort_buffer_size used for ALTER, OPTIMIZE, REPAIR TABLE commands. myisam_sort_buffer_size=32M # thread_concurrency = 2 * (no. of CPU) thread_concurrency=2 #logs log_slow_queries=/var/log/mysqld.slow.log long_query_time=2 Thanks -- redhat-list mailing list unsubscribe mailto:redhat-list-request@xxxxxxxxxx?subject=unsubscribe https://www.redhat.com/mailman/listinfo/redhat-list
