T_W
Wed 23rd Aug '06, 2:57pm
I guess I could use some help optimizing my server. We went from a load of around 1.0 to more like 13. At any rate here is what I have.
Dedicated Server running one Forum only
Mac OS 10.4.3
Dual G5's at 2.5ghz
2GB of DDR ram
69gb Serial-ata non raid HD
PHP 4.3.11
MySql 4.0.25
My.cnf stuff:
[mysqld]
skip-innodb
max_connections = 500
key_buffer = 32M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 45
connect_timeout = 10
tmp_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
query_cache_limit = 3M
query_cache_size = 80M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 32768
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
#[isamchk]
#key_buffer = 128M
#sort_buffer_size = 128M
#read_buffer = 2M
#write_buffer = 2M
[myisamchk]
key_buffer = 64M
sort_buffer_size = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
Top Stats:
Processes: 125 total, 13 running, 112 sleeping... 377 threads 09:08:20
Load Avg: 13.65, 7.46, 5.14 CPU usage: 82.5% user, 17.5% sys, 0.0% idle
SharedLibs: num = 148, resident = 27.6M code, 2.68M data, 5.14M LinkEdit
MemRegions: num = 14161, resident = 530M + 12.5M private, 47.5M shared
PhysMem: 176M wired, 253M active, 1.05G inactive, 1.47G used, 538M free
VM: 6.29G + 98.7M 56877(0) pageins, 315(0) pageouts
PID COMMAND %CPU TIME #TH #PRTS #MREGS RPRVT RSHRD RSIZE VSIZE
26608 httpd 0.0% 0:00.00 1 12 89 228K 3.93M 956K- 31.3M
26606 httpd 0.0% 0:00.00 1 12 89 220K 3.93M 940K 31.3M
26605 httpd 0.0% 0:00.24 1 12 91 2.79M 3.90M 4.41M 33.4M
26604 httpd 0.0% 0:00.15 1 12 90 2.98M 3.90M 4.52M 32.3M
26602 httpd 0.0% 0:00.37 1 12 91 2.93M 3.90M 4.58M- 33.4M
26601 httpd 0.0% 0:00.00 1 12 89 228K 3.93M 956K 31.3M
26600 httpd 0.0% 0:00.48 1 12 91 3.34M 3.90M 4.93M- 33.4M
26599 httpd 0.0% 0:00.32 1 12 91 3.32M 3.90M 4.91M 33.4M
26598 httpd 0.0% 0:00.13 1 12 90 1.66M 3.90M 3.15M 32.3M
26597 httpd 0.0% 0:00.11 1 12 90 2.32M+ 3.90M 3.91M+ 32.3M
26596 pickup 0.0% 0:00.01 1 16 19 180K 364K 756K 26.7M
26595 master 0.0% 0:00.03 1 15 18 176K 336K 736K 26.7M
26594 httpd 0.0% 0:00.08 1 12 90 1.67M 3.90M 3.18M- 32.3M
26593 httpd 0.0% 0:00.20 1 12 91 3.30M 3.90M 4.91M 33.4M
26592 httpd 0.0% 0:00.01 1 12 89 224K 3.93M 992K 31.3M
26591 httpd 0.0% 0:00.67 1 12 91 3.28M 3.90M 4.89M 33.4M
26590 httpd 0.0% 0:00.23 1 12 91 2.77M 3.90M 4.37M- 33.4M
26588 httpd 0.0% 0:01.44 1 12 91 3.39M 3.90M 5.03M 33.4M
26587 httpd 0.0% 0:00.25 1 12 91 2.80M 3.90M 4.44M- 33.4M
26586 httpd 3.8% 0:00.64 1 12 91 3.25M 3.90M 5.04M+ 33.4M
26585 httpd 0.0% 0:00.75 1 12 91 2.86M 3.90M 4.51M 33.4M
26584 httpd 0.0% 0:00.92 1 12 91 3.37M 3.90M 4.96M 33.4M
26582 httpd 0.0% 0:00.00 1 12 89 224K 3.93M 988K+ 31.3M
26581 httpd 0.0% 0:00.53 1 12 91 3.27M 3.90M 4.89M 33.4M
26580 httpd 0.0% 0:00.00 1 12 89 224K 3.93M 992K+ 31.3M
26579 httpd 0.0% 0:00.33 1 12 91 3.24M 3.90M 4.86M- 33.4M
26578 httpd 0.0% 0:00.66 1 12 91 3.27M 3.90M 4.88M- 33.4M
26577 httpd 0.0% 0:00.91 1 12 91 3.27M 3.90M 4.90M 33.4M
26576 httpd 0.0% 0:00.82 1 12 91 3.27M 3.90M 4.89M- 33.4M
26575 httpd 3.9% 0:00.13 1 12 90 1.66M+ 3.90M 3.45M+ 32.3M
26571 httpd 14.9% 0:18.09 1 12 144 3.44M 3.90M 4.89M 35.8M
26570 httpd 0.0% 0:02.24 1 12 92 4.99M 3.90M 6.69M 34.4M
26568 httpd 16.8% 0:16.05 1 12 145 4.87M 3.90M 6.47M 36.8M
26566 httpd 0.0% 0:02.18 1 12 91 4.19M 3.90M 5.93M+ 33.4M
26556 httpd 16.4% 0:23.02 1 12 144 4.27M 3.90M 5.82M 35.8M
26479 httpd 0.0% 1:06.23 1 12 90 2.61M 3.90M 4.25M 32.3M
26474 httpd 0.0% 0:04.18 1 12 96 8.27M 3.90M 9.95M- 38.5M
26468 httpd 4.2% 0:06.12 1 12 91 3.42M 3.90M 5.15M+ 33.4M
26451 httpd 4.1% 0:04.56 1 12 91 3.49M 3.90M 5.36M+ 33.4M
26450 httpd 0.0% 0:05.72 1 12 91 3.41M 3.90M 4.98M- 33.4M
26449 httpd 0.0% 0:03.35 1 12 91 3.45M 3.90M 5.11M+ 33.4M
26447 httpd 15.4% 0:45.25 1 12 145 5.47M 3.90M 6.91M 36.8M
26446 httpd 0.0% 0:04.49 1 12 91 3.43M 3.90M 5.11M 33.4M
MySql Stats
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| back_log | 50 |
| basedir | /usr/local/mysql-standard-4.0.25-apple-darwin7.9.0-powerpc/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set | latin1 |
| character_sets | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON |
| connect_timeout | 10 |
| convert_character_set | |
| datadir | /usr/local/mysql/data/ |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_min_word_len | 4 |
| ft_max_word_len | 254 |
| ft_max_word_len_for_sort | 20 |
| ft_stopword_file | (built-in) |
| have_bdb | NO |
| have_crypt | YES |
| have_innodb | DISABLED |
| have_isam | YES |
| have_raid | NO |
| have_symlink | YES |
| have_openssl | NO |
| have_query_cache | YES |
| init_file | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_size | 8388608 |
| 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 | 1 |
| innodb_fast_shutdown | ON |
| innodb_flush_method | |
| innodb_lock_wait_timeout | 50 |
| 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_mirrored_log_groups | 1 |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_table_locks | ON |
| interactive_timeout | 28800 |
| join_buffer_size | 1044480 |
| key_buffer_size | 16777216 |
| language | /usr/local/mysql-standard-4.0.25-apple-darwin7.9.0-powerpc/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_update | OFF |
| log_bin | ON |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | ON |
| lower_case_table_names | 2 |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connections | 500 |
| max_connect_errors | 10 |
| max_delayed_threads | 20 |
| max_insert_delayed_threads | 20 |
| max_heap_table_size | 16777216 |
| max_join_size | 4294967295 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_user_connections | 0 |
| max_tmp_tables | 32 |
| max_write_lock_count | 4294967295 |
| myisam_max_extra_sort_file_size | 268435456 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_repair_threads | 1 |
| myisam_recover_options | OFF |
| myisam_sort_buffer_size | 67108864 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| open_files_limit | 3510 |
| pid_file | /usr/local/mysql/data/tt-test.tennis-warehouse.com.pid |
| log_error | |
| port | 3306 |
| protocol_version | 10 |
| query_alloc_block_size | 16384 |
| query_cache_limit | 1048576 |
| query_cache_size | 33554432 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 16384 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| rpl_recovery_rank | 0 |
| server_id | 1 |
| slave_net_timeout | 3600 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /tmp/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | 0 |
| table_cache | 1500 |
| table_type | MYISAM |
| thread_cache_size | 256 |
| thread_stack | 196608 |
| tx_isolation | REPEATABLE-READ |
| timezone | PDT |
| tmp_table_size | 33554432 |
| tmpdir | /var/tmp/ |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| version | 4.0.25-standard-log |
| version_comment | Official MySQL-standard binary |
| version_compile_os | apple-darwin7.9.0 |
| wait_timeout | 900 |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+--------------------------+-----------+
| Variable_name | Value |
+--------------------------+-----------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Bytes_received | 18389989 |
| Bytes_sent | 930582056 |
| Com_admin_commands | 0 |
| Com_alter_table | 6 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 5569 |
| 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 | 127 |
| 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 | 2446 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 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 | 720 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 20215 |
| Com_set_option | 0 |
| Com_show_binlog_events | 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_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 | 1 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 1 |
| Com_show_variables | 5 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 4473 |
| Com_update_multi | 0 |
| Connections | 5571 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_tables | 1459 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 225 |
| Handler_read_first | 8296 |
| Handler_read_key | 806355 |
| Handler_read_next | 1363074 |
| Handler_read_prev | 32935 |
| Handler_read_rnd | 385176 |
| Handler_read_rnd_next | 2706337 |
| Handler_rollback | 0 |
| Handler_update | 44544 |
| Handler_write | 124107 |
| Key_blocks_used | 9137 |
| Key_read_requests | 2477844 |
| Key_reads | 9098 |
| Key_write_requests | 3422 |
| Key_writes | 2790 |
| Max_used_connections | 16 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 190 |
| Open_files | 309 |
| Open_streams | 0 |
| Opened_tables | 196 |
| Questions | 58846 |
| Qcache_queries_in_cache | 1722 |
| Qcache_inserts | 19209 |
| Qcache_hits | 19715 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 914 |
| Qcache_free_memory | 26456912 |
| Qcache_free_blocks | 645 |
| Qcache_total_blocks | 4236 |
| Rpl_status | NULL |
| Select_full_join | 3 |
| Select_full_range_join | 0 |
| Select_range | 5797 |
| Select_range_check | 0 |
| Select_scan | 3041 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 4952 |
| Sort_rows | 391014 |
| Sort_scan | 639 |
| Table_locks_immediate | 55988 |
| Table_locks_waited | 180 |
| Threads_cached | 14 |
| Threads_created | 17 |
| Threads_connected | 3 |
| Threads_running | 2 |
| Uptime | 1633 |
+--------------------------+-----------+
Uptime: 1633 Threads: 3 Questions: 58848 Slow queries: 0 Opens: 196 Flush tables: 1 Open tables: 190 Queries per second avg: 36.037
/usr/local/mysql/bin/mysqladmin Ver 8.40 Distrib 4.0.25, for apple-darwin7.9.0 on powerpc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.0.25-standard-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 27 min 13 sec
Threads: 3 Questions: 58849 Slow queries: 0 Opens: 196 Flush tables: 1 Open tables: 190 Queries per second avg: 36.037
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 5
MinSpareServers 5
MaxSpareServers 5
StartServers 1
MaxClients 150
AND Maxrequestsperchild value = 500
VB version 3.6.0
Darwin tt-test.tennis-warehouse.com 8.3.0 Darwin Kernel Version 8.3.0: Mon Oct 3 20:04:04 PDT 2005; root:xnu-792.6.22.obj~2/RELEASE_PPC Power Macintosh powerpc
tt-test:/ root# ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) unlimited
pipe size (512 bytes, -p) 1
stack size (kbytes, -s) 65536
cpu time (seconds, -t) unlimited
max user processes (-u) 532
virtual memory (kbytes, -v) unlimited
any help would be awsome. Like I said before My server load was around 1.0 to maybe 1.5 with an average of 700 users on a time with a max of about 1300 people at certain times of the year.
Dedicated Server running one Forum only
Mac OS 10.4.3
Dual G5's at 2.5ghz
2GB of DDR ram
69gb Serial-ata non raid HD
PHP 4.3.11
MySql 4.0.25
My.cnf stuff:
[mysqld]
skip-innodb
max_connections = 500
key_buffer = 32M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 1800
thread_cache_size = 384
wait_timeout = 45
connect_timeout = 10
tmp_table_size = 64M
max_allowed_packet = 64M
max_connect_errors = 10
query_cache_limit = 3M
query_cache_size = 80M
query_cache_type = 1
query_prealloc_size = 16384
query_alloc_block_size = 32768
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
#[isamchk]
#key_buffer = 128M
#sort_buffer_size = 128M
#read_buffer = 2M
#write_buffer = 2M
[myisamchk]
key_buffer = 64M
sort_buffer_size = 64M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
Top Stats:
Processes: 125 total, 13 running, 112 sleeping... 377 threads 09:08:20
Load Avg: 13.65, 7.46, 5.14 CPU usage: 82.5% user, 17.5% sys, 0.0% idle
SharedLibs: num = 148, resident = 27.6M code, 2.68M data, 5.14M LinkEdit
MemRegions: num = 14161, resident = 530M + 12.5M private, 47.5M shared
PhysMem: 176M wired, 253M active, 1.05G inactive, 1.47G used, 538M free
VM: 6.29G + 98.7M 56877(0) pageins, 315(0) pageouts
PID COMMAND %CPU TIME #TH #PRTS #MREGS RPRVT RSHRD RSIZE VSIZE
26608 httpd 0.0% 0:00.00 1 12 89 228K 3.93M 956K- 31.3M
26606 httpd 0.0% 0:00.00 1 12 89 220K 3.93M 940K 31.3M
26605 httpd 0.0% 0:00.24 1 12 91 2.79M 3.90M 4.41M 33.4M
26604 httpd 0.0% 0:00.15 1 12 90 2.98M 3.90M 4.52M 32.3M
26602 httpd 0.0% 0:00.37 1 12 91 2.93M 3.90M 4.58M- 33.4M
26601 httpd 0.0% 0:00.00 1 12 89 228K 3.93M 956K 31.3M
26600 httpd 0.0% 0:00.48 1 12 91 3.34M 3.90M 4.93M- 33.4M
26599 httpd 0.0% 0:00.32 1 12 91 3.32M 3.90M 4.91M 33.4M
26598 httpd 0.0% 0:00.13 1 12 90 1.66M 3.90M 3.15M 32.3M
26597 httpd 0.0% 0:00.11 1 12 90 2.32M+ 3.90M 3.91M+ 32.3M
26596 pickup 0.0% 0:00.01 1 16 19 180K 364K 756K 26.7M
26595 master 0.0% 0:00.03 1 15 18 176K 336K 736K 26.7M
26594 httpd 0.0% 0:00.08 1 12 90 1.67M 3.90M 3.18M- 32.3M
26593 httpd 0.0% 0:00.20 1 12 91 3.30M 3.90M 4.91M 33.4M
26592 httpd 0.0% 0:00.01 1 12 89 224K 3.93M 992K 31.3M
26591 httpd 0.0% 0:00.67 1 12 91 3.28M 3.90M 4.89M 33.4M
26590 httpd 0.0% 0:00.23 1 12 91 2.77M 3.90M 4.37M- 33.4M
26588 httpd 0.0% 0:01.44 1 12 91 3.39M 3.90M 5.03M 33.4M
26587 httpd 0.0% 0:00.25 1 12 91 2.80M 3.90M 4.44M- 33.4M
26586 httpd 3.8% 0:00.64 1 12 91 3.25M 3.90M 5.04M+ 33.4M
26585 httpd 0.0% 0:00.75 1 12 91 2.86M 3.90M 4.51M 33.4M
26584 httpd 0.0% 0:00.92 1 12 91 3.37M 3.90M 4.96M 33.4M
26582 httpd 0.0% 0:00.00 1 12 89 224K 3.93M 988K+ 31.3M
26581 httpd 0.0% 0:00.53 1 12 91 3.27M 3.90M 4.89M 33.4M
26580 httpd 0.0% 0:00.00 1 12 89 224K 3.93M 992K+ 31.3M
26579 httpd 0.0% 0:00.33 1 12 91 3.24M 3.90M 4.86M- 33.4M
26578 httpd 0.0% 0:00.66 1 12 91 3.27M 3.90M 4.88M- 33.4M
26577 httpd 0.0% 0:00.91 1 12 91 3.27M 3.90M 4.90M 33.4M
26576 httpd 0.0% 0:00.82 1 12 91 3.27M 3.90M 4.89M- 33.4M
26575 httpd 3.9% 0:00.13 1 12 90 1.66M+ 3.90M 3.45M+ 32.3M
26571 httpd 14.9% 0:18.09 1 12 144 3.44M 3.90M 4.89M 35.8M
26570 httpd 0.0% 0:02.24 1 12 92 4.99M 3.90M 6.69M 34.4M
26568 httpd 16.8% 0:16.05 1 12 145 4.87M 3.90M 6.47M 36.8M
26566 httpd 0.0% 0:02.18 1 12 91 4.19M 3.90M 5.93M+ 33.4M
26556 httpd 16.4% 0:23.02 1 12 144 4.27M 3.90M 5.82M 35.8M
26479 httpd 0.0% 1:06.23 1 12 90 2.61M 3.90M 4.25M 32.3M
26474 httpd 0.0% 0:04.18 1 12 96 8.27M 3.90M 9.95M- 38.5M
26468 httpd 4.2% 0:06.12 1 12 91 3.42M 3.90M 5.15M+ 33.4M
26451 httpd 4.1% 0:04.56 1 12 91 3.49M 3.90M 5.36M+ 33.4M
26450 httpd 0.0% 0:05.72 1 12 91 3.41M 3.90M 4.98M- 33.4M
26449 httpd 0.0% 0:03.35 1 12 91 3.45M 3.90M 5.11M+ 33.4M
26447 httpd 15.4% 0:45.25 1 12 145 5.47M 3.90M 6.91M 36.8M
26446 httpd 0.0% 0:04.49 1 12 91 3.43M 3.90M 5.11M 33.4M
MySql Stats
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Variable_name | Value |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| back_log | 50 |
| basedir | /usr/local/mysql-standard-4.0.25-apple-darwin7.9.0-powerpc/ |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set | latin1 |
| character_sets | latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 |
| concurrent_insert | ON |
| connect_timeout | 10 |
| convert_character_set | |
| datadir | /usr/local/mysql/data/ |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_min_word_len | 4 |
| ft_max_word_len | 254 |
| ft_max_word_len_for_sort | 20 |
| ft_stopword_file | (built-in) |
| have_bdb | NO |
| have_crypt | YES |
| have_innodb | DISABLED |
| have_isam | YES |
| have_raid | NO |
| have_symlink | YES |
| have_openssl | NO |
| have_query_cache | YES |
| init_file | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_size | 8388608 |
| 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 | 1 |
| innodb_fast_shutdown | ON |
| innodb_flush_method | |
| innodb_lock_wait_timeout | 50 |
| 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_mirrored_log_groups | 1 |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_table_locks | ON |
| interactive_timeout | 28800 |
| join_buffer_size | 1044480 |
| key_buffer_size | 16777216 |
| language | /usr/local/mysql-standard-4.0.25-apple-darwin7.9.0-powerpc/share/mysql/english/ |
| large_files_support | ON |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_update | OFF |
| log_bin | ON |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | ON |
| lower_case_table_names | 2 |
| max_allowed_packet | 16776192 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connections | 500 |
| max_connect_errors | 10 |
| max_delayed_threads | 20 |
| max_insert_delayed_threads | 20 |
| max_heap_table_size | 16777216 |
| max_join_size | 4294967295 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 4294967295 |
| max_sort_length | 1024 |
| max_user_connections | 0 |
| max_tmp_tables | 32 |
| max_write_lock_count | 4294967295 |
| myisam_max_extra_sort_file_size | 268435456 |
| myisam_max_sort_file_size | 2147483647 |
| myisam_repair_threads | 1 |
| myisam_recover_options | OFF |
| myisam_sort_buffer_size | 67108864 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| open_files_limit | 3510 |
| pid_file | /usr/local/mysql/data/tt-test.tennis-warehouse.com.pid |
| log_error | |
| port | 3306 |
| protocol_version | 10 |
| query_alloc_block_size | 16384 |
| query_cache_limit | 1048576 |
| query_cache_size | 33554432 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 16384 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 1044480 |
| read_only | OFF |
| read_rnd_buffer_size | 262144 |
| rpl_recovery_rank | 0 |
| server_id | 1 |
| slave_net_timeout | 3600 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /tmp/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | 0 |
| table_cache | 1500 |
| table_type | MYISAM |
| thread_cache_size | 256 |
| thread_stack | 196608 |
| tx_isolation | REPEATABLE-READ |
| timezone | PDT |
| tmp_table_size | 33554432 |
| tmpdir | /var/tmp/ |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| version | 4.0.25-standard-log |
| version_comment | Official MySQL-standard binary |
| version_compile_os | apple-darwin7.9.0 |
| wait_timeout | 900 |
+---------------------------------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
+--------------------------+-----------+
| Variable_name | Value |
+--------------------------+-----------+
| Aborted_clients | 0 |
| Aborted_connects | 0 |
| Bytes_received | 18389989 |
| Bytes_sent | 930582056 |
| Com_admin_commands | 0 |
| Com_alter_table | 6 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 5569 |
| 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 | 127 |
| 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 | 2446 |
| Com_insert_select | 0 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 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 | 720 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 20215 |
| Com_set_option | 0 |
| Com_show_binlog_events | 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_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 | 1 |
| Com_show_innodb_status | 0 |
| Com_show_tables | 1 |
| Com_show_variables | 5 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 0 |
| Com_unlock_tables | 0 |
| Com_update | 4473 |
| Com_update_multi | 0 |
| Connections | 5571 |
| Created_tmp_disk_tables | 0 |
| Created_tmp_tables | 1459 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 225 |
| Handler_read_first | 8296 |
| Handler_read_key | 806355 |
| Handler_read_next | 1363074 |
| Handler_read_prev | 32935 |
| Handler_read_rnd | 385176 |
| Handler_read_rnd_next | 2706337 |
| Handler_rollback | 0 |
| Handler_update | 44544 |
| Handler_write | 124107 |
| Key_blocks_used | 9137 |
| Key_read_requests | 2477844 |
| Key_reads | 9098 |
| Key_write_requests | 3422 |
| Key_writes | 2790 |
| Max_used_connections | 16 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 190 |
| Open_files | 309 |
| Open_streams | 0 |
| Opened_tables | 196 |
| Questions | 58846 |
| Qcache_queries_in_cache | 1722 |
| Qcache_inserts | 19209 |
| Qcache_hits | 19715 |
| Qcache_lowmem_prunes | 0 |
| Qcache_not_cached | 914 |
| Qcache_free_memory | 26456912 |
| Qcache_free_blocks | 645 |
| Qcache_total_blocks | 4236 |
| Rpl_status | NULL |
| Select_full_join | 3 |
| Select_full_range_join | 0 |
| Select_range | 5797 |
| Select_range_check | 0 |
| Select_scan | 3041 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 4952 |
| Sort_rows | 391014 |
| Sort_scan | 639 |
| Table_locks_immediate | 55988 |
| Table_locks_waited | 180 |
| Threads_cached | 14 |
| Threads_created | 17 |
| Threads_connected | 3 |
| Threads_running | 2 |
| Uptime | 1633 |
+--------------------------+-----------+
Uptime: 1633 Threads: 3 Questions: 58848 Slow queries: 0 Opens: 196 Flush tables: 1 Open tables: 190 Queries per second avg: 36.037
/usr/local/mysql/bin/mysqladmin Ver 8.40 Distrib 4.0.25, for apple-darwin7.9.0 on powerpc
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.0.25-standard-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 27 min 13 sec
Threads: 3 Questions: 58849 Slow queries: 0 Opens: 196 Flush tables: 1 Open tables: 190 Queries per second avg: 36.037
KeepAlive On
MaxKeepAliveRequests 100
KeepAliveTimeout 5
MinSpareServers 5
MaxSpareServers 5
StartServers 1
MaxClients 150
AND Maxrequestsperchild value = 500
VB version 3.6.0
Darwin tt-test.tennis-warehouse.com 8.3.0 Darwin Kernel Version 8.3.0: Mon Oct 3 20:04:04 PDT 2005; root:xnu-792.6.22.obj~2/RELEASE_PPC Power Macintosh powerpc
tt-test:/ root# ulimit -aH
core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
max locked memory (kbytes, -l) unlimited
max memory size (kbytes, -m) unlimited
open files (-n) unlimited
pipe size (512 bytes, -p) 1
stack size (kbytes, -s) 65536
cpu time (seconds, -t) unlimited
max user processes (-u) 532
virtual memory (kbytes, -v) unlimited
any help would be awsome. Like I said before My server load was around 1.0 to maybe 1.5 with an average of 700 users on a time with a max of about 1300 people at certain times of the year.