 |
Bilderberg.org
the view from the top of the pyramid of power
|
| View previous topic :: View next topic |
| Author |
Message |
TonyGosling
Site Admin
Joined: 26 Jul 2006
Posts: 1395
Location: St. Pauls, Bristol, UK
|
|
| Back to top |
|
 |
jiddu_k
Joined: 14 May 2009
Posts: 6
|
 Posted: Fri May 15, 2009 11:29 am Post subject: Re: 911 Forum down - free discussion |
 |
|
Paranoia? They have eyes everywhere and this bilderberg site is surely more pertinent? 
The meeting doesn't seem to be stopping Charlie Skelton posting in the Grauniad...
http://www.guardian.co.uk/world/series/charlie-skeltons-bilderberg-files
| Quote: | We have had to suspend the 911forum.org.uk site due to it causing excessive
load (this appears to be masses of lengthy MySQL queries) on the server
which in turn is negatively affecting performance for the other sites on the
server. Please contact us to discuss this matter further.
Kind Regards, (oh sure!)
Simon Wallis
UH Support |
I've wondered for some time if there isn't a bug lurking in your SQL code or maybe it's gooogle's net bots blitzing the forum - a sustained but normally non-critical DoS attack? Then there's 'TrackMeNot' - one could almost claim this 'useful' tool is a DoS attack in it's own right. http://www.mrl.nyu.edu/~dhowe/trackmenot/
Otherwise the above makes no sense at all - it's a small site, relative to say infowars forum, and with relatively few consistent posters.
I do hope this can be sorted without too much hair-tearing, Tony. How much storage does 911forum need? |
|
| Back to top |
|
|
TonyGosling
Site Admin
Joined: 26 Jul 2006
Posts: 1395
Location: St. Pauls, Bristol, UK
|
| Posted: Fri May 15, 2009 3:06 pm Post subject: |
|
|
The major contributor of the load was the following lengthy mysql queries. You should need to consider optimizing the mysql queries or the mysql databases for decreasing the running time of the queries. (Query time is recorded in the 5th column)
1851 ineal localhost:46445 911forum_c 120 Query SELECT f.*, p.*, pt.*, t.*, u.* FROM phpbb_topics AS t, phpbb_users AS u,phpbb_posts_text AS
1827 ineal localhost:46403 911forum_c 135 Query SELECT f.*, p.*, pt.*, t.*, u.* FROM phpbb_topics AS t, phpbb_users AS u, phpbb_posts_text AS
2015 ineal localhost:46725 911forum_c 38 Query UPDATE phpbb_topics SET topic_views = topic_views + 1 WHERE topic_id = 17214
2018 ineal localhost:46729 911forum_c 38 Query UPDATE phpbb_topics SET topic_views = topic_views + 1 WHERE topic_id = 17214
1997 ineal localhost:46668 911forum_c 48 Query UPDATE phpbb_topics SET topic_views = topic_views + 1 WHERE topic_id = 17214
1980 ineal localhost:46628 911forum_c 60 Query UPDATE phpbb_topics SET topic_views = topic_views + 1 WHERE topic_id = 16989
1903 ineal localhost:46519 911forum_c 107 Query UPDATE phpbb_topics SET topic_views = topic_views + 1 WHERE topic_id = 17214
6583 ineal localhost:53792 911forum_c 60 Query UPDATE phpbb_topics SET topic_views = topic_views + 1 WHERE topic_id = 13478
6553 ineal localhost:53741 911forum_c 95 Query SELECT f.*, p.*, pt.*, t.*, u.* FROM phpbb_topics AS t, phpbb_users AS u, phpbb_posts_text AS
6482 ineal localhost:53634 911forum_c 132 Query SELECT f.*, .*, pt.*, t.*, u.* FROM phpbb_topics AS t, phpbb_users AS u, phpbb_posts_text AS
_________________
http://www.radio4all.net/index.php/contributor/2149
Secret Rulers https://www.youtube.com/watch?v=h0p-e2ng0SI
http://www.thisweek.org.uk
http://www.dialectradio.co.uk
http://www.911forum.org.uk |
|
| Back to top |
|
|
TonyGosling
Site Admin
Joined: 26 Jul 2006
Posts: 1395
Location: St. Pauls, Bristol, UK
|
|
| Back to top |
|
|
TonyGosling
Site Admin
Joined: 26 Jul 2006
Posts: 1395
Location: St. Pauls, Bristol, UK
|
|
| Back to top |
|
|
Ian Fantom
Joined: 15 May 2009
Posts: 2
Location: Newbury, Berkshire
|
| Posted: Fri May 15, 2009 4:17 pm Post subject: |
|
|
| TonyGosling wrote: | I need some technical help please from Jim or whoever.
I don't understand at all what the admins are saying. |
There should be some simple statement from your host saying what resources you are using and what you are contracted for. If all you get is gobbledygook then it's their fault and not yours. I suggest you press them for such a statement.
Regards,
Ian. |
|
| Back to top |
|
|
jiddu_k
Joined: 14 May 2009
Posts: 6
|
| Posted: Fri May 15, 2009 4:20 pm Post subject: |
|
|
| Quote: | | 6482 ineal localhost:53634 911forum_c 132 Query SELECT f.*, .*, pt.*, t.*, u.* FROM phpbb_topics AS t, phpbb_users AS u, phpbb_posts_text AS |
Hope I didn't raise your hopes, Tony, but I am 20 years beyond my SQL days. Having said that, although you didn't post the complete log lines, this last one quoted above appears to have a missing parameter at Query SELECT f.*,?.*,pt.* etc etc
Yes, the response times imply 'stuck in loops' somewhere, imo.
---
Here's an interesting site that Bilderberg don't like:-
http://www.libertas.eu/ |
|
| Back to top |
|
|
Ian Fantom
Joined: 15 May 2009
Posts: 2
Location: Newbury, Berkshire
|
| Posted: Fri May 15, 2009 4:26 pm Post subject: Re: 911 Forum down - free discussion |
|
|
| jiddu_k wrote: |
Paranoia? They have eyes everywhere and this bilderberg site is surely more pertinent?
|
I would have gone for the 911 Forum; it's bigger and more dangerous.
Two questions:
1. Was anything said at the national 9/11 meeting in London on Monday?
2. Have any 9/11 sites in other countries mysteriously gone down?
Since Tony is the expert on Bilderberg as well as webmaster for 911forum.org.uk, I think I would have gone for that.
Regards, Ian. |
|
| Back to top |
|
|
Jimbo
Joined: 15 May 2009
Posts: 1
|
| Posted: Fri May 15, 2009 7:04 pm Post subject: |
|
|
Looks like the phpBB board has exceeded the limits imposed by United Hosting.
The queries with the highest times (in seconds, I assume) are specifically used by the "phpBB Fetchall" script(s). They provide the dynamic frontpage data.
However:
| Quote: | | 1903 ineal localhost:46519 911forum_c 107 Query UPDATE phpbb_topics SET topic_views = topic_views + 1 WHERE topic_id = XYZ |
Is used in several places by various scripts (mods and phpBB) and it is not possible to determine from the provided information where they are being called from. Anyway, the time to execute the queries is high wherever they come from ...
The time to execute certain queries will increase as the size of the database increases, so it looks like the database and respective queries have outgrown the UH hosting package limits. I assume that UH have tried to optimise the database before pulling you up on this - it's worth asking but even then it's only a matter of time before you hit the limits again.
Optimising the queries may be possible but some of them are emanating from the phpBB board code itself and that probably limits what can be done. Other factors complicate the issue such as the query rate and the speed at which the web server and PHP system can offload the data returned by the queries. Overall, it's a matter of server loading and that seems to be too high.
It does look as though either there is a problem with the server/database system and/or you need to move to a dedicated server. 
Jim |
|
| Back to top |
|
|
TonyGosling
Site Admin
Joined: 26 Jul 2006
Posts: 1395
Location: St. Pauls, Bristol, UK
|
| Posted: Fri May 15, 2009 8:08 pm Post subject: |
|
|
Thanks Jim,
Do you still have access to the back end of the site?
If so can you tweak these 'queries' to get it up live temporarily while we move to a new package?
Is this normal behaviour for an ISP?
| Jimbo wrote: | Looks like the phpBB board has exceeded the limits imposed by United Hosting.
The queries with the highest times (in seconds, I assume) are specifically used by the "phpBB Fetchall" script(s). They provide the dynamic frontpage data.
However:
| Quote: | | 1903 ineal localhost:46519 911forum_c 107 Query UPDATE phpbb_topics SET topic_views = topic_views + 1 WHERE topic_id = XYZ |
Is used in several places by various scripts (mods and phpBB) and it is not possible to determine from the provided information where they are being called from. Anyway, the time to execute the queries is high wherever they come from ...
The time to execute certain queries will increase as the size of the database increases, so it looks like the database and respective queries have outgrown the UH hosting package limits. I assume that UH have tried to optimise the database before pulling you up on this - it's worth asking but even then it's only a matter of time before you hit the limits again.
Optimising the queries may be possible but some of them are emanating from the phpBB board code itself and that probably limits what can be done. Other factors complicate the issue such as the query rate and the speed at which the web server and PHP system can offload the data returned by the queries. Overall, it's a matter of server loading and that seems to be too high.
It does look as though either there is a problem with the server/database system and/or you need to move to a dedicated server.
Jim |
_________________
http://www.radio4all.net/index.php/contributor/2149
Secret Rulers https://www.youtube.com/watch?v=h0p-e2ng0SI
http://www.thisweek.org.uk
http://www.dialectradio.co.uk
http://www.911forum.org.uk |
|
| Back to top |
|
|
outsider
Trustworthy Freedom Fighter
Joined: 15 May 2009
Posts: 7
Location: London E1
|
| Posted: Fri May 15, 2009 10:03 pm Post subject: |
|
|
Hi Tony,
I found the site, and have registered.
Here was one of the responses from MSM re site down:
Here is MSM's response:
We are seeing an increased volume of traffic by some malware software. In order to protect our customers from damage from that malware, we are blocking your query. A few legitimate queries may get flagged, and for that we apologize. Please be assured that we are hard at work on this problem and hope to get it resolved even better as soon as possible.
If you are using phpBB, please check out the phpBB downloads site http://www.phpbb.com/downloads.php and make sure you are not vulnerable.
- MSN Search Team |
|
| Back to top |
|
|
TonyGosling
Site Admin
Joined: 26 Jul 2006
Posts: 1395
Location: St. Pauls, Bristol, UK
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
