Anyone with 2mill + post try this? This would increase my page content by millions...could cause some massive cpu/memory problems...
is there a simple way to remove them in case that happens? I would just dumb the new tables that were created right?
When you install this, you will see that your post count is not that big of a deal because pages do not get translated and stored in the database until someone, or a bot, pulls a page with the translation flag at the end.
So, there is no mass "translation" at all, if you have no bots clicking on the translations flags; and even if you have GoogleBot pulling on your site at all times, like we do, with 20 to 50 bots pulling at any time, the bots do not only pull on the translations flags, they are pulling all your content, so don't worry, this mod will not crash your site.
Make sure you upload translateflags.php to your FORUM folder.
At the end of the day the install works, you must have missed a step or not followed it correct.
Dear Dave ,
I am sure everything has done fine , maybe because of my MySQL or Php version .
I use php 5.2.10 and MySQL 5.0.83 did you wanna me to send you one of sites details , so you can check by your self ?
Thanks ,
Zi55
So, there is no mass "translation" at all, if you have no bots clicking on the translations flags; and even if you have GoogleBot pulling on your site at all times, like we do, with 20 to 50 bots pulling at any time, the bots do not only pull on the translations flags, they are pulling all your content, so don't worry, this mod will not crash your site.
Cheers.
Hi,
well not this script will crash your server.
But you should have ever an eye on your Server load and memory.
This script needs some of that. My Server crashed after I put this script on.
So I am try to optimise my server settings without any success.
The reason (I hope) was the crawler form www brandwatch net
They didi not respect the robos.txt at all:
Code:
User-agent: magpie-crawler
Disallow: /
Dose not help.
They try to crawl my site with a speed 50 times higher than Google.
All ?normal? Search Engines donning their Job with more respect.
I goning to move server anyway but is planed for November this Year.
My current one has only 1G of memory.
So: additional needs + to high crawler activities + low memory = crash
But it?s not this script, it was the crawler. Now he find himself in the IP-Tables as ?Drop?
This AddOn is working very well.
In appreciation of Dave's mod, I have updated a screen shot of some of our charts, where I have superimposed the timeline of when this mod was installed so you can see load avg, network load, GoogleBot hits/sec, etc.
From the charts, you can get a fairly good idea what to expect from this mod as far as performance hit and how GoogleBot starts to interact.
Mostly, you will see increased network usage based on GoogleBot hitting your flags and the translations, in and out, which will effect your load, network utilization, cpu, apache workers, etc.
It's all in the graphs... attached for reference. A picture speaks a thousand words, so they say :-)