SMF Version: SMF 1.1.5
My forums used to be fast but not sure what happened but one day my forum just decided to just slow down at times and even not load at all but this does not happen all the time it happens intermittently not sure what the problem is. I've contacted my host several times and they tell me when this happens that I am not exceeding my limits so that gives me no idea on what really is happening.
Alreayd installed APC tried both Level 1 and Level 2 still the same. Disabled database driven sessions. I tried switching between php safe_mode on and off but still the same. Does not happen all the time.
I have like 10-14k registered members but on the average of 15 min intervals around 90-150 users online.
Operating System: Linux 2.6.9-023stab044.11-entnosplit
Processor: Intel® Xeon® CPU E5310 @ 1.60GHz (400.213MHz)
384MB Guaranteed Ram Burstable to 1024MB
30GB of HDD Space
450GB of bandwidth
PHP Version 5.1.6
Apache 2.2.3
Status PHP File (http://pinoypsp.com/status.php)
PHPINFO File (http://pinoypsp.com/info.php)
SMF: 1.1.4
Mods: (the one's in bold are the only one's being used while the others are just loaded)
Mod Name Version
1. Prevent Adding Signature Images And Links 1.1 [ Apply Mod ] [ List Files ] [ Delete ]
2. Ad Managment 2.3 [ Uninstall ] [ List Files ] [ Delete ]
3. nneonneo's AJAX ShoutBox 1.11 [ Apply Mod ] [ List Files ] [ Delete ]
4. Global Announcements 1.0 [ Uninstall ] [ List Files ] [ Delete ]
5. YouTube BBC Tag (XHTML Compliant) 1.0 [ Uninstall ] [ List Files ] [ Delete ]
6. Anonym.to All External Links 1.2 [ Apply Mod ] [ List Files ] [ Delete ]
7. Karma Description Mod 2.3 [ Uninstall ] [ List Files ] [ Delete ]
8. Change Theme Permission 1.0 [ Apply Mod ] [ List Files ] [ Delete ]
9. SMF Trader System 1.1 [ Apply Mod ] [ List Files ] [ Delete ]
10. TinyPortal 0.983 [ Uninstall ] [ List Files ] [ Delete ]
Who's your host? I really don't want to play the blame game with your host.. but if it just random goes slow, then it is your hosts fault. If you are paying 3$ a month for 100gigs of bandwidth, then your host is just overselling and probably don't know what they are doing. They will always blame SMF for any "slow downs" because they don't know how to properly set up their servers.
It took over a minute for the status page to load, so something is up with the server.
Load is low, swap usage is low, things seem okay on that end. Only 8 processes showing, however.
Something is causing issues though. Is this shared hosting, a VPS, or dedicated?
my host is jaguarpc.com and no I don't pay cheap for it.. I pay $33.97/month to get that spec and hosting and its on VPS
and now its loading up fast and fine wtf
Quote from: slackerpunk on November 22, 2007, 11:56:11 PM
my host is jaguarpc.com and no I don't pay cheap for it.. I pay $33.97/month to get that spec and hosting and its on VPS
You do realize that is rather cheap for a VPS with those specs, right?
400gB of transfer is about 1.3mbit, which would cost about $100 a month from a colo place. You are paying less than half of that cost for the total package. For the price you are paying, the proper specs should be half of what is advertised.
I honestly think the host might be overloading the actual box the VPS is sitting on. It would explain the odd slow behavior while the VPS load and other specs look perfectly fine. The status page, which doesn't do anything special took over a minute to load - and with a load average of under 0.50 on all times.
yups I just got this off a promo around 4 months ago the usual price for this package is $40... i don't think smf is eating up alot of cpu or mems.. could be an issue with bandwidth?
how much should mysql processes be?
ok some updates... i have
1. converted table to innoDB using this thread http://www.simplemachines.org/community/index.php?topic=50217.0
will try and tweak mysql
Try selecting "Disable hostname lookups?" in SMF Admin > Features and Options > Layout and Options tab.
"Page created in 0.148 seconds with 14 queries." But I counted 10 seconds till the page loaded, and it kept loading after that ("Waiting for pinoypsp.com...") Other times, the page took longer time to get created, but it loaded quite fast.
Sometimes I can't even connect. It really feels like a host issue to me.
Quote from: Sarge on November 24, 2007, 08:38:59 AM
Try selecting "Disable hostname lookups?" in SMF Admin > Features and Options > Layout and Options tab.
"Page created in 0.148 seconds with 14 queries." But I counted 10 seconds till the page loaded, and it kept loading after that ("Waiting for pinoypsp.com...") Other times, the page took longer time to get created, but it loaded quite fast.
Sometimes I can't even connect. It really feels like a host issue to me.
Already disabled hostname lookups when I made this post and after some tweaks it seems fast but the problem is its happening from time to time.. sometimes the site is fast sometimes its slow.. By the way I've tried caching level 1 and 2 and still the same
Your status.php & phpinfo isn't even loading here until about 15 seconds after clicking, take it up with your host it's an issue at their end.
after much testing seems like its an issue with apache crashing because of ghost connections not sure whats really causing this because when the problem starts I just restart the httpd service and everything will work fine, fast and normal but after sometime it will happen again and it does it randomly not on any specific time or anything
any luck?
Is it possible whatever control panel software is running is doing its log calculation or log rotation around these times? these processes eat a LOT of clock and memory and can cause significant slowdowns...
I suspect an oversold box as well
try removing one of these
2. Ad Managment 2.3
or
10. TinyPortal 0.983
Page created in 0.093 seconds with 27 queries.
27 queries is really big...
and you got 7 ads in per page... thats really heavy....
Although it is in no way related to your problem.
While you are at it, I'd recommend changing the YouTube mod for
http://custom.simplemachines.org/mods/index.php?mod=936
This is because the old youtube mods had a low risk XSS vulnerability which could potentially be exploited (due to some bugs in YouTube, yes bugs in YT)
@karlbenson
thanks for the heads up..
been checking the problem for weeks now seems like an issue with apache because whenever the slow down happens I just restart httpd and everything will work fine. And whenever the problem occurs the server load goes down to a halt like nothing is happening or the server is not doing anything
Quote from: BlackMage on December 24, 2007, 12:31:18 AM
any luck?
Is it possible whatever control panel software is running is doing its log calculation or log rotation around these times? these processes eat a LOT of clock and memory and can cause significant slowdowns...
I suspect an oversold box as well
not much luck i am using plesk anyway to check on this? thanks
Is there anyway to embed google ads instead of using ads management
Quote from: metal13 on December 27, 2007, 05:23:58 PM
try removing one of these
2. Ad Managment 2.3
or
10. TinyPortal 0.983
Page created in 0.093 seconds with 27 queries.
27 queries is really big...
and you got 7 ads in per page... thats really heavy....
i've tried removing the ads before and its still the same.. like I said on my first post it was working fine and fast until it suddenly gave me intermittent problems never changed anything from the setup
Quote from: slackerpunk on January 06, 2008, 10:01:07 PM
Is there anyway to embed google ads instead of using ads management
Edit index.template.php for the theme and put the code in there.
Quote from: Motoko-chan on January 06, 2008, 10:45:09 PM
Quote from: slackerpunk on January 06, 2008, 10:01:07 PM
Is there anyway to embed google ads instead of using ads management
Edit index.template.php for the theme and put the code in there.
not really well versed with php i know there are tags you can use can you point me to the right direction? thanks
any luck?
theres a post in tips and tricks about how to manually integrate adsense with a forum :)
Quote from: BlackMage on January 12, 2008, 11:07:35 PM
any luck?
theres a post in tips and tricks about how to manually integrate adsense with a forum :)
I am going to try that
Quote from: BlackMage on December 24, 2007, 12:31:18 AM
any luck?
Is it possible whatever control panel software is running is doing its log calculation or log rotation around these times? these processes eat a LOT of clock and memory and can cause significant slowdowns...
I suspect an oversold box as well
@BM
I was going to ask you about this I was thinking about this also..any idea how I can check on this?
Re the slowdowns - a few days ago I had a heads up from my host that my site was using 98% of CPU and 100% of available memory, and even got the account suspended to make me do something about it.
Turns out it was because of using fake cron jobs with the Feedposter extension - soon as I disabled that, CPU & memory usage went back down to normal, and as an added bonus, page load dropped from average 45 queries taking 10-12 seconds down to a dozen queries taking under 1 second - the forum is lightening fast now.
Gaz
Doing the whole "fake cron job" thing is almost always a bad idea. Most hosts let you manage real cron jobs, and you should do things that way if at all possible. If you can't find the interface, ask your host.
Glad you sorted it out.
Quote from: jerm on November 22, 2007, 11:28:49 PM
Who's your host? I really don't want to play the blame game with your host.. but if it just random goes slow, then it is your hosts fault. If you are paying 3$ a month for 100gigs of bandwidth, then your host is just overselling and probably don't know what they are doing. They will always blame SMF for any "slow downs" because they don't know how to properly set up their servers.
I get the EXACT same thing, I'm a dedicated server and it's extremely fast however it does slow down with about 100+ users online at once.
GamingEvo, read over the stickies in this board, and make a new post if the tips don't improve your situation.
Quote from: GazOutEast on January 17, 2008, 10:00:14 AM
Re the slowdowns - a few days ago I had a heads up from my host that my site was using 98% of CPU and 100% of available memory, and even got the account suspended to make me do something about it.
Turns out it was because of using fake cron jobs with the Feedposter extension - soon as I disabled that, CPU & memory usage went back down to normal, and as an added bonus, page load dropped from average 45 queries taking 10-12 seconds down to a dozen queries taking under 1 second - the forum is lightening fast now.
Gaz
Sorry I never read this..... I don't have any fake cron jobs, or cron jobs at all and it does the same thing. I fixed the issue with a new server but I just though like throwing it out there. I have my own topic too :P
Disable hostname lookups from SMF Admin > Features and Options > Layout and Options tab. Hostname lookups caused thousands of zombie processes in my old server, as well as slowly degraded performance.
Quote from: GazOutEast on January 17, 2008, 10:00:14 AM
Re the slowdowns - a few days ago I had a heads up from my host that my site was using 98% of CPU and 100% of available memory, and even got the account suspended to make me do something about it.
Turns out it was because of using fake cron jobs with the Feedposter extension - soon as I disabled that, CPU & memory usage went back down to normal, and as an added bonus, page load dropped from average 45 queries taking 10-12 seconds down to a dozen queries taking under 1 second - the forum is lightening fast now.
Gaz
if you are talking about the feed poster mod yeah it kinda eats up mem and cpu i've tried using that before but caused some issues so I had to remove it but it would be cool to have a mod like that...
anyway my datacenter went down last week and after the site went back up it loads faster now + I removed the karma description mod and the site has been working fine and fast up to now that is about 6 days.. will continue to monitor
I am back.. well after about a month of good website functionality the problem came back haunting me...
Anyone who can recommend a my.cnf config file? its the only thing I haven't played with
Quote from: slackerpunk on February 03, 2008, 11:19:01 PM
Anyone who can recommend a my.cnf config file? its the only thing I haven't played with
Do you have root access to the server via the shell? AFAIK, my.cnf is only editable by root (or whichever user had installed MySQL). If you cannot access my.cnf directly, ask your host if they would do these changes for you:
http://www.simplemachines.org/community/index.php?topic=214356.msg1407717#msg1407717
Quote from: Sarge on February 04, 2008, 02:15:37 AM
Quote from: slackerpunk on February 03, 2008, 11:19:01 PM
Anyone who can recommend a my.cnf config file? its the only thing I haven't played with
Do you have root access to the server via the shell? AFAIK, my.cnf is only editable by root (or whichever user had installed MySQL). If you cannot access my.cnf directly, ask your host if they would do these changes for you:
http://www.simplemachines.org/community/index.php?topic=214356.msg1407717#msg1407717
I have root access on my vps.. thanks let me read that thread
Make sure to adapt the MySQL settings according to your VPS configuration, particularly RAM and CPU usage and maximum usage allowed.
yups that was why I was asking for suggestions by the way I posted a question on the thread you directed me to
Quote from: slackerpunk on February 04, 2008, 04:24:32 AM
yups that was why I was asking for suggestions by the way I posted a question on the thread you directed me to
I replied, but please don't hijack other people's topics -- it makes support slower, more confusing and less efficient...
So please let's keep tackling your own situation in this topic (started by you), shall we? ;)
Oh, and you should update Apache, MySQL and PHP to the latest versions (2.2.8, 5.0.51 and 5.2.5 respectively). The MySQL package version available for the operating system on your server might be a bit lower than 5.0.51, though.
@Sarge
Sorry about that.. anyway
PHP Version 5.1.6
Apache/2.2.3 (CentOS)
Mysql 5.0.22
I might start with that..
also here is a copy of the post I made on the other thread (apologize for that)
Quote
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
skip-bdb
set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
#log-error=/var/log/mysqld.log
#pid-file=/var/run/mysqld/mysqld.pid
#skip-bdb
set-variable = innodb_buffer_pool_size=2M
set-variable = innodb_additional_mem_pool_size=500K
set-variable = innodb_log_buffer_size=500K
set-variable = innodb_thread_concurrency=2
thread_cache_size = 256
table_cache = 1024
max_connections = 1000
max_user_connections = 1500
long_query_time = 5
query_cache_size = 64
max_heap_table_size - 32
tmp_table_size = 64
concurrent_insert = 2
Some Notes
Operating System: Linux 2.6.9-023stab044.11-entnosplit
Processor: Intel® Xeon® CPU E5310 @ 1.60GHz (400.081MHz)
Memory: 384MB Guaranteed 1024 Burst
Bandwidth: 450GB/month
Status Php File
-Usually around 100-150 users during peak hours
-I have APC installed Level 1 caching
-Mods
Ad management
Tinyportal
bookmarks
who voted what
youtube bbcode
signature settings mod
I will try and post mysqlreports probably tomorrow and tunning.sh
Quote from: slackerpunk on February 04, 2008, 11:41:12 PM
I will try and post mysqlreports probably tomorrow and tunning.sh
Be sure to let MySQL run for at least 48 hours. The more time it's been up, the more accurate the results from mysqlreport and tuning-primer will be. ;)
@sarge here are the results
Quote-- MYSQL PERFORMANCE TUNING PRIMER --
- By: Matthew Montgomery -
MySQL Version 5.0.22 i686
Uptime = 2 days 9 hrs 33 min 35 sec
Avg. qps = 33
Total Questions = 6877382
Threads Connected = 1
Server has been running for over 48hrs.
It should be safe to follow these recommendations
To find out more information on how each of these
runtime variables effects performance visit:
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
Visit http://www.mysql.com/products/enterprise/advisors.html
for info about MySQL's Enterprise Monitoring and Advisory Service
SLOW QUERIES
Current long_query_time = 10 sec.
You have 454 out of 6877394 that take longer than 10 sec. to complete
The slow query log is NOT enabled.
Your long_query_time may be too high, I typically set this under 5 sec.
WORKER THREADS
Current thread_cache_size = 0
Current threads_cached = 0
Current threads_per_sec = 2
Historic threads_per_sec = 1
Threads created per/sec are overrunning threads cached
You should raise thread_cache_size
MAX CONNECTIONS
Current max_connections = 100
Current threads_connected = 2
Historic max_used_connections = 11
The number of used connections is 11% of the configured maximum.
Your max_connections variable seems to be fine.
MEMORY USAGE
Max Memory Ever Allocated : 40 M
Configured Max Per-thread Buffers : 268 M
Configured Max Global Buffers : 10 M
Configured Max Memory Limit : 279 M
Physical Memory : 11.87 G
Max memory limit seem to be within acceptable norms
KEY BUFFER
Current MyISAM index space = 227 M
Current key_buffer_size = 7 M
Key cache miss rate is 1 : 102
Key buffer fill ratio = 99.00 %
You could increase key_buffer_size
It is safe to raise this up to 1/4 of total system memory;
assuming this is a dedicated database server.
QUERY CACHE
Query cache is supported but not enabled
Perhaps you should set the query_cache_size
SORT OPERATIONS
Current sort_buffer_size = 2 M
Current record/read_rnd_buffer_size = 256 K
Sort buffer seems to be fine
JOINS
Current join_buffer_size = 132.00 K
You have had 14615 queries where a join could not use an index properly
You have had 5 joins without keys that check for key usage after each row
You should enable "log-queries-not-using-indexes"
Then look for non indexed joins in the slow query log.
If you are unable to optimize your queries you may want to increase your
join_buffer_size to accommodate larger joins in one pass.
Note! This script will still suggest raising the join_buffer_size when
ANY joins not using indexes are found.
OPEN FILES LIMIT
Current open_files_limit = 1024 files
The open_files_limit should typically be set to at least 2x-3x
that of table_cache if you have heavy MyISAM usage.
Your open_files_limit value seems to be fine
TABLE CACHE
Current table_cache value = 64 tables
You have a total of 384 tables
You have 64 open tables.
Current table_cache hit rate is 0%, while 100% of your table cache is in use
You should probably increase your table_cache
TEMP TABLES
Current max_heap_table_size = 16 M
Current tmp_table_size = 32 M
Of 24226 temp tables, 35% were created on disk
Effective in-memory tmp_table_size is limited to max_heap_table_size.
Perhaps you should increase your tmp_table_size and/or max_heap_table_size
to reduce the number of disk-based temporary tables
Note! BLOB and TEXT columns are not allow in memory tables.
If you are using these columns raising these values might not impact your
ratio of on disk temp tables.
TABLE SCANS
Current read_buffer_size = 128 K
Current table scan ratio = 335 : 1
read_buffer_size seems to be fine
TABLE LOCKING
Current Lock Wait ratio = 1 : 5483
Your table locking seems to be fine
OK, put these in the [mysqld] section of my.cnf (just before the [mysqld_safe] line):
thread_cache_size = 64
query_cache_type = 1
key_buffer_size = 64M
query_cache_size = 64M
The last two values may need to be higher, but this is a VPS... Restart mysql after saving my.cnf.
[edit]
Added query_cache_type
@Sarge
I think I have those settings well in place but I will check I am at work right now..
@all
anyone know if these specs will run SMF just fine with 75-150 uses at the same time
Server 1 -
- AMD Athlon XP 2000+
- 1024MB DDR Memory (instead of 512MB!)
- 120GB EIDE Hard Drive
- 1000GB Traffic per month
- 100Mbit Connection
Server 2 - DOUBLED RAM!
- Intel Celeron 2.0Ghz
- 1024MB DDR Memory (instead of 512MB!)
- 120GB EIDE Hard Drive
- 1000GB Traffic per month
- 100Mbit Connection
by the way I also have a phpbb forum with around 20 users only and a wordpress site which gets about 50 uniques a day
Hello, any updates on the situation?
@Sarge
sorry for the long delay been busy the past few months... will try and do this on my off from work
No problem, we're here if/when you have any questions. :)
Hopefully everything will turn out alright.
back finally got the time to sit and work out on my issue..
right now my server is running slow seems like apache dies from time to time when I restart httpd the site works fine but apache will die again.
Status PHP (http://pinoypsp.com/status.php)
PHPinfo (http://pinoypsp.com/info.php)
my host tells me that apache is getting to much hits that is causing apache to slow down and just die for some reason.
a few notes I took this info when my server slowed down a few minutes ago
cat /proc/loadavg
0.33 0.41 0.40 1/61 18638
netstat -plan|grep :80|awk {'print $5'}|cut -d: -f1|sort|u niq -c|sort -nk1
1 0.0.0.0
1 155.45.81.26
1 195.229.241.180
1 202.57.41.4
1 58.71.64.216
1 66.249.72.234
2 122.53.147.135
2 125.60.241.207
2 202.175.224.36
2 66.174.93.47
2 69.147.111.107
2 86.96.226.13
2 86.96.226.14
3 124.105.13.215
3 125.60.243.124
3 213.42.2.22
4 121.54.32.35
4 124.106.200.184
4 125.60.241.250
4 203.215.116.113
4 92.236.128.212
5 122.3.106.93
5 15.211.153.73
6 121.1.53.17
6 121.54.1.12
6 125.5.36.66
6 125.60.229.52
6 203.111.232.106
6 203.81.166.2
6 222.127.205.244
6 69.112.150.197
7 119.95.117.68
7 121.97.228.186
7 122.3.213.47
7 125.60.241.21
7 219.90.80.30
7 222.127.223.71
8 122.2.80.38
8 122.53.100.117
8 124.217.105.170
8 125.60.241.202
9 119.94.185.197
9 122.131.169.109
9 122.2.114.86
9 122.53.11.191
9 125.212.13.225
9 170.252.160.1
10 119.94.187.183
10 121.54.32.50
10 124.105.161.11
10 124.217.91.161
10 58.69.103.163
10 60.50.20.44
11 121.96.214.142
11 121.97.224.21
11 124.106.138.58
11 202.8.243.46
11 203.111.237.49
11 203.160.170.149
11 203.87.203.202
11 58.69.11.11
11 58.69.37.250
11 58.69.91.14
12 203.177.180.234
12 222.127.189.217
12 58.69.18.120
12 71.172.43.70
15 125.60.243.21
15 222.127.184.169
17 119.95.115.73
23 124.106.178.118
23 203.87.206.134
27 218.186.12.8
31 122.2.219.190
42 222.127.221.233
netstat -apn |grep :80|wc -l
416
top - 21:26:24 up 1 day, 9:18, 1 user, load average: 0.44, 0.48, 0.43
Tasks: 40 total, 1 running, 39 sleeping, 0 stopped, 0 zombie
Cpu(s): 1.9% us, 0.2% sy, 0.0% ni, 96.4% id, 1.5% wa, 0.0% hi, 0.0% si
Mem: 12455808k total, 12009264k used, 446544k free, 211820k buffers
Swap: 12586916k total, 968k used, 12585948k free, 7831540k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
29890 mysql 15 0 210m 60m 4964 S 10 0.5 1:52.00 mysqld
14049 apache 15 0 99.4m 19m 11m S 4 0.2 0:16.45 httpd
14083 apache 15 0 99.3m 21m 13m S 3 0.2 0:14.90 httpd
21900 root 16 0 2100 1024 820 R 1 0.0 0:00.02 top
1 root 15 0 1960 652 564 S 0 0.0 0:00.19 init
15654 root 16 0 1628 572 484 S 0 0.0 0:00.64 syslogd
19812 root 16 0 6068 1032 668 S 0 0.0 0:00.00 sshd
19825 root 16 0 2600 872 712 S 0 0.0 0:00.03 xinetd
19956 root 21 0 5744 808 552 S 0 0.0 0:00.00 couriertcpd
19958 root 18 0 4588 1004 784 S 0 0.0 0:00.00 courierlogger
19966 root 24 0 5744 808 552 S 0 0.0 0:00.00 couriertcpd
19968 root 18 0 4588 1004 784 S 0 0.0 0:00.00 courierlogger
19974 root 21 0 5744 808 552 S 0 0.0 0:00.00 couriertcpd
19976 root 18 0 4588 1004 784 S 0 0.0 0:00.00 courierlogger
19983 root 22 0 5744 808 552 S 0 0.0 0:00.00 couriertcpd
19985 root 18 0 4588 1004 784 S 0 0.0 0:00.00 courierlogger
20018 qmails 16 0 1608 488 404 S 0 0.0 0:07.10 qmail-send
20026 qmaill 16 0 1560 464 400 S 0 0.0 0:00.01 splogger
20027 root 22 0 1588 352 268 S 0 0.0 0:00.00 qmail-lspawn
20028 qmailr 16 0 1588 384 296 S 0 0.0 0:00.00 qmail-rspawn
20029 qmailq 17 0 1552 344 284 S 0 0.0 0:00.29 qmail-clean
20064 root 16 0 37840 5348 3424 S 0 0.0 0:00.02 httpsd
20068 psaadm 21 0 37840 2532 612 S 0 0.0 0:00.00 httpsd
20107 root 18 0 5356 708 436 S 0 0.0 0:00.00 saslauthd
20108 root 18 0 5356 436 164 S 0 0.0 0:00.00 saslauthd
20127 root 15 0 7288 5368 1652 S 0 0.0 0:00.27 miniserv.pl
22468 root 15 0 3180 1096 576 S 0 0.0 0:00.09 crond
13714 root 16 0 10852 2972 2360 S 0 0.0 0:00.24 sshd
13787 root 15 0 2484 1380 1112 S 0 0.0 0:00.09 bash
14031 root 15 0 98612 12m 7520 S 0 0.1 0:00.27 httpd
14037 apache 16 0 101m 22m 11m S 0 0.2 0:12.56 httpd
14041 apache 17 0 98.4m 19m 11m S 0 0.2 0:09.30 httpd
14049 apache 15 0 99.4m 19m 11m S 0 0.2 0:16.33 httpd
14062 apache 16 0 99.4m 20m 12m S 0 0.2 0:11.75 httpd
14071 apache 16 0 99.7m 21m 12m S 0 0.2 0:18.91 httpd
14072 apache 16 0 99.2m 19m 10m S 0 0.2 0:09.43 httpd
14082 apache 16 0 99.5m 22m 13m S 0 0.2 0:19.75 httpd
29814 apache 16 0 98.7m 19m 11m S 0 0.2 0:06.09 httpd
29853 root 17 0 2340 1116 964 S 0 0.0 0:00.00 mysqld_safe
21900 root 16 0 2100 1024 820 R 0 0.0 0:00.00 top
any ideas I sure need some help right now
Hey :)
Mysql:
I noticed that your query_cache_size: is set to 0
that disables the query cache , is that intentional ?
Set this to 10M or whatever size your hoster allows.
I noticed as well that you have set the wait_timeout: to 28800
this is way too much set it to 50
Apache/Php:
Do you have to have so many extension and apache mods installed ?
please remove unwanted php mods and apache modules.
Do you need logfiles ? If not remove them !
they consume a great deal of resources.
(but keep the error logs :) )
Apache <-> Mysql:
See if you can enable persistent connection for your forum that can
speed up your sites a log.
Regards Mike
Quote from: Magic_Mike on June 03, 2008, 12:51:12 PM
Hey :)
Mysql:
I noticed that your query_cache_size: is set to 0
that disables the query cache , is that intentional ?
Set this to 10M or whatever size your hoster allows.
I noticed as well that you have set the wait_timeout: to 28800
this is way too much set it to 50
Apache/Php:
Do you have to have so many extension and apache mods installed ?
please remove unwanted php mods and apache modules.
Do you need logfiles ? If not remove them !
they consume a great deal of resources.
(but keep the error logs :) )
Apache <-> Mysql:
See if you can enable persistent connection for your forum that can
speed up your sites a log.
Regards Mike
its not really intentional I have a value for that inside my.cnf but for some reason I don't think its working... anyway to enable that thru the shell?
as for wait_timeout where do exactly I set that? my smf forum has this set to "Seconds before an unused session timeout" 2880
I am getting alot of these errors in httpd error_log
[Mon Jun 02 05:54:27 2008] [error] [client 127.0.0.1] Directory index forbidden by Options directive: /var/www/html/
[Mon Jun 02 05:54:42 2008] [error] [client 127.0.0.1] Directory index forbidden by Options directive: /var/www/html/
[Mon Jun 02 05:55:09 2008] [error] [client 127.0.0.1] Directory index forbidden by Options directive: /var/www/html/
[Mon Jun 02 05:55:13 2008] [error] [client 127.0.0.1] Directory index forbidden by Options directive: /var/www/html/
This must be inside the [mysqld] section
[mysqld]
.....
wait_timeout=50
query_cache_size = xx M
.....
it would not be recognized otherwise.
this error means that someone tries to access your site tru the ip you are using
apache tells you that in that dire specified in the main configuration file httpd.conf
the default server dir is set to /var/www/html/
That means that someone is scanning your site(s) . But can be harmless as well as the ip is "localhost" = 127.0.0.1 better safe than sorry and point it so somewhere else.
regards
@Magic_Mike
thanks what was the reason why it was not working it was not under mysqld... i've set it up thru the shell directly inside mysql.. found out that the slowness was being caused by TinyPortal 1.0.5 after removing it everything seems to be loading up fast now I will observe again.. thanks