Too Big Created_tmp_disk_tables percent

[dead.link2]

Hi,

I have a problem with MySQL: 4.1.13.

[mysqld]
socket=/var/lib/mysql/mysql.sock
connect_timeout=20
max_connections=200
skip-networking
long_query_time=4
key_buffer_size=32M
max_allowed_packet = 32M
log-slow-queries = /var/log/mysql/slow-query.log
thread_cache_size=8
thread_concurrency = 8
thread_stack = 128k
table_cache=32k
join_buffer_size=1M
read_buffer_size = 2M
sort_buffer_size = 16M
myisam_sort_buffer_size=32M
read_rnd_buffer_size=2M
wait_timeout=60
interactive_timeout=60
tmp_table_size = 64M
max_tmp_tables = 1024
query_cache_size = 16M
# tmpdir = /tmp/
[safe_mysqld]
err-log = /var/log/mysql/info.log

My status:
Aborted_clients 138
Aborted_connects 7091
Binlog_cache_disk_use 0
Binlog_cache_use 0
Bytes_received 98641149
Bytes_sent 340420875
Com_admin_commands 1
Com_alter_db 0
Com_alter_table 0
Com_analyze 0
Com_backup_table 0
Com_begin 0
Com_change_db 416909
Com_change_master 0
Com_check 0
Com_checksum 0
Com_commit 0
Com_create_db 0
Com_create_function 0
Com_create_index 0
Com_create_table 0
Com_dealloc_sql 0
Com_delete 23707
Com_delete_multi 0
Com_do 0
Com_drop_db 0
Com_drop_function 0
Com_drop_index 0
Com_drop_table 0
Com_drop_user 0
Com_execute_sql 0
Com_flush 0
Com_grant 0
Com_ha_close 0
Com_ha_open 0
Com_ha_read 0
Com_help 0
Com_insert 8560
Com_insert_select 59
Com_kill 0
Com_load 0
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 0
Com_optimize 0
Com_preload_keys 0
Com_prepare_sql 0
Com_purge 0
Com_purge_before_date 0
Com_rename_table 0
Com_repair 0
Com_replace 0
Com_replace_select 0
Com_reset 0
Com_restore_table 0
Com_revoke 0
Com_revoke_all 0
Com_rollback 0
Com_savepoint 0
Com_select 184319
Com_set_option 60
Com_show_binlog_events 0
Com_show_binlogs 12
Com_show_charsets 15
Com_show_collations 15
Com_show_column_types 0
Com_show_create_db 0
Com_show_create_table 0
Com_show_databases 1
Com_show_errors 0
Com_show_fields 0
Com_show_grants 4
Com_show_innodb_status 0
Com_show_keys 0
Com_show_logs 0
Com_show_master_status 0
Com_show_new_master 0
Com_show_open_tables 0
Com_show_privileges 0
Com_show_processlist 1
Com_show_slave_hosts 0
Com_show_slave_status 0
Com_show_status 80
Com_show_storage_engines 0
Com_show_tables 6
Com_show_variables 67
Com_show_warnings 0
Com_slave_start 0
Com_slave_stop 0
Com_stmt_prepare 0
Com_stmt_execute 0
Com_stmt_send_long_data 0
Com_stmt_reset 0
Com_stmt_close 0
Com_truncate 0
Com_unlock_tables 0
Com_update 17652
Com_update_multi 0
Connections 269831
Created_tmp_disk_tables 12882
Variable_name Value
Created_tmp_files 3
Created_tmp_tables 16788
Delayed_errors 0
Delayed_insert_threads 0
Delayed_writes 0
Flush_commands 1
Handler_commit 0
Handler_delete 8219
Handler_discover 0
Handler_read_first 24538
Handler_read_key 1586129
Handler_read_next 22104647
Handler_read_prev 146690
Handler_read_rnd 483912
Handler_read_rnd_next 11741955
Handler_rollback 0
Handler_update 523705
Handler_write 1504420
Key_blocks_not_flushed 0
Key_blocks_unused 21907
Key_blocks_used 7090
Key_read_requests 7368220
Key_reads 19551
Key_write_requests 254235
Key_writes 28361
Max_used_connections 53
Not_flushed_delayed_rows 0
Open_files 233
Open_streams 0
Open_tables 149
Opened_tables 160
Qcache_free_blocks 2977
Qcache_free_memory 10695768
Qcache_hits 286937
Qcache_inserts 183662
Qcache_lowmem_prunes 4041
Qcache_not_cached 383
Qcache_queries_in_cache 3791
Qcache_total_blocks 10624
Questions 1201494
Rpl_status NULL
Select_full_join 220
Select_full_range_join 0
Select_range 19932
Select_range_check 0
Select_scan 2349
Slave_open_temp_tables 0
Slave_running OFF
Slave_retried_transactions 0
Slow_launch_threads 0
Slow_queries 12
Sort_merge_passes 0
Sort_range 7688
Sort_rows 827909
Sort_scan 14525
Table_locks_immediate 272232
Table_locks_waited 88
Threads_cached 7
Threads_connected 1
Threads_created 138
Threads_running 1
Uptime 12054


So the problem is:
Created_tmp_disk_tables 12882
Created_tmp_tables 16788

I can't succes to have 80% in memory, I have 76% but on disk.

I try to increase tmp_table_size (128,256) but I have always this bad percent.

Someone can help me ? I must change an other parameter ?