SMF Support > Server Performance and Configuration

backup_smf_log_search_words keeps the server load to 100%

(1/3) > >>

A.SK:
Dear Team,

I have 1,30,000 topics in my board, 35000 members.

Daily unique visits dropped to 9300 from 10,600 every day for last 4 days.

Forum runs on a individual pro dedicated server with quad core and 8 gb of ram.

But for last 4 days the server load is always showing as 100%.

Because of that , the site is taking usually 1 min to start the display and takes another 1 min to load.

My server company checked and said, if we take backup_smf_log_search_words offline, then the server load goes down to 25% only.

Looking for suggestions.

Arantor:
That sounds like your server company doesn't know what it's talking about.

backup_smf_log_search_words is a *backup* table, it shouldn't be in use at all (unless for some strange reason your Settings.php has a $db_prefix of 'backup_smf_' which it shouldn't)

Let's establish that first, is your $db_prefix set to that?

A.SK:
Hi Arantor, You are right , this is there in my db_prefix.

########## Database Info ##########
$db_type = 'mysql';
$db_server = 'localhost';
$db_name = 'forum_smf20beta3';
$db_user = 'forum_smf20be';
$db_passwd = '';
$ssi_db_user = '';
$ssi_db_passwd = '';
$db_prefix = 'smf_';
$db_persist = '0';
$db_error_send = 0;

Arantor:
So you can remove that now, we've established that your host doesn't really know what he's talking about.

Have you carried out any of the tips in http://www.simplemachines.org/community/index.php?topic=293441.0 ?

A.SK:
Before coming to this board. I have done a search on the topic you have mentioned. But i want to first sort the load issue then go to that topic.

1) Do you think, if i remove _smf from the db prefix. Will i get the issue sorted.

2) I wanted to know what will happen to my topics and registrations etc.

3) will it affect only the search log words.

4) do i loose all my search saved so far.

Kindly assist me arantor.

Navigation

[0] Message Index

[#] Next page