server load

[se7o.com]

The website produces a very high load on the server, with lot of mysql
connections.

[se7o.com]

haaaaaaaaaay

[H]

You have made a blanket statement with nothing to back it up.

Which version are you using?
What mods do you have installed?
Are you getting errors in your error log? (Errors slow down page load)
Have you looked at the optimisation tips stickied in this board?

[se7o.com]

 hiii
thank you for your answer
look i can't weite english good

Which version are you using?

1.1.10

What mods do you have installed?

Color And BgColor BBCode Bar     

2.    URL Popup Tr    
3.    Enchanced post template    
4.    FontandSizeDropdown_
5.    Board Viewers Mod    
6.    Image Popup Tr
7.    No Spam by Guests!
8.    Ultimate Profile
9.    Enhanced Quick Reply Box
10.    Global Announcements
11.    Users Online Today Mod
12.    AJAX Recent Topics
13.    YouTube BBCode
14.    Topic Title In The Center Under Linktree
15.    No Spam by Guests!
16.    NoFollow All Links
17.    Enhanced Quick Reply Box
18.    SMF Sitemap
19.    Social Bookmarks
20.    SMF Arcade

Are you getting errors in your error log? (Errors slow down page load)

look
i was disabled Error Logs
Because it was make very  big load in the server

but i have problem from a long time
the problem is
when i'm trying to upgrade my fourm
it's upgrade file only
but cant upgrade my databais
my forum file now is 1.1.10
but my database is 1,1,7

i was try to do that a lot of times
but it not complete the upgrade and server is down

Have you looked at the optimisation tips stickied in this board?

no , because i  cant understand all words

but i will try to translate it

[H]

You may want to remove some of the mods to see if this helps with performance

Because it was make very  big load in the server

Adding the error logs to the server will increase the server load, but so will having to generate them in the first place. Ideally you want to fix them!

no , because i  cant understand all words

Perhaps the Arabic translators, Maher and islam2hamy can help you out?

[se7o.com]

thank you for your answer
i remove the not important mods
look

the server and the site working good in all time

but every day in one time the load go high

could you help me

and plz

how enable the error log

and how can i see it

[Aleksi "Lex" Kilpinen]

but every day in one time the load go high

This to me would say that you are not the one causing the load, and can't do much about it.
It is something running in the background, or possibly even in another account on the same server.

[se7o.com]

could you tell me how can i catch what is run in background

[se7o.com]

look
i upload this tool

http://download.simplemachines.org/index.php?thanks;filename=status.php


i think this the problem here

Opened vs. Open tables:
(table_cache)    14570.3242 (should be <= 80)

[Aleksi "Lex" Kilpinen]

Are you on a shared host? Or perhaps a VPS or a dedicated server?
Could you link us to your status.php?

[se7o.com]

i using share host

and i will send u in pm my  Status page

[Aleksi "Lex" Kilpinen]

On a shared host you are out of luck, unless you can convince your host to switch you to a less crowded server. Sorry.

[se7o.com]

thank u for your answer

i want know what is the problem that make this problem

[Aleksi "Lex" Kilpinen]

A bad host? A too big board on a small shared hosting? Wrongly configured MySQL server?
There are many options that can be the root if this, but almost everything falls back to the host.
So - in short, it is most probably your host causing this.

[se7o.com]

i want you tell me how my host can fix this problem
or how he can catch the reson of the problem


look

this  was in Status.php




Simple Machines
Server Status
Basic Information
October 20, 2009, 06:26:14 PM
MySQL processes
Total processes:    41 (1 sleeping, 3 running, 37 locked)

Running processes
State    Time    Query
Sending data    125s   

SELECT t.ID_TOPIC
FROM smf_messages as m, smf_topics as t, smf_boards as b
WHERE m.ID_MSG = t.ID_LAST_MSG
AND b.ID_BOARD = m.ID_BOARD
AND FIND_IN_SET(-1, b.memberGroups)
LIMIT 100000

Sending data    1s   

