Servers and Hosting Server Issues - Shared, Virtual, and Dedicated Hosting Options.

Reply
 
Thread Tools

  #1  
Old 05-11-2005, 09:55 PM
maynard maynard is offline
TAZ Rookie
 
Join Date: May 2005
Posts: 5
maynard is on a distinguished road
Default 1000+ members and guests online at once
Hello,

I've a quit popular website, the website is fully php-mysql driven site, originally its postnuke based but with lotsa of customizations
it has also forum- phpbb2.
Also, it has Downloads section, has like 400 mega of different downloads items (all are legal and everything)
Some of the site section is restricted to members, my members number (right now) is 15,300 (Avg. 100 new member everyday)

Here's my Server specs:

AMD 2800+
1 G ram
CentOS 4.0
Cpanel/WHM
Apache 1.3.33
PHP 4.3.11 w/Zend optimizer
MySQL 4.0.24

my cnf file only has this :

[mysqld]
set-variable = max_connections=500
safe-show-database

here's what mysqladmin status says (avg. 800 user online):
Uptime: 65558
Threads: 3
Questions: 11295884
Slow queries: 20
Opens: 24181
Flush tables: 1
Open tables: 64
Queries per second avg: 172.304

and (avg. 1100 users online) :

Uptime: 103977
Threads: 7
Questions: 21667953
Slow queries: 37
Opens: 32031
Flush tables: 1
Open tables: 64
Queries per second avg: 208.392

and Here's what my Free command says:

total used free shared buffers cached
Mem: 1019664 802036 217628 0 27564 277052
-/+ buffers/cache: 497420 522244
Swap: 2031608 291776 1739832

and here's an example of my TOP:

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
11309 nobody 15 0 22824 13m 2916 S 18.2 1.4 0:01.41 httpd
4838 nobody 15 0 24272 14m 2916 S 13.5 1.5 1:05.82 httpd
11340 mysql 15 0 42144 11m 1368 S 6.0 1.1 0:00.23 mysqld
11338 mysql 15 0 42144 11m 1368 S 5.7 1.1 0:00.22 mysqld
10299 nobody 16 0 24748 15m 2932 S 3.4 1.6 12:33.70 httpd
26556 nobody 16 0 27524 18m 2924 S 0.5 1.8 49:51.80 httpd
10875 nobody 15 0 23396 14m 2916 S 0.5 1.4 0:05.42 httpd
26567 nobody 15 0 46480 20m 2932 S 0.3 2.1 48:15.77 httpd
21493 nobody 16 0 24828 15m 2928 S 0.3 1.6 2:36.53 httpd
6165 nobody 16 0 24236 14m 2916 S 0.3 1.5 0:44.29 httpd
10727 root 16 0 8968 2240 1808 S 0.3 0.2 0:00.06 sshd
11083 nobody 15 0 23784 14m 2932 S 0.3 1.5 0:03.44 httpd

My load average is usually are like : 2.13, 3.16, 3.36
its never less 1.8 anyway and might up to 8 or 9 sometimes

as Im a bit newbie in the servers thing, I was wondering about recommendations for optmizie this server (like my.cnf ..etc)
and to let you know the speed of the website isnt bad at all, its quit good but not the fastest and its only that site on that server.

any input would be greatly appreciated
Reply With Quote
  #2  
Old 05-12-2005, 02:54 AM
PerfectSQL PerfectSQL is offline
Server Admin
 
Join Date: Jan 2005
Age: 41
Posts: 182
PerfectSQL will become famous soon enough
Default
Hello,
First off, you'd probably do well by installing eaccellorater to speed up your PHP .. there is a good thread located HERE explaing how to install it. You should remove your zend optimizer or at least disable optimization if you need it for Zend encoded files.

Your my.cnf is very sparse, so i'd recomend you take a look at
THIS THREAD, you will find alot of usefull information about tuning your mysql settings.

Let us know after reviewing those threadsw if you need more specific help
__________________
Server management and optimization at fair prices.
Free Web Hosting for your forums! Free PHP Hosting @ 0000free.com
Reply With Quote
  #3  
Old 05-12-2005, 09:08 AM
MaXBoost's Avatar
MaXBoost MaXBoost is offline
Tazmanian
 
Join Date: Apr 2004
Admin Experience: Advanced
Location: San Jose, ca
Age: 35
Posts: 135
MaXBoost is on a distinguished road
Default
Quote:
Originally Posted by PerfectSQL
Hello,
First off, you'd probably do well by installing eaccellorater to speed up your PHP .. there is a good thread located HERE explaing how to install it. You should remove your zend optimizer or at least disable optimization if you need it for Zend encoded files.

