From: Benjamin Adams
Date: August 3 2005 11:02pm
Subject: Mac Tiger Optimization
List-Archive: http://lists.mysql.com/benchmarks/174
Message-Id: <34171E45-23D0-477F-ABEA-25948581D86D@ambrosiasw.com>
MIME-Version: 1.0 (Apple Message framework v733)
Content-Type: multipart/alternative; boundary=Apple-Mail-2-921519488

--Apple-Mail-2-921519488
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
	charset=US-ASCII;
	delsp=yes;
	format=flowed

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
--Apple-Mail-2-921519488--