Hi, My old mysql is 3.23.56 on RedHat9(Intel). After moving mySQL to Solaris 9 (Sun F280R/2GB Memory) and upgrading mySQL to 4.0.20, I got a lot of complaints about the performance for select and update. Have anyone can tell me if there is anything I should tune for Solaris or MySQL to improve the performance.
Thanks //Linda The variables are as below: Variable_name Value back_log 50 basedir /usr/mysql/ binlog_cache_size 32768 bulk_insert_buffer_size 8388608 character_set big5 character_sets big5 cp1251 cp1257 croat czech danish dec8 dos estonia euc_kr gb 2312 gbk german1 greek hebrew hp8 hungarian koi8_ru koi8_ukr latin1 latin1_de la tin2 latin5 sjis swe7 tis620 ujis usa7 win1250 win1251ukr win1251 concurrent_insert ON connect_timeout 5 convert_character_set datadir /usr/mysql/var/ default_week_format 0 delay_key_write ON delayed_insert_limit 100 delayed_insert_timeout 300 delayed_queue_size 1000 flush OFF flush_time 0 ft_boolean_syntax + -><()~*:""&| ft_min_word_len 4 ft_max_word_len 254 ft_max_word_len_for_sort 20 ft_stopword_file (built-in) have_bdb NO have_crypt YES have_innodb DISABLED have_isam YES have_raid NO have_symlink YES have_openssl NO have_query_cache YES init_file innodb_additional_mem_pool_size 1048576 innodb_buffer_pool_size 8388608 innodb_data_file_path innodb_data_home_dir innodb_file_io_threads 4 innodb_force_recovery 0 innodb_thread_concurrency 8 innodb_flush_log_at_trx_commit 1 innodb_fast_shutdown ON innodb_flush_method innodb_lock_wait_timeout 50 innodb_log_arch_dir innodb_log_archive OFF innodb_log_buffer_size 1048576 innodb_log_file_size 5242880 innodb_log_files_in_group 2 innodb_log_group_home_dir innodb_mirrored_log_groups 1 innodb_max_dirty_pages_pct 90 interactive_timeout 28800 join_buffer_size 131072 key_buffer_size 1073741824 language /usr/mysql/share/mysql/english/ large_files_support ON license GPL local_infile ON locked_in_memory OFF log OFF log_update OFF log_bin ON log_slave_updates OFF log_slow_queries OFF log_warnings ON long_query_time 10 low_priority_updates OFF lower_case_file_system OFF lower_case_table_names 0 max_allowed_packet 8387584 max_binlog_cache_size 4294967295 max_binlog_size 1073741824 max_connections 1000 max_connect_errors 200 max_delayed_threads 20 max_insert_delayed_threads 20 max_heap_table_size 16777216 max_join_size 4294967295 max_relay_log_size 0 max_seeks_for_key 4294967295 max_sort_length 1024 max_user_connections 0 max_tmp_tables 32 max_write_lock_count 4294967295 myisam_max_extra_sort_file_size 268435456 myisam_max_sort_file_size 2147483647 myisam_repair_threads 1 myisam_recover_options OFF myisam_sort_buffer_size 67108864 net_buffer_length 8192 net_read_timeout 30 net_retry_count 10 net_write_timeout 60 new OFF open_files_limit 5010 pid_file /usr/mysql/var/mysqld.pid log_error port 3306 protocol_version 10 query_alloc_block_size 8192 query_cache_limit 1048576 query_cache_size 0 query_cache_type ON query_prealloc_size 8192 range_alloc_block_size 2048 read_buffer_size 8384512 read_only OFF read_rnd_buffer_size 262144 rpl_recovery_rank 0 server_id 1 slave_net_timeout 3600 skip_external_locking ON skip_networking OFF skip_show_database OFF slow_launch_time 2 socket /tmp/mysql.sock sort_buffer_size 8388600 sql_mode 0 table_cache 1024 table_type MYISAM thread_cache_size 10 thread_concurrency 10 thread_stack 196608 tx_isolation REPEATABLE-READ timezone CST tmp_table_size 33554432 tmpdir /var/tmp/ transaction_alloc_block_size 8192 transaction_prealloc_size 4096 version 4.0.20-log version_comment Source distribution version_compile_os sun-solaris2.9 wait_timeout 28800
