I am wondering if there is any tweaks or better setups of my.cnf or anything to help increase productivity of my server. I have a Dual Athlon MP 2000+ with 1gb ram ATA 100 60gb hd and here are some of my server stats/configs. FreeBSD 4.6 - Mysql is compiled with LinuxThreads. Also runs.. Apache, PHP, Qmail, and bind.
If someone can please help with some ideas. My main table has 120 columns with 30k rows. Approximatly 9mb and growing every minute. I have another table with 6 columns and 1.5 mil rows in it appx 35mb in size. maybe more ram ? current settings ? etc.. My.cnf ---------------------------------------------------------------------------- skip-locking set-variable = max_connections=500 set-variable = key_buffer=384M set-variable = max_allowed_packet=1M set-variable = table_cache=512 set-variable = sort_buffer=2M set-variable = record_buffer=2M set-variable = myisam_sort_buffer_size=64M set-variable = thread_cache=128 set-variable = thread_concurrency=4 skip-innodb ---------------------------------------------------------------------------- - mysql> SHOW STATUS; ---------------------------------------------------------------------------- - +--------------------------+------------+ | Variable_name | Value | +--------------------------+------------+ | Aborted_clients | 4 | | Aborted_connects | 0 | | Bytes_received | 1074463173 | | Bytes_sent | 2395721816 | | Com_admin_commands | 0 | | Com_alter_table | 0 | | Com_analyze | 0 | | Com_backup_table | 0 | | Com_begin | 0 | | Com_change_db | 994516 | | 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 | 600 | | Com_delete | 4275 | | Com_drop_db | 0 | | Com_drop_function | 0 | | Com_drop_index | 0 | | Com_drop_table | 600 | | Com_flush | 0 | | Com_grant | 0 | | Com_insert | 276497 | | Com_insert_select | 600 | | 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 | 3267069 | | 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 | 19 | | Com_show_slave_status | 0 | | Com_show_status | 37 | | Com_show_tables | 0 | | Com_show_variables | 0 | | Com_slave_start | 0 | | Com_slave_stop | 0 | | Com_truncate | 0 | | Com_unlock_tables | 0 | | Com_update | 14462895 | | Connections | 998865 | | Created_tmp_disk_tables | 0 | | Created_tmp_tables | 50 | | Created_tmp_files | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_delete | 279110 | | Handler_read_first | 353301 | | Handler_read_key | 17935201 | | Handler_read_next | 208539 | | Handler_read_prev | 0 | | Handler_read_rnd | 20608532 | | Handler_read_rnd_next | 258143249 | | Handler_update | 12927862 | | Handler_write | 2659794 | | Key_blocks_used | 44490 | | Key_read_requests | 62263607 | | Key_reads | 5500 | | Key_write_requests | 5988431 | | Key_writes | 620894 | | Max_used_connections | 93 | | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 206 | | Open_files | 230 | | Open_streams | 0 | | Opened_tables | 1418 | | Questions | 20006244 | | Select_full_join | 0 | | Select_full_range_join | 0 | | Select_range | 5385 | | Select_range_check | 0 | | Select_scan | 521842 | | Slave_running | OFF | | Slave_open_temp_tables | 0 | | Slow_launch_threads | 0 | | Slow_queries | 16 | | Sort_merge_passes | 0 | | Sort_range | 0 | | Sort_rows | 20608532 | | Sort_scan | 69121 | | Table_locks_immediate | 17622205 | | Table_locks_waited | 389689 | | Threads_cached | 64 | | Threads_created | 94 | | Threads_connected | 30 | | Threads_running | 29 | | Uptime | 180081 | +--------------------------+------------+ 111 rows in set (0.02 sec) --------------------------------------------------------------------------- mysql> STATUS; --------------------------------------------------------------------------- mysql Ver 11.18 Distrib 3.23.51, for portbld-freebsd4.6 (i386) Connection id: 998864 Current database: streetwars Current user: root@localhost Current pager: stdout Using outfile: '' Server version: 3.23.51 Protocol version: 10 Connection: Localhost via UNIX socket Client characterset: latin1 Server characterset: latin1 UNIX socket: /tmp/mysql.sock Uptime: 2 days 2 hours 3 min 7 sec Threads: 3 Questions: 20031396 Slow queries: 16 Opens: 1421 Flush tables: 1 Open tables: 207 Queries per second avg: 111.170 ---------------------------------------------------------------------------- -- --------------------------------------------------------------------- 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
