Turns out the Linux table_cache was 457 to Solaris 64.
Could that have been all the speed difference ?
- Sam.
Solaris
mysql> show variables;
+-------------------------+-----------------------------------------------------
------+
| Variable_name | Value
|
+-------------------------+-----------------------------------------------------
------+
| ansi_mode | OFF
|
| back_log | 50
|
| basedir | /export/home/mysql/app/mysql-3.23.33/
|
| binlog_cache_size | 32768
|
| character_set | latin1
|
| character_sets | latin1 cp1251
|
| concurrent_insert | ON
|
| connect_timeout | 5
|
| datadir | /export/home/mysql/app/mysql-3.23.33/var/
|
| delay_key_write | ON
|
| delayed_insert_limit | 100
|
| delayed_insert_timeout | 300
|
| delayed_queue_size | 1000
|
| flush | OFF
|
| flush_time | 0
|
| have_bdb | NO
|
| have_gemini | NO
|
| have_innobase | NO
|
| have_isam | YES
|
| have_raid | NO
|
| have_ssl | NO
|
| init_file |
|
| interactive_timeout | 28800
|
| join_buffer_size | 131072
|
| key_buffer_size | 67104768
|
| language | /export/home/mysql/app/mysql-3.23.33/share/mysql/eng
lish/ |
| large_files_support | ON
|
| locked_in_memory | OFF
|
| log | OFF
|
| log_update | OFF
|
| log_bin | OFF
|
| log_slave_updates | OFF
|
| long_query_time | 10
|
| low_priority_updates | OFF
|
| lower_case_table_names | 0
|
| max_allowed_packet | 1048576
|
| max_binlog_cache_size | 4294967295
|
| max_binlog_size | 1073741824
|
| max_connections | 100
|
| max_connect_errors | 10
|
| max_delayed_threads | 20
|
| max_heap_table_size | 16777216
|
| max_join_size | 4294967295
|
| max_sort_length | 1024
|
| max_tmp_tables | 32
|
| max_write_lock_count | 4294967295
|
| myisam_recover_options | OFF
|
| myisam_sort_buffer_size | 8388608
|
| net_buffer_length | 16384
|
| net_read_timeout | 30
|
| net_retry_count | 10
|
| net_write_timeout | 60
| open_files_limit | 0
|
| pid_file | /export/home/mysql/app/mysql-3.23.33/var/devel2.pid
|
| port | 3306
|
| protocol_version | 10
|
| record_buffer | 131072
|
| query_buffer_size | 0
|
| safe_show_database | OFF
|
| server_id | 0
|
| skip_locking | OFF
|
| skip_networking | OFF
|
| skip_show_database | OFF
|
| slow_launch_time | 2
|
| socket | /tmp/mysql.sock
|
| sort_buffer | 4194296
|
| table_cache | 64
|
| table_type | MYISAM
|
| thread_cache_size | 0
|
| thread_concurrency | 10
|
| thread_stack | 65536
|
| timezone | PST
|
| tmp_table_size | 1048576
|
| tmpdir | /var/tmp/
|
| version | 3.23.33
|
| wait_timeout | 28800
Linux :
mysql> show variables;
+-------------------------+-----------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------+
| Variable_name | Value
|
+-------------------------+-----------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------+
| ansi_mode | OFF
| back_log | 50
| basedir | /home/mysql/mysql-3.23.32-pc-linux-gnu-i686/
| binlog_cache_size | 32768
| character_set | latin1
| character_sets | latin1 big5 czech euc_kr gb2312 gbk sjis tis620 ujis
dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 esto
nia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON
| connect_timeout | 5
| datadir | /home/mysql/mysql-3.23.32-pc-linux-gnu-i686/data/
| delay_key_write | ON
| delayed_insert_limit | 100
| delayed_insert_timeout | 300
| delayed_queue_size | 1000
| flush | OFF
| flush_time | 0
| have_bdb | NO
| have_gemini | NO
| have_innobase | NO
| have_isam | YES
| have_raid | NO
| have_ssl | NO
| init_file |
| interactive_timeout | 28800
| join_buffer_size | 131072
| key_buffer_size | 67104768
| language | /home/mysql/mysql-3.23.32-pc-linux-gnu-i686/share/my
sql/english/
| large_files_support | ON
| locked_in_memory | OFF
| log | OFF
| log_update | OFF
| log_bin | OFF
| log_slave_updates | OFF
| long_query_time | 10
| low_priority_updates | OFF
| lower_case_table_names | 0
| max_allowed_packet | 1048576
| max_binlog_cache_size | 4294967295
| max_connections | 100
| max_connect_errors | 10
| max_delayed_threads | 20
| max_heap_table_size | 16777216
| max_join_size | 4294967295
| max_sort_length | 1024
| max_tmp_tables | 32
| max_write_lock_count | 4294967295
| myisam_recover_options | OFF
| myisam_sort_buffer_size | 8388608
| net_buffer_length | 16384
| net_read_timeout | 30
| net_retry_count | 10
| net_write_timeout | 60
| open_files_limit | 0
| pid_file |
| port | 3306
| protocol_version | 10
| record_buffer | 131072
| query_buffer_size | 0
| safe_show_database | OFF
| server_id | 0
| skip_locking | ON
| skip_networking | OFF
| skip_show_database | OFF
| slow_launch_time | 2
| socket | /tmp/mysql.sock
| sort_buffer | 4194296
| table_cache | 457
| table_type | MYISAM
| thread_cache_size | 0
| thread_stack | 65536
| timezone | PST
| tmp_table_size | 1048576
| tmpdir | /tmp/
| version | 3.23.32
| wait_timeout | 28800
---------------------------------
Do You Yahoo!?
Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.
