Re: Solaris Performance Issue
On Mon, Jul 12, 2004 at 10:14:09AM +0800, Linda wrote: Hi Jeremy, I didn't find any resouce limit but the performace is very bad. Do you have any suggestion how to tune the solaris to provide the better performance for Solaris? Well, MySQL doesn't just randomly slow down. There's either a software or hardware cause. If you're not maxing out your memory, CPU, or disk bandwidth it's probably a software problem. And, not being a Solaris expert, I don't know where to start if you think the OS is the culprit. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Solaris Performance Issue
Hi Jeremy, I didn't find any resouce limit but the performace is very bad. Do you have any suggestion how to tune the solaris to provide the better performance for Solaris? Linda - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Linda [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, July 10, 2004 6:06 AM Subject: Re: Solaris Performance Issue On Wed, Jul 07, 2004 at 06:23:45PM +0800, Linda wrote: 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. Without knowing what sort of bottlenecks you're seeing, it's really hard to say. What's the resource limit? CPU? Disk? RAM? BTW, I've found Sun boxes of that vintage (I have MySQL on a 280R also) to be quite a bit slower than much cheaper Intel hardware. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Solaris Performance Issue
On Wed, Jul 07, 2004 at 06:23:45PM +0800, Linda wrote: 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. Without knowing what sort of bottlenecks you're seeing, it's really hard to say. What's the resource limit? CPU? Disk? RAM? BTW, I've found Sun boxes of that vintage (I have MySQL on a 280R also) to be quite a bit slower than much cheaper Intel hardware. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ [book] High Performance MySQL -- http://highperformancemysql.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Solaris Performance Issue
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_log50 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_limit100 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_sort20 ft_stopword_file(built-in) have_bdbNO have_crypt YES have_innodb DISABLED have_isam YES have_raid NO have_symlinkYES have_opensslNO have_query_cacheYES 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_shutdownON innodb_flush_method innodb_lock_wait_timeout50 innodb_log_arch_dir innodb_log_archive OFF innodb_log_buffer_size 1048576 innodb_log_file_size5242880 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_size131072 key_buffer_size 1073741824 language/usr/mysql/share/mysql/english/ large_files_support ON license GPL local_infileON locked_in_memoryOFF log OFF log_update OFF log_bin ON log_slave_updates OFF log_slow_queriesOFF log_warningsON long_query_time 10 low_priority_updatesOFF 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_connections0 max_tmp_tables 32 max_write_lock_count4294967295 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_timeout30 net_retry_count 10 net_write_timeout 60 new OFF open_files_limit5010 pid_file/usr/mysql/var/mysqld.pid log_error port3306 protocol_version10 query_alloc_block_size 8192 query_cache_limit 1048576 query_cache_size0 query_cache_typeON query_prealloc_size 8192 range_alloc_block_size 2048 read_buffer_size8384512 read_only OFF read_rnd_buffer_size262144 rpl_recovery_rank 0 server_id 1 slave_net_timeout 3600 skip_external_locking ON skip_networking OFF skip_show_database OFF slow_launch_time2 socket /tmp/mysql.sock sort_buffer_size8388600 sql_mode0 table_cache 1024 table_type MYISAM thread_cache_size 10 thread_concurrency 10 thread_stack196608 tx_isolationREPEATABLE-READ timezoneCST tmp_table_size 33554432 tmpdir /var/tmp/ transaction_alloc_block_size8192 transaction_prealloc_size 4096 version 4.0.20-log version_comment Source distribution version_compile_os sun-solaris2.9 wait_timeout28800