Hi,
MySQL is creating about 50% of temp tables on disk and this is with 10Meg of
temp table cache. Is this normal? and sould I up temp table cache further.
Below is the output from SHOW STATUS
Cheers
John Wards
SportNetwork.net
Var Name Value
Aborted_clients 19559
Aborted_connects 12
Bytes_received 144045478
Bytes_sent 657420475
Connections 116006
Created_tmp_disk_tables 28024
Created_tmp_tables 55934
Created_tmp_files 0
Delayed_insert_threads 0
Delayed_writes 0
Delayed_errors 0
Flush_commands 1
Handler_delete 5720
Handler_read_first 78755
Handler_read_key 100387564
Handler_read_next 146147564
Handler_read_prev 486
Handler_read_rnd 11027161
Handler_read_rnd_next 87804710
Handler_update 83081194
Handler_write 39761449
Key_blocks_used 15029
Key_read_requests 24357959
Key_reads 12428
Key_write_requests 521710
Key_writes 490850
Max_used_connections 61
Not_flushed_key_blocks 0
Not_flushed_delayed_rows 0
Open_tables 647
Open_files 88184
Open_streams 0
Opened_tables 813
Questions 1449450
Select_full_join 4551
Select_full_range_join 0
Select_range 117053
Select_range_check 0
Select_scan 57218
Slave_running OFF
Slave_open_temp_tables 0
Slow_launch_threads 0
Slow_queries 39
Sort_merge_passes 0
Sort_range 203689
Sort_rows 16225004
Sort_scan 55552
Table_locks_immediate 1361074
Table_locks_waited 1841
Threads_cached 43
Threads_created 62
Threads_connected 19
Threads_running 1
Uptime 61862
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
