I run a couple of small motorcycle forums. One has an average of 100 people online all the time and the other about 20 online all the time. My server load seems to be normal and never had a problem but just wondered if it possible to edit the my.cnf file to help the sql out a little. I currently run the default RHE4 my.cnf file that reads
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
I run a single 3.06 P4 with 2 gigs of pc2700 DDR and 5 36gb SCSI 10k RPM Atlas drives using an adaptec controller in raid 5. For an OS I am runninge RHE4 with mysql 4.1.10a.
Thanks in advance
Max
I thought I would add some information to see if that helps
mysqladmin -u root -p extended-status
+--------------------------+------------+
Variable_name Value
+--------------------------+------------+
Aborted_clients 0
Aborted_connects 0
Binlog_cache_disk_use 0
Binlog_cache_use 0
Bytes_received 709965438
Bytes_sent 399423946
Com_admin_commands 0
Com_alter_db 0
Com_alter_table 0
Com_analyze 0
Com_backup_table 0
Com_begin 0
Com_change_db 216180
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 7086
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
MySQL General Discussion [Archive]::
Deleting Files Complex Question. MySQL in DOS. Counting rows problem optimize db. Get length of value in column. Accessing MYSQL via ADO in Visual C++, using DSN
http://www.mysqltalk.org/22-2003-5-2.phpHOME |
High Performance MySQL: Optimization, Backups, Replication, and Load ::
High Performance MySQL: Optimization, Backups, Replication, and Load answers for most of my questions on MySQL from the systems, high performance,
http://www.amazon.ca/High-Performance-MySQL-Optimization-Replication/dp/0596003064HOME |
Com_ha_read 0
Com_help 0
Com_insert 64335
Com_insert_select 424
Com_kill 0
Com_load 0
Com_load_master_data 0
Com_load_master_table 0
Com_lock_tables 4
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 8148
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 1730101
Com_set_option 321
Com_show_binlog_events 0
MySQL General Discussion [Archive]::
Bug in mysqldump or mysql-server 5.0? What does optimize mean? Question on mysql-test-run sp failed. Partition Linear Hast with function how expre
http://www.mysqltalk.org/22-2006-7-1.phpHOME |
Optimize::
Linux ext3 Filesystem The Future of Compiz In Question. Optimize last week to optimize the interaction between MySQL databases and Open-Xchange
http://www.linuxstreet.net/articles/OptimizeHOME |
Com_show_binlogs 0
Com_show_charsets 0
Com_show_collations 0
Com_show_column_types 0
Com_show_create_db 0
Com_show_create_table 315
Com_show_databases 5
Com_show_errors 0
Com_show_fields 315
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 4
Com_show_storage_engines 0
Com_show_tables 352
Com_show_variables 27
Com_show_warnings 0
Com_slave_start 0
Com_slave_stop 0
Com_truncate 0
Com_unlock_tables 4
Com_update 314862
Com_update_multi 0
Connections 3368732
Created_tmp_disk_tables 11966
Created_tmp_files 10026
Created_tmp_tables 49251
Delayed_errors 0
Delayed_insert_threads 0
Delayed_writes 0
Flush_commands 9
Handler_commit 0
Handler_delete 28999
Handler_discover 0
Handler_read_first 188344
Handler_read_key 44137861
Handler_read_next 40275140
Handler_read_prev 328074
Handler_read_rnd 33160697
Handler_read_rnd_next 1183492561
Handler_rollback 0
Handler_update 453539
Handler_write 14787074
Key_blocks_not_flushed 0
Key_blocks_unused 2522
Key_blocks_used 7248
Key_read_requests 91827403
Key_reads 675369
Key_write_requests 621220
Key_writes 132781
Max_used_connections 49
Not_flushed_delayed_rows 0
Open_files 123
Open_streams 0
Open_tables 64
Opened_tables 101932
Qcache_free_blocks 0
Qcache_free_memory 0
Qcache_hits 0
Qcache_inserts 0
Qcache_lowmem_prunes 0
Qcache_not_cached 0
Qcache_queries_in_cache 0
Qcache_total_blocks 0
Questions 39405137
Rpl_status NULL
Select_full_join 4216
Select_full_range_join 0
Select_range 591673
Select_range_check 0
Select_scan 306181
Slave_open_temp_tables 0
Slave_running OFF
Slow_launch_threads 0
Slow_queries 3
Sort_merge_passes 5013
Sort_range 209355
Sort_rows 130354406
Sort_scan 119171
Table_locks_immediate 3660999
Table_locks_waited 1301
Threads_cached 0
Threads_connected 2
Threads_created 3368731
Threads_running 1
Uptime 2563186
+--------------------------+------------+
top
top - 21:56:44 up 29 days, 15:27, 2 users, load average: 0.51, 0.52, 0.48
Tasks: 105 total, 1 running, 104 sleeping, 0 stopped, 0 zombie
Cpu(s): 6.5% us, 1.0% sy, 0.0% ni, 90.3% id, 2.0% wa, 0.0% hi, 0.2% si
Mem: 2074996k total, 2005732k used, 69264k free, 109620k buffers
Swap: 2040244k total, 144k used, 2040100k free, 1475860k cached
 Where's The Advantage In Windows Genuine Advantage?
 Stocks Bounce After S&P Joins Bear Market
|
PRINT
Add to favorites