Your my.cnf is very sparse, so i'd recomend you take a look at
THIS THREAD, you will find alot of usefull information about tuning your mysql settings.

Let us know after reviewing those threadsw if you need more specific help

agreed to everthing you said, but i'll keep using both zend and eaccellorater. it does no harm to the sever or php plus you get an extra 15% faster page loads
Reply With Quote
  #4  
Old 05-12-2005, 09:36 AM
maynard maynard is offline
TAZ Rookie
 
Join Date: May 2005
Posts: 5
maynard is on a distinguished road
Default
Thanks for responding.

I read those 2 threads and found them very usefull, but I only have 2 things make me worry:

1- as MaXBoost said, I need Zend and Im not sure if both eaccellorater and Zend will go along with each other ?

2- as I'm having a dynamic website, the site info is changing like every 5 min. people post news item, comments beside the forums ..etc
I wonder if I used php cashe tool such as eaccelerator, would that effect the dynamic contents for such very active site ?
and the things goes as well for MySQL query cach
Reply With Quote
  #5  
Old 05-12-2005, 12:38 PM
PerfectSQL PerfectSQL is offline
Server Admin
 
Join Date: Jan 2005
Age: 41
Posts: 182
PerfectSQL will become famous soon enough
Default
Quote:
Originally Posted by maynard
Thanks for responding.

I read those 2 threads and found them very usefull, but I only have 2 things make me worry:

1- as MaXBoost said, I need Zend and Im not sure if both eaccellorater and Zend will go along with each other ?

2- as I'm having a dynamic website, the site info is changing like every 5 min. people post news item, comments beside the forums ..etc
I wonder if I used php cashe tool such as eaccelerator, would that effect the dynamic contents for such very active site ?
and the things goes as well for MySQL query cach
You can use them both together.. just set this under your php.ini

[Zend]
zend_optimizer.optimization_level=0

that will turn off the optimization, so you can use it to just run zend encoded scripts.

As for question 2, the content changes, but the scripts do not. eaccelorater stores the scripts in a compiled state and reuses them. It works great with forums and portals etc.
__________________
Server management and optimization at fair prices.
Free Web Hosting for your forums! Free PHP Hosting @ 0000free.com
Reply With Quote
  #6  
Old 05-13-2005, 11:47 PM
maynard maynard is offline
TAZ Rookie
 
Join Date: May 2005
Posts: 5
maynard is on a distinguished road
Default
Thanks for respondingand the great help

I enhanced my cnf file and add the following


Code:
[mysqld]

skip-locking

set-variable = max_connections=500
set-variable = max_allowed_packet=5M
set-variable = connect_timeout=15
set-variable = key_buffer=64M
set-variable = join_buffer=1M
set-variable = record_buffer=1M
set-variable = sort_buffer=1M
set-variable = sort_buffer_size=786k
set-variable = read_buffer_size=512k
set-variable = read_rnd_buffer_size=768K
set-variable = table_cache=384
set-variable = thread_cache_size=50 
set-variable = thread_concurrency=2
set-variable = wait_timeout=15
set-variable = query_cache_limit=1M
set-variable = query_cache_size=32M
set-variable = query_cache_type=1
set-variable = myisam_sort_buffer_size=32M
skip-innodb
safe-show-database
and then I installed eaccelerator and there's some great speed improvments in all over the server
yet it didnt lower the laod that much, still get up 3 as load avg. in peak hours but still way better from the scary 8 and 9 I used to have
Reply With Quote
Reply

  Admin Zone Forums > The Community Zone > Managing an Online Community > Servers and Hosting





Currently Active Users Viewing this Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Community: Turn that Lurker into a Poster? Kathy Articles 40 04-17-2013 06:15 AM
Turning guests into members? powerstroke Increasing Traffic 17 05-02-2005 11:24 AM
Currently Active Users: 14905 (120 members and 14785 guests) Joe vBulletin 9 04-08-2005 05:59 PM
Policies, TOS, Notices (etc) Content Sharing Thread FlyBoy73 Members & Staff 15 01-06-2005 11:07 AM
getting guests to register & members to post. Maikeru Increasing Traffic 2 05-21-2004 01:35 AM


 

All times are GMT -4. The time now is 11:20 PM.


Powered by: vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Page generated in 0.08403707 seconds with 13 queries
The Admin Zone copyright 2003-2014 All Rights Reserved. Content published on The Admin Zone requires permission for reprint.