Hello...I have been looking for help for long time now.
My web forums(Invision power board v2.0.4) will at points be fast
then at times it will drop connections.
Machine:
Mac OS X 10.4
Dual G5
apache 1.3.3
php 4.3.10a
8GB RAM
Database is on an XRAID server
Forums:
Have over 10,000 Users
Website Hits status
(1978 today, 9346 this week, 7020 this month, 625949 this year)
Load Avg: 6.30, 4.64, 3.88 CPU usage: 11.7% user, 80.5% sys, 7.8% idle
SharedLibs: num = 139, resident = 18.8M code, 2.38M data, 11.4M LinkEdit
MemRegions: num = 57789, resident = 879M + 12.0M private, 76.7M shared
PhysMem: 413M wired, 1.19G active, 4.22G inactive, 5.81G used, 2.19G
free
Threads: 1 Questions: 6299762 Slow queries: 150 Opens: 146 Flush
tables: 1 Open tables: 140 Queries per second avg: 5.925
Some people have over 10 - 20 Queries per second avg.
my.cnf
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
key_buffer = 1024M
max_allowed_packet = 64M
table_cache = 768
sort_buffer_size = 16M
read_buffer_size = 16M
read_rnd_buffer_size = 32M
myisam_sort_buffer_size = 256M
join_buffer_size = 16M
thread_cache = 64
#long_query_time = 5
query_cache_type = 1
query_cache_size = 256M
wait_timeout = 3600
interactive_timeout = 300
tmp_table_size = 256M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 10
#This section has been added for Logging
#log-long-format
log-slow-queries=/var/log/mysqld.slow.log
log=/var/log/mysql.log
table type I'm using is MyISAM
| net_buffer_length |
16384 |
| net_read_timeout |
30 |
| net_retry_count |
10 |
| net_write_timeout | 60
| connect_timeout | 5
| slow_launch_time | 2
| transaction_alloc_block_size |
8192 |
| transaction_prealloc_size | 4096
| version | 4.1.10a-
log |
| version_comment | Source
distribution |
| version_compile_machine |
powerpc |
| version_compile_os | apple-darwin8.0
| open_files_limit | 1646
I know Mac has problems with threads...But I need to stop the site
from having a random shit switch :)
If anyone can help it would be great
