hi you can find mysql recommendations of my.cnf parameters based on on RAM size in /usr/local/mysql/support-files with file name my-huge.cnf go through those files and set parameters accordingly for most of databases it will work fine.
Anil -----Original Message----- From: Fagyal Csongor [mailto:[EMAIL PROTECTED] Sent: Monday, December 13, 2004 5:36 AM To: [EMAIL PROTECTED] Subject: Are these variables "healthy"? Hi, I am running an instance of MySQL 4.0.16, mostly using MyISAM tables on a 18G 10kRPM SCSI drive w/ ext3, the server having 2G RAM and a 2.8G HT P4, on a RedHat 9 install. Would some of you experts be so kind to take a look at the variables I have, and tell me if anything is wrong? I think the server is using a little too much I/O, but I am not sure... maybe I could tune something? my.cnf (only the relevant parts): skip-locking wait_timeout = 1800 interactive_timeout = 1800 max_connections=300 key_buffer=32M max_allowed_packet=1M table_cache=1024 sort_buffer=2M record_buffer=1M myisam_sort_buffer_size=4M thread_cache=4 log=/var/log/mysqld-query.log log-slow-queries=/var/log/mysqld-slow.log tmpdir=/tmp/ query_cache_limit=128k query_cache_size=16M query_cache_type=1 STATUS: Threads: 51 Questions: 967003 Slow queries: 2 Opens: 135 Flush tables: 1 Open tables: 125 Queries per second avg: 81.016 SHOW STATUS: +--------------------------+-----------+ | Variable_name | Value | +--------------------------+-----------+ | Aborted_clients | 1406 | | Aborted_connects | 1 | | Bytes_received | 77777285 | | Bytes_sent | 319972773 | | Com_admin_commands | 668953 | | Com_alter_table | 1 | | Com_analyze | 0 | | Com_backup_table | 0 | | Com_begin | 0 | | Com_change_db | 4675 | | Com_change_master | 0 | | Com_check | 0 | | Com_commit | 0 | | Com_create_db | 0 | | Com_create_function | 0 | | Com_create_index | 0 | | Com_create_table | 0 | | Com_delete | 211 | | Com_delete_multi | 0 | | Com_drop_db | 0 | | Com_drop_function | 0 | | Com_drop_index | 0 | | Com_drop_table | 0 | | Com_flush | 0 | | Com_grant | 0 | | Com_ha_close | 0 | | Com_ha_open | 0 | | Com_ha_read | 0 | | Com_insert | 17890 | | Com_insert_select | 0 | | Com_kill | 0 | | Com_load | 0 | | Com_load_master_data | 0 | | Com_load_master_table | 0 | | Com_lock_tables | 1 | | Com_optimize | 0 | | Com_purge | 0 | | Com_rename_table | 0 | | Com_repair | 0 | | Com_replace | 64 | | Com_replace_select | 0 | | Com_reset | 0 | | Com_restore_table | 0 | | Com_revoke | 0 | | Com_rollback | 0 | | Com_savepoint | 0 | | Com_select | 162423 | | Com_set_option | 0 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 0 | | Com_show_create | 0 | | Com_show_databases | 28 | | Com_show_fields | 3926 | | Com_show_grants | 0 | | Com_show_keys | 20 | | Com_show_logs | 0 | | Com_show_master_status | 0 | | Com_show_new_master | 0 | | Com_show_open_tables | 0 | | Com_show_processlist | 0 | | Com_show_slave_hosts | 0 | | Com_show_slave_status | 0 | | Com_show_status | 4 | | Com_show_innodb_status | 0 | | Com_show_tables | 140 | | Com_show_variables | 0 | | Com_slave_start | 0 | | Com_slave_stop | 0 | | Com_truncate | 0 | | Com_unlock_tables | 0 | | Com_update | 31543 | | Connections | 14178 | | Created_tmp_disk_tables | 0 | | Created_tmp_tables | 8708 | | Created_tmp_files | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_commit | 0 | | Handler_delete | 178 | | Handler_read_first | 37 | | Handler_read_key | 25041603 | | Handler_read_next | 83330028 | | Handler_read_prev | 28 | | Handler_read_rnd | 533774 | | Handler_read_rnd_next | 121555664 | | Handler_rollback | 131 | | Handler_update | 5826935 | | Handler_write | 352980 | | Key_blocks_used | 6410 | | Key_read_requests | 42623992 | | Key_reads | 6062 | | Key_write_requests | 42502 | | Key_writes | 39145 | | Max_used_connections | 101 | | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 125 | | Open_files | 200 | | Open_streams | 0 | | Opened_tables | 135 | | Questions | 968371 | | Qcache_queries_in_cache | 8030 | | Qcache_inserts | 162339 | | Qcache_hits | 734025 | | Qcache_lowmem_prunes | 5455 | | Qcache_not_cached | 84 | | Qcache_free_memory | 7005176 | | Qcache_free_blocks | 2533 | | Qcache_total_blocks | 18644 | | Rpl_status | NULL | | Select_full_join | 0 | | Select_full_range_join | 1143 | | Select_range | 82 | | Select_range_check | 0 | | Select_scan | 3524 | | Slave_open_temp_tables | 0 | | Slave_running | OFF | | Slow_launch_threads | 0 | | Slow_queries | 2 | | Sort_merge_passes | 0 | | Sort_range | 5175 | | Sort_rows | 879029 | | Sort_scan | 8728 | | Table_locks_immediate | 218117 | | Table_locks_waited | 255 | | Threads_cached | 1 | | Threads_created | 1264 | | Threads_connected | 52 | | Threads_running | 1 | | Uptime | 11963 | +--------------------------+-----------+ Thank you, - Csongor -- 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]
