5

MySQL Threads or what is this

view full story
linux-howto

http://serverfault.com – http://i.stack.imgur.com/dZFqI.png How can I reduce that number? I have a quad core machine. Do I need to edit thread_pool_size and by reducing them do I get better performance? Should a lot of queries or something happen could is choke the machine? [mysqld] default-storage-engine=MyISAM local-infile=0 symbolic-links=0 max_connections = 500 max_user_connections = 25 key_buffer = 64M myisam_sort_buffer_size = 32M join_buffer_size = 2M read_buffer_size = 2M sort_buffer_size = 2M read_rnd_buffer_size = 2M table_cache = 1024 thread_cache_size = 16K wait_timeout = 20 connect_timeout = 10 tmp_ta (HowTos)