Greetings List,
I'm running a dedicated MySQL server on a Dell PE 2550, dual proc. 4GB
RAM. Its using the Dell PERC 3/Di Scsi RAID controller with 18GB disks. I
running RH 7.3 with the latest updates(Kernel 2.4.20-19.7smp). The MySQL
version is the rpm currently being provided by the RH updates. I have been
trying to tune the MySql daemon for a week now to prevent swapping. No
matter what I do, I still end up with about 60GB of used swap space.
Any suggestions on what I'm doing wrong? TIA for any suggestions/help!
Pertinent info is below:
Regards,
tom.
***free****
total used free shared buffers cached
Mem: 3874616 3862912 11704 0 24620 3465232
-/+ buffers/cache: 373060 3501556
Swap: 2040244 60552 1979692
***mysql daemon info from top*****
26013 root 9 0 1076 892 888 S 0.0 0.0 0:00 safe_mysqld
26046 mysql 9 0 258M 258M 1652 S 0.0 6.8 0:10 mysqld
26048 mysql 8 0 258M 258M 1652 S 0.0 6.8 0:01 mysqld
26049 mysql 9 0 258M 258M 1652 S 0.0 6.8 3:19 mysqld
26228 mysql 9 0 258M 258M 1652 S 0.0 6.8 22:30 mysqld
27229 mysql 9 0 258M 258M 1652 S 0.0 6.8 1:08 mysqld
27634 mysql 9 0 258M 258M 1652 S 0.0 6.8 1:15 mysqld
27639 mysql 9 0 258M 258M 1652 S 0.0 6.8 0:49 mysqld
28031 mysql 9 0 258M 258M 1652 S 0.0 6.8 0:59 mysqld
28841 mysql 9 0 258M 258M 1652 S 0.0 6.8 28:49 mysqld
2593 mysql 9 0 258M 258M 1652 S 0.0 6.8 0:00 mysqld
2725 mysql 9 0 258M 258M 1652 S 0.0 6.8 0:00 mysqld
***my.cnf:***
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
skip-innodb
skip-bdb
set-variable = key_buffer=256M
set-variable = max_allowed_packet=1M
set-variable = table_cache=256
set-variable = sort_buffer=2M
set-variable = record_buffer=1M
set-variable = record_rnd_buffer=1M
set-variable = myisam_sort_buffer_size=32M
set-variable = thread_cache=8
set-variable = max_connections=150
#set-variable = thread_concurrency=4
set-variable = wait_timeout=300
set-variable = max_binlog_cache_size=2M
set-variable = max_binlog_size=2M
set-variable = bdb_cache_size=0
set-variable = bdb_log_buffer_size=0
set-variable = innodb_additional_mem_pool_size=0
set-variable = innodb_buffer_pool_size=0
set-variable = innodb_log_buffer_size=0
set-variable = innodb_log_file_size=0
server-id = 1
tmpdir = /var/tmp/
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
***mysqladmin variables***
+---------------------------------+------
| Variable_name | Value
+---------------------------------+------
| back_log | 50
| basedir | /usr/
| bdb_cache_size | 20480
| bdb_log_buffer_size | 262144
| bdb_home |
| bdb_max_lock | 10000
| bdb_logdir |
| bdb_shared_data | OFF
| bdb_tmpdir |
| bdb_version | Sleepycat Software: Berkeley DB 3.2.9a:
(March 13, 2003)
| binlog_cache_size | 32768
| character_set | latin1
| character_sets | latin1 big5 cp1251 cp1257 croat czech
danish dec8 dos
| | estonia euc_kr gb2312 gbk german1 greek hebrew hp8
| | hungarian koi8_ru koi8_ukr latin2 latin5 swe7 usa7
| | win1250 win1251 win1251ukr ujis sjis tis620
| concurrent_insert | ON
| connect_timeout | 5
| datadir | /var/lib/mysql/
| delay_key_write | ON
| delayed_insert_limit | 100
| delayed_insert_timeout | 300
| delayed_queue_size | 1000
| flush | OFF
| flush_time | 0
| have_bdb | DISABLED
| have_gemini | NO
| have_innodb | DISABLED
| have_isam | YES
| have_raid | NO
| have_openssl | NO
| init_file |
| innodb_additional_mem_pool_size | 524288
| innodb_buffer_pool_size | 1048576
| innodb_data_file_path |
| innodb_data_home_dir |
| innodb_file_io_threads | 4
| innodb_force_recovery | 0
| innodb_thread_concurrency | 8
| innodb_flush_log_at_trx_commit | 0
| innodb_fast_shutdown | ON
| innodb_flush_method |
| innodb_lock_wait_timeout | 50
| innodb_log_arch_dir |
| innodb_log_archive | OFF
| innodb_log_buffer_size | 262144
| innodb_log_file_size | 1048576
| innodb_log_files_in_group | 2
| innodb_log_group_home_dir |
| innodb_mirrored_log_groups | 1
| interactive_timeout | 28800
| join_buffer_size | 131072
| key_buffer_size | 268431360
| language | /usr/share/mysql/english/
| large_files_support | ON
| locked_in_memory | OFF
| log | OFF
| log_update | OFF
| log_bin | OFF
| log_slave_updates | OFF
| log_long_queries | OFF
| long_query_time | 10
| low_priority_updates | OFF
| lower_case_table_names | 0
| max_allowed_packet | 1047552
| max_binlog_cache_size | 2097152
| max_binlog_size | 2097152
| max_connections | 150
| max_connect_errors | 10
| max_delayed_threads | 20
| max_heap_table_size | 16777216
| max_join_size | 4294967295
| max_sort_length | 1024
| max_user_connections | 0
| max_tmp_tables | 32
| max_write_lock_count | 4294967295
| myisam_max_extra_sort_file_size | 256
| myisam_max_sort_file_size | 2047
| myisam_recover_options | 0
| myisam_sort_buffer_size | 33554432
| net_buffer_length | 16384
| net_read_timeout | 30
| net_retry_count | 10
| net_write_timeout | 60
| open_files_limit | 0
| pid_file | /var/run/mysqld/mysqld.pid
| port | 3306
| protocol_version | 10
| record_buffer | 1044480
| record_rnd_buffer | 1044480
| query_buffer_size | 0
| safe_show_database | OFF
| server_id | 1
| slave_net_timeout | 3600
| skip_locking | ON
| skip_networking | OFF
| skip_show_database | OFF
| slow_launch_time | 2
| socket | /var/lib/mysql/mysql.sock
| sort_buffer | 2097144
| sql_mode | 0
| table_cache | 256
| table_type | MYISAM
| thread_cache_size | 8
| thread_stack | 65536
| transaction_isolation | READ-COMMITTED
| timezone | EDT
| tmp_table_size | 33554432
| tmpdir | /var/tmp/
| version | 3.23.56
| wait_timeout | 300
+---------------------------------+----
*****mysqladmin extended-status******
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 175 |
| Aborted_connects | 0 |
| Bytes_received | 1858446791 |
| Bytes_sent | 863435973 |
| Com_admin_commands | 0 |
| Com_alter_table | 0 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 0 |
| 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 | 13 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 0 |
| Com_flush | 0 |
| Com_grant | 0 |
| Com_insert | 6191754 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 0 |
| Com_optimize | 0 |
| Com_purge | 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_rollback | 0 |
| Com_select | 8563389 |
| Com_set_option | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 0 |
| Com_show_databases | 0 |
| Com_show_fields | 0 |
| Com_show_grants | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 2 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 0 |
| Com_show_variables | 3 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 2395953 |
| Connections | 181301 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_tables | 42 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 9 |
| Handler_read_first | 1 |
| Handler_read_key | 16906338 |
| Handler_read_next | 2499823 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 1660 |
| Handler_read_rnd_next | 26464 |
| Handler_update | 2320880 |
| Handler_write | 6193404 |
| Key_blocks_used | 249376 |
| Key_read_requests | 201172027 |
| Key_reads | 12482200 |
| Key_write_requests | 18954479 |
| Key_writes | 19013760 |
| Max_used_connections | 27 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 28 |
| Open_files | 48 |
| Open_streams | 0 |
| Opened_tables | 34 |
| Questions | 17332238 |
| Select_full_join | 0 |
| Select_full_range_join | 0 |
| Select_range | 66 |
| Select_range_check | 0 |
| Select_scan | 32 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 1 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 0 |
| Sort_rows | 1660 |
| Sort_scan | 43 |
| Table_locks_immediate | 23076339 |
| Table_locks_waited | 0 |
| Threads_cached | 7 |
| Threads_created | 49 |
| Threads_connected | 1 |
| Threads_running | 1 |
| Uptime | 337415 |
+--------------------------+------------+
_______________________
Tom Mattison
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