SELECT
   t.ID_TOPIC, t.numReplies, t.locked, t.numViews, t.isSticky, t.ID_POLL,
   0 AS new_from,
   t.ID_LAST_MSG, ml.posterTime AS lastPosterTime, ml.ID_MSG_MODIFIED,
   ml.subject AS lastSubject, ml.icon AS lastIcon, ml.posterName AS lastMemberName,
   ml.ID_MEMBER AS lastID_MEMBER, IFNULL(meml.realName, ml.posterName) AS lastDisplayName,
   t.ID_FIRST_MSG, mf.posterTime AS firstPosterTime,
   mf.subject AS firstSubject, mf.icon AS firstIcon, mf.posterName AS firstMemberName,
   mf.ID_MEMBER AS firstID_MEMBER, IFNULL(memf.realName, mf.posterName) AS firstDisplayName,
   LEFT(ml.body, 384) AS lastBody, LEFT(mf.body, 384) AS firstBody, ml.smileysEnabled AS lastSmileys,
   mf.smileysEnabled AS firstSmileys
FROM (smf_topics AS t, smf_messages AS ml, smf_messages AS mf)
   LEFT JOIN smf_members AS meml ON (meml.ID_MEMBER = ml.ID_MEMBER)
   LEFT JOIN smf_members AS memf ON (memf.ID_MEMBER = mf.ID_MEMBER)
WHERE t.ID_BOARD = 81
   AND ml.ID_MSG = t.ID_LAST_MSG
   AND mf.ID_MSG = t.ID_FIRST_MSG
ORDER BY isSticky DESC, ID_LAST_MSG DESC
LIMIT 0, 50

MySQL Statistics
MySQL 5.0.x
Connections per second:    1.8408
Kilobytes received per second:    1.3795
Kilobytes sent per second:    0.4921
Queries per second:    86.7052
Percentage of slow queries:    0.0004
Opened vs. Open tables:
(table_cache)    14570.3242 (should be <= 80)
Table cache usage:
(table_cache)    1 (should be >= 0.5 and <= 0.9)
Key buffer read hit rate:
(key_buffer_size)    0.001 (should be <= 0.01)
Key buffer write hit rate:
(key_buffer_size)    0.0663 (should be <= 0.5)
Thread cache hit rate:
(thread_cache_size)    34.4136 (should be >= 30 )
Thread cache usage:
(thread_cache_size)    0.625 (should be >= 0.7 and <= 0.9)
Temporary table disk usage:
(tmp_table_size)    0.091 (should be <= 0.5)
Sort merge pass rate:
(sort_buffer)    0 (should be <= 0.001)
Query cache enabled:
(query_cache_type)    1 (should be >= 1 and <= 1)
Query cache miss rate:
(query_cache_limit)    0.4798 (should be <= 0.5)
Query cache prune rate:
(query_cache_size)    0.0856 (should be <= 0.05)

[Tiribulus]

The point they are making is that on an inexpensive shared host you are probably getting out of it the best they are going to give you. Like the other guy said it sounds like somebody else's space that is shared with you is getting high traffic at that time using the resources.

I'm doing my best to say this in simple English because I understand it is not your language. Bottom line is you are not likely to see better results with this hosting situation.

EDIT: If you have access to phpmyadmin you may want to try increasing the table cache, but I wouldn't expect miracles out of that. I haven't done it in a while so somebody else will have to tell you how.

[se7o.com]

thank you
Tiribulus
for your answer

look the server is work doog agine when my host stop my site


----

I found that total error records reads '1255700467' from the forum's
administration panel, while it reads only '20' records at phpMyAdmin,
I think this is the reason of the instability, can you please guide me
in how to fix this issue.

########## Error-Catching ##########
# Note: You shouldn't touch these settings.
$db_last_error = 1255700467;

[Tristan Perry]

Don't change that! That isn't saying that you've had 1255700467 errors. It is just what's called the UNIX timestamp of when your database last crashed. As you can see from:

http://www.4webhelp.net/us/timestamp.php?action=stamp&stamp=1255700467&timezone=0

You last had an error "Friday, October 16th 2009, 13:41:07 (GMT)"

What you quoted is nothing to worry about

The cause of this is that the server is too slow to handle your site. This might be because your host hasn't managed the server properly, or it may be that your forum is too big for shared hosting. (Without knowing your site's URL or a link to your status.php file I can't be too sure)

[se7o.com]

thank u
i have more 19000 user

i think the problem with the host if it cant work my site

but my site work good  and in one second the load go very high

i want know why in this time only get high

[Tristan Perry]

You'd have to ask your host, it's their job to diagnose this issue (we can't possibly know, since it's a shared host)

Although if it's happening at the same time, it's almost definitely down to a cron job - either one that one of your host's customers are running, or one of your host's root cron jobs.