Server optimization request(freebsd/Core 2 Duo E6600 2,60GHz/4G RAM)

محروم.كوم · #1 05-29-2009, 11:50 AM

<div>Hi,

I would like to ask for help, but as "preliminaries" I would like to say we are going into problems with about 1200 active users(cookie timeout 900) and we would like to live with 2000 - 2500 active users. Is it possible with our hardware or upgrade is necessary? Is there some minimal upgrade( only CPU, or more RAM?)

Our specs (top + stat etc. was generated in the "freeze time" with 1200 active users):

1. Dedicated server
2.
cpu: Intel Core 2 Duo 2.6GHz
RAM: 4GB RAM 800MHz, CL2.5
HDD: 4 x 230 GB SATA II physically ( 2 x 320GB in mirror, mysql db on separate discs )
OS: FreeBSD 6.3
apache: apache 2.0.63
php 5.2.5
mysql 5.0.51a

3. VB 3.8.2

4. no innodb
5. how mysql was compiled/installed BSD ports
6. your top stats. So

last pid: 89247; load averages: 0.00, 0.00, 0.00 up 10+10:08:01 19:29:02
510 processes: 1 running, 509 sleeping

Mem: 1184M Active, 1650M Inact, 234M Wired, 165M Cache, 112M Buf, 6836K Free
Swap: 8192M Total, 4976K Used, 8187M Free

PID USERNAME THR PRI NICE SIZE RES STATE C TIME WCPU COMMAND
53287 mysql 245 20 0 405M 285M kserel 0 152:51 0.00% mysqld
53292 root 1 96 0 18492K 9792K select 0 1:23 0.00% httpd
855 root 1 96 0 3508K 960K select 0 0:16 0.00% sendmail
88179 www 1 4 0 21344K 12972K sbwait 0 0:09 0.00% httpd
88313 www 1 4 0 24876K 16552K sbwait 1 0:08 0.00% httpd
429 root 1 96 0 1404K 580K select 0 0:07 0.00% syslogd
88284 www 1 4 0 24224K 15752K sbwait 0 0:06 0.00% httpd
500 root 1 96 0 3696K 700K select 0 0:05 0.00% proftpd
849 root 1 96 0 3552K 368K select 1 0:04 0.00% sshd
88318 www 1 4 0 26260K 17936K sbwait 0 0:03 0.00% httpd
88583 www 1 4 0 21336K 13000K sbwait 0 0:03 0.00% httpd
88540 www 1 4 0 21876K 13500K sbwait 0 0:03 0.00% httpd
88422 www 1 4 0 23296K 15004K sbwait 1 0:03 0.00% httpd
88533 www 1 4 0 21564K 13108K sbwait 0 0:03 0.00% httpd
88539 www 1 4 0 21124K 12852K sbwait 1 0:02 0.00% httpd
88634 www 1 4 0 25312K 16800K sbwait 1 0:02 0.00% httpd
88596 www 1 4 0 21356K 13024K sbwait 1 0:02 0.00% httpd
88573 www 1 4 0 23776K 15428K sbwait 0 0:02 0.00% httpd

after hitting 1

Quote:
I forgot to do this:-(

7.
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock

[mysqld]
bind-address = 127.0.0.1
port = 3306
socket = /tmp/mysql.sock
skip-locking
max_connections = 1200
key_buffer = 144M
key_buffer_size = 144M
max_allowed_packet = 64M
table_cache = 4000
sort_buffer_size = 4M
net_buffer_length = 16384
read_buffer_size = 256K
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
thread_cache_size = 384
max_heap_table_size = 64M
thread_concurrency = 4
concurrent_insert = 2
wait_timeout = 15
connect_timeout = 10
table_lock_wait_timeout = 30
tmp_table_size = 256M
max_connect_errors = 100
query_cache_limit = 6M
query_cache_size = 96M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
max_write_lock_count = 8

server-id = 1

[mysqld_safe]
nice = -10
err-log=/var/log/mysql/mysqld.log
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 64M
sort_buffer_size = 64M
read_buffer = 16M
write_buffer = 16M

[mysqlhotcopy]
interactive-timeout

8. MySQL stats from ssh telnet as root user type:

Quote:
mysqladmin -u root -p var ext stat ver proc
+---------------------------------+--------------------------------------+
| Variable_name | Value |
+---------------------------------+--------------------------------------+
| auto_increment_increment | 1 |
| auto_increment_offset | 1 |
| autocommit | ON |
| automatic_sp_privileges | ON |
| back_log | 50 |
| basedir | /usr/local/ |
| big_tables | OFF |
| binlog_cache_size | 32768 |
| binlog_format | MIXED |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | cp1250 |
| character_set_connection | cp1250 |
| character_set_database | cp1250 |
| character_set_filesystem | binary |
| character_set_results | cp1250 |
| character_set_server | cp1250 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/share/mysql/charsets/ |
| collation_connection | cp1250_general_ci |
| collation_database | cp1250_general_ci |
| collation_server | cp1250_general_ci |
| completion_type | 0 |
| concurrent_insert | 2 |

| connect_timeout | 10 |
| datadir | /var/db/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |

| delayed_queue_size | 1000 |
| div_precision_increment | 4 |
| engine_condition_pushdown | ON |
| error_count | 0 |
| event_scheduler | OFF |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| foreign_key_checks | ON |
| ft_boolean_syntax | + -> __DEFINE_LIKE_SHARE__

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	مشاركات	آخر مشاركة
Server Optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	07-12-2009 09:40 AM
Server optimization Request	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-30-2009 07:40 AM
Server Optimization Request. First time optimization	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	06-08-2009 04:40 AM
Optimization Request - Running FreeBSD 7.0-STABLE	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-19-2009 08:10 AM
Server Optimization Request - Please help! Server loads way too high!	محروم.كوم	منتدى أخبار المواقع والمنتديات العربية والأجنبية	0	05-05-2009 02:00 AM