List:Database Benchmarks« Previous MessageNext Message »
From:Benjamin Adams Date:August 3 2005 11:02pm
Subject:Mac Tiger Optimization
View as plain text  
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
Thread
Mac Tiger OptimizationBenjamin Adams4 Aug
  • Re: Mac Tiger OptimizationPeter Zaitsev4 Aug