here is the complete report MySQL 4.1.11-Debian_4sa uptime 0 17:16:20 Thu Dec 27 20:51:28 2007 __ Key _________________________________________________________________ Buffer used 36.88M of 768.00M %Used: 4.80 Current 123.43M %Usage: 16.07 Write hit 79.50% Read hit 99.90% __ Questions ___________________________________________________________ Total 2.31M 37.1/s QC Hits 1.40M 22.6/s %Total: 60.85 DMS 628.42k 10.1/s 27.24 Com_ 170.15k 2.7/s 7.37 COM_QUIT 106.02k 1.7/s 4.60 -Unknown 1.29k 0.0/s 0.06 Slow 229.76k 3.7/s 9.96 %DMS: 36.56 DMS 628.42k 10.1/s 27.24 SELECT 489.50k 7.9/s 21.22 77.89 INSERT 87.47k 1.4/s 3.79 13.92 DELETE 32.72k 0.5/s 1.42 5.21 UPDATE 18.73k 0.3/s 0.81 2.98 REPLACE 0 0/s 0.00 0.00 Com_ 170.15k 2.7/s 7.37 change_db 124.67k 2.0/s 5.40 set_option 9.05k 0.1/s 0.39 show_tables 8.80k 0.1/s 0.38 __ SELECT and Sort _____________________________________________________ Scan 61.54k 1.0/s %SELECT: 12.57 Range 7.43k 0.1/s 1.52 Full join 179.58k 2.9/s 36.69 Range check 0 0/s 0.00 Full rng join 17 0.0/s 0.00 Sort scan 279.00k 4.5/s Sort range 51.45k 0.8/s Sort mrg pass 0 0/s __ Query Cache _________________________________________________________ Memory usage 355.04M of 1.25G %Used: 27.74 Block Fragmnt 0.00% Hits 1.40M 22.6/s Inserts 455.81k 7.3/s Insrt:Prune 455.81k:1 7.3/s Hit:Insert 3.08:1 __ Table Locks _________________________________________________________ Waited 272 0.0/s %Total: 0.02 Immediate 1.30M 20.9/s __ Tables ______________________________________________________________ Open 6956 of 1228 %Cache: 56.61 Opened 7.90k 0.1/s __ Connections _________________________________________________________ Max used 23 of 400 %Max: 5.75 Total 112.27k 1.8/s __ Created Temp ________________________________________________________ Disk table 143.70k 2.3/s Table 285.66k 4.6/s File 0 0/s __ Threads _____________________________________________________________ Running 1 of 4 Cached 19 of 128 %Hit: 99.98 Created 23 0.0/s Slow 0 0/s __ Aborted _____________________________________________________________ Clients 12.50k 0.2/s Connects 28 0.0/s __ Bytes _______________________________________________________________ Sent 200.00M 3.2k/s Received 325.67M 5.2k/s here is the status output Variable_name Value Aborted_clients 12849 Aborted_connects 28 Binlog_cache_disk_use 0 Binlog_cache_use 0 Bytes_received 331400756 Bytes_sent 377046211 Com_admin_commands 1353 Com_alter_db 1 Com_alter_table 442 Com_analyze 0 Com_backup_table 0 Com_begin 0 Com_change_db 127143 Com_change_master 0 Com_check 6759 Com_checksum 0 Com_commit 0 Com_create_db 7 Com_create_function 0 Com_create_index 0 Com_create_table 199 Com_dealloc_sql 0 Com_delete 33562 Com_delete_multi 0 Com_do 0 Com_drop_db 6 Com_drop_function 0 Com_drop_index 0 Com_drop_table 199 Com_drop_user 0 Com_execute_sql 0 Com_flush 320 Com_grant 7 Com_ha_close 0 Com_ha_open 0 Com_ha_read 0 Com_help 0 Com_insert 87821 Com_insert_select 0 Com_kill 0 Com_load 0 Com_load_master_data 0 Com_load_master_table 0 Com_lock_tables 562 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 1 Com_revoke_all 0 Com_rollback 0 Com_savepoint 0 Com_select 498233 Com_set_option 9067 Com_show_binlog_events 0 Com_show_binlogs 1 Com_show_charsets 2 Com_show_collations 2 Com_show_column_types 0 Com_show_create_db 17 Com_show_create_table 8722 Com_show_databases 16 Com_show_errors 0 Com_show_fields 8040 Com_show_grants 0 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 0 Com_show_slave_hosts 0 Com_show_slave_status 0 Com_show_status 260 Com_show_storage_engines 2 Com_show_tables 8796 Com_show_variables 293 Com_show_warnings 0 Com_slave_start 0 Com_slave_stop 0 Com_truncate 0 Com_unlock_tables 562 Com_update 19225 Com_update_multi 0 Connections 114754 Created_tmp_disk_tables 146496 Created_tmp_files 0 Created_tmp_tables 291167 Delayed_errors 0 Delayed_insert_threads 0 Delayed_writes 0 Flush_commands 1 Handler_commit 0 Handler_delete 29951 Handler_discover 0 Handler_read_first 56335 Handler_read_key 44723444 Handler_read_next 60122916 Handler_read_prev 4302 Handler_read_rnd 5193956 Handler_read_rnd_next 550411192 Handler_rollback 0 Handler_update 25399057 Handler_write 12124314 Key_blocks_not_flushed 0 Key_blocks_unused 659797 Key_blocks_used 38004 Key_read_requests 45699112 Key_reads 44712 Key_write_requests 517417 Key_writes 107260 Max_used_connections 23 Not_flushed_delayed_rows 0 Open_files 13670 Open_streams 0 Open_tables 6956 Opened_tables 7896 Qcache_free_blocks 28 Qcache_free_memory 961952520 Qcache_hits 1431784 Qcache_inserts 463843 Qcache_lowmem_prunes 0 Qcache_not_cached 34387 Qcache_queries_in_cache 274123 Qcache_total_blocks 550090 Questions 2350318 Rpl_status NULL Select_full_join 182596 Select_full_range_join 17 Select_range 7541 Select_range_check 0 Select_scan 62168 Slave_open_temp_tables 0 Slave_running OFF Slave_retried_transactions 0 Slow_launch_threads 0 Slow_queries 233286 Sort_merge_passes 0 Sort_range 52556 Sort_rows 13678943 Sort_scan 284102 Table_locks_immediate 1325953 Table_locks_waited 274 Threads_cached 15 Threads_connected 8 Threads_created 23 Threads_running 1 Uptime 63614 and variables Variable_name Value back_log 50 basedir /usr/ bdb_cache_size 8388600 bdb_home /var/lib/mysql/ bdb_log_buffer_size 6291456 bdb_logdir bdb_max_lock 10000 bdb_shared_data OFF bdb_tmpdir /tmp/ binlog_cache_size 32768 bulk_insert_buffer_size 8388608 character_set_client latin1 character_set_connection latin1 character_set_database latin1 character_set_results latin1 character_set_server latin1 character_set_system utf8 character_sets_dir /usr/share/mysql/charsets/ collation_connection latin1_swedish_ci collation_database latin1_swedish_ci collation_server latin1_swedish_ci concurrent_insert ON connect_timeout 10 datadir /var/lib/mysql/ date_format %Y-%m-%d datetime_format %Y-%m-%d %H:%i:%s default_week_format 0 delay_key_write ON delayed_insert_limit 100 delayed_insert_timeout 300 delayed_queue_size 1000 expire_logs_days 0 flush OFF flush_time 0 ft_boolean_syntax + -><()~*:""&| ft_max_word_len 84 ft_min_word_len 4 ft_query_expansion_limit 20 ft_stopword_file (built-in) group_concat_max_len 1024 have_archive YES have_bdb YES have_blackhole_engine NO have_compress YES have_crypt YES have_csv YES have_example_engine NO have_geometry YES have_innodb DISABLED have_isam YES have_ndbcluster DISABLED have_openssl NO have_query_cache YES have_raid YES have_rtree_keys YES have_symlink YES init_connect init_file init_slave innodb_additional_mem_pool_size 1048576 innodb_autoextend_increment 8 innodb_buffer_pool_awe_mem_mb 0 innodb_buffer_pool_size 8388608 innodb_data_file_path innodb_data_home_dir innodb_fast_shutdown ON innodb_file_io_threads 4 innodb_file_per_table OFF innodb_flush_log_at_trx_commit 1 innodb_flush_method innodb_force_recovery 0 innodb_lock_wait_timeout 50 innodb_locks_unsafe_for_binlog OFF 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_max_dirty_pages_pct 90 innodb_max_purge_lag 0 innodb_mirrored_log_groups 1 innodb_open_files 300 innodb_table_locks ON innodb_thread_concurrency 8 interactive_timeout 15 join_buffer_size 1044480 key_buffer_size 805306368 key_cache_age_threshold 300 key_cache_block_size 1024 key_cache_division_limit 100 language /usr/share/mysql/english/ large_files_support ON license GPL local_infile ON locked_in_memory OFF log OFF log_bin OFF log_error log_slave_updates OFF log_slow_queries ON log_update OFF log_warnings 1 long_query_time 2 low_priority_updates OFF lower_case_file_system OFF lower_case_table_names 0 max_allowed_packet 1073740800 max_binlog_cache_size 4294967295 max_binlog_size 1073741824 max_connect_errors 10 max_connections 400 max_delayed_threads 20 max_error_count 64 max_heap_table_size 1805304832 max_insert_delayed_threads 20 max_join_size 4294967295 max_length_for_sort_data 1024 max_relay_log_size 0 max_seeks_for_key 4294967295 max_sort_length 1024 max_tmp_tables 256 max_user_connections 0 max_write_lock_count 4294967295 myisam_data_pointer_size 4 myisam_max_extra_sort_file_size 2147483648 myisam_max_sort_file_size 2147483647 myisam_recover_options OFF myisam_repair_threads 1 myisam_sort_buffer_size 8388608 ndb_autoincrement_prefetch_sz 32 ndb_force_send ON ndb_use_exact_count ON ndb_use_transactions ON net_buffer_length 16384 net_read_timeout 30 net_retry_count 10 net_write_timeout 60 new OFF old_passwords ON open_files_limit 24986 pid_file /var/run/mysqld/mysqld.pid port 3306 preload_buffer_size 32768 protocol_version 10 query_alloc_block_size 8192 query_cache_limit 134217728 query_cache_min_res_unit 4096 query_cache_size 1342177280 query_cache_type ON query_cache_wlock_invalidate OFF query_prealloc_size 8192 range_alloc_block_size 2048 read_buffer_size 2093056 read_only OFF read_rnd_buffer_size 2093056 relay_log_purge ON relay_log_space_limit 0 rpl_recovery_rank 0 secure_auth OFF server_id 0 skip_external_locking ON skip_networking OFF skip_show_database OFF slave_net_timeout 3600 slave_transaction_retries 0 slow_launch_time 2 socket /var/run/mysqld/mysqld.sock sort_buffer_size 6291456 sql_mode storage_engine MyISAM sql_notes ON sql_warnings ON sync_binlog 0 sync_replication 0 sync_replication_slave_id 0 sync_replication_timeout 0 sync_frm ON system_time_zone CET table_cache 12288 table_type MyISAM thread_cache_size 128 thread_stack 2093056 time_format %H:%i:%s time_zone SYSTEM tmp_table_size 4147483648 tmpdir /tmp transaction_alloc_block_size 8192 transaction_prealloc_size 4096 tx_isolation REPEATABLE-READ version 4.1.11-Debian_4sarge8-log version_bdb Sleepycat Software: Berkeley DB 4.1.24: (April 1, 2005) version_comment Source distribution version_compile_machine i386 version_compile_os pc-linux-gnu wait_timeout 15