Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> MySQL
Author Message
bugsy
Worker
Worker



Joined: May 08, 2007
Posts: 130

PostPosted: Wed Apr 23, 2008 8:30 am Reply with quote

Hi,

The site http://press.xtvworld.com is going down time to time as most probably the MySql server is rejecting any connection as there are too many connections to the database (As per my host).

Its running nuke7.0.

Once before my previous host blocked the site as they wanted to make me optimize the querries...instead what i did is just change the host and everything worked fine for almost 6 months till this site again went down. Previous discussion can be found here..
http://www.ravenphpscripts.com/postt14172.html

Now what I want to do is keep the live visitor connections and cut down as many automated queries/connections taking place in the site from both content harvesting bots and other bots and from the site also so that MySql server handles less pressure and my visitors can access the site.

How can i go about it? Site is down presently with cannot connect to database error..

I have in fact flipped the Site Active switch through PHPMYAdmin to temp deactivate the site...surely will activate it after few hours to see if MYSql server works or not...

All suggestions welcome about how to go about it..

Thanks in advance..
 
View user's profile Send private message Visit poster's website
bugsy







PostPosted: Wed Apr 23, 2008 10:01 am Reply with quote

Some data i got from MYSQL Run Time Information since it was restarted an hour or so back...

Connection related
The Division: Connections/Per Hour/Percent
max. concurrent connections: 77/--/--
Failed attempts: 573/394.34/54.57%
Aborted: 2/1.38/0.19%
Total: 1,050/722.62/100.00%
The Division: Connections/Per Hour/Percent

Query Related
Query/Per Hour/Percent
change db: 344.10/28.77%
select: 240.87/20.14%
set option: 68.82/5.75%
show variables: 37.16/3.11%
update: 33.72/2.82%
show tables: 31.66/2.65%
show charsets: 17.21/1.44%
show collations: 17.21/1.44%
delete: 6.19/0.52%
show binlogs: 5.51/0.46%
insert: 4.82/0.40%
Query/Per Hour/Percent
 
Guardian2003
Site Admin



Joined: Aug 28, 2003
Posts: 6799
Location: Ha Noi, Viet Nam

PostPosted: Wed Apr 23, 2008 11:28 am Reply with quote

Your 'Sponsors' block iframe isn't working and I would certainly cut down on the number of news items shown on the front page.
If you are not using RavenNuke you might want to consider it - every time your front page loads it runs a host of queries trying to update the module list which you don't need to be doing for anonymous users.
It might be worth going over your server stats logs to which which area's get hit the hardest and concentrate on optimising the queries on those pages.
 
View user's profile Send private message Send e-mail
bugsy







PostPosted: Wed Apr 23, 2008 11:51 am Reply with quote

Hi,

Thanks for that input -
a) Will cut down home page stories
b) I do intend to upgrade to 7.6 but due to regular work its keeping on getting delayed...but i guess need to prioritize it now! I did try to migrate to RavenNuke in Xaamp but got stuck all the times!
c) What I am not understanding is how to optimize the queries. I do optimize the site everyday through that backend option.

After i activated the site again - site is running slowly but at least is loading now - how long i do not know.

Any way i can reduce automated queries? Which are not made by live human visitors.

One more thing...each day sentinel emails me hundreds of hack attempt reports can that pressure the server also? Then if so how do i make sentinel Block and Forward to Default Page and not send email to reduce the load (this particular option is not there in the sentinel i got).

I also make the site email me stories each time they are posted (20-30 a day) as its a PR site and they need to be edited - can that too put pressure on MySql?
 
Guardian2003







PostPosted: Wed Apr 23, 2008 12:22 pm Reply with quote

c - not really much you can do without getting elbow deep in the code. Standard nuke does a fair amount of 'releasing' queries after they are used but we actually found that in some case it costs more in memory to 'release' the query that just leave it alone and let mysql itself take care of it.

User info blocks look nice and pretty but do you actually need one other than the normal 'log in' block? These tend to have a high query count, as do other blocks that fetch data. If you do not need that data publicly accessible on the front page, turn them off.
Posting/editing news generates queries as it has to fetch and update data from the DB each time - not much you can do with that as it is an important function for your site though perhaps you could review and edit them closer to the end of the hour (most hosts who limit sql queries do so on a per hour basis) so finding out your servers time zone might be handy Wink

If you search on this site, you might find some interesting posts on how to actually overcome limitations by creating different database users.
 
evaders99
Former Moderator in Good Standing



Joined: Apr 30, 2004
Posts: 3221

PostPosted: Wed Apr 23, 2008 8:46 pm Reply with quote

Time to move off a shared server - phpNuke is a database intensive script. Yes you can do certain levels of optimization, but you're not likely to cut it sufficiently to stop this from happening in the future.

The phrase "you get what you pay for" is certainly applicable here. You will just continue to limit your site to future growth. If you want to keep your site viable and users happy, invest in better hosting.

_________________
- Star Wars Rebellion Network -

Need help? Nuke Patched Core, Coding Services, Webmaster Services 
View user's profile Send private message Visit poster's website
bugsy







PostPosted: Thu Apr 24, 2008 8:14 am Reply with quote

Hi,

@ Guardian
Quote:
c - not really much you can do without getting elbow deep in the code. Standard nuke does a fair amount of 'releasing' queries after they are used but we actually found that in some case it costs more in memory to 'release' the query that just leave it alone and let mysql itself take care of it.


So it sounds like upgrading to 7.6 to start off with is a better idea than playing around with 7.0 codes!

Quote:
User info blocks look nice and pretty but do you actually need one other than the normal 'log in' block? These tend to have a high query count, as do other blocks that fetch data. If you do not need that data publicly accessible on the front page, turn them off.


I have replaced it with the traditional login block - its missing the dynamism of site info block but as you said if that creates to much queries it better be gone!

Quote:
Posting/editing news generates queries as it has to fetch and update data from the DB each time - not much you can do with that as it is an important function for your site though perhaps you could review and edit them closer to the end of the hour (most hosts who limit sql queries do so on a per hour basis) so finding out your servers time zone might be handy


Thing is I am running the DB in a VPS hosting account and not shared so there also hosts limit connection per hour? I mean the MYSql was installed in a VPS environment meant for my hosting only...so can't I control the connections somehow?

Quote:
If you search on this site, you might find some interesting posts on how to actually overcome limitations by creating different database users.


I guess you mean to say One site accessing A central database under different user ids! That i never thought of..will surely research a bit on that..


@ evaders99
Quote:
Time to move off a shared server - phpNuke is a database intensive script. Yes you can do certain levels of optimization, but you're not likely to cut it sufficiently to stop this from happening in the future.


Ya I know and that is the reason i shifted from a shared hosting environment to an eco VPS hosting account - at first..6 months everything ran smoothly then suddenly this problem starts happening. Well to be exact occational time outs do happen time to time when the stories are posted and lots of voisitors come to the site to pick it up all at the same time kinda. Site has over 20,000 posted stories can that cause a strain or its the issue of too many connections only?

I guess the issues have been brewing inside the DB for long - from my encounter with the shared hosting (6 -7 months back) and now its causing problems in VPS too.
 
evaders99







PostPosted: Thu Apr 24, 2008 2:40 pm Reply with quote

VPS is shared.. not on the Apache level but on the actual hardware level. You're running one OS, some others are running other OS. MySQL is still limited on the connections it can serve if it gets no processing time.

I've had friends running VPS who needed to upgrade to a dedicated server. They were completely satisfied and so were their users. It does require a more monthly cost than an cheap "eco" hosting. As I said, you get what you pay for.
 
bugsy







PostPosted: Fri Apr 25, 2008 4:20 am Reply with quote

Ya i know but costs will go up 5 folds i guess Smile may be will try a better VPS to start off with and then shift to dedicated. I don't think I will get reliable dedicated hosts below $99!
 
Raven
Site Admin/Owner



Joined: Aug 27, 2002
Posts: 17088

PostPosted: Fri Apr 25, 2008 5:12 am Reply with quote

How many hits per day is your site receiving?
 
View user's profile Send private message
bugsy







PostPosted: Fri Apr 25, 2008 8:21 am Reply with quote

Hi Raven,

I do not know this kinda much of hits can generate this kinda load or not..i do hits follow up with stat counter and say averaging around 750 uniques a day with say 1200 page loads/day. But my story database size is big as i said over 20,000 PRs posted so far!
 
guidyy
Worker
Worker



Joined: Nov 22, 2004
Posts: 208
Location: Italy

PostPosted: Fri Apr 25, 2008 8:41 am Reply with quote

Hummm ! To me 750 u/v a day with 1200 pages is LOW traffic.
One of my sites run on a shared server with triple the traffic and about 10.000 pages, with no problems but I still complain for low traffic LOL.
I wonder if some 3rd party module or block is messing up the database...
 
View user's profile Send private message Visit poster's website MSN Messenger
fkelly
Former Moderator in Good Standing



Joined: Aug 30, 2005
Posts: 3312
Location: near Albany NY

PostPosted: Fri Apr 25, 2008 9:47 am Reply with quote

You might try installing the yslow add on for Firefox and looking at your page with it. You are running a heck of a lot of javascript for instance.
 
View user's profile Send private message Visit poster's website
Raven







PostPosted: Fri Apr 25, 2008 10:38 am Reply with quote

Bugsy,

Something else is definitely going on because (no offense intended) that amount of traffic shouldn't even cause a hiccup. I would tell your host to either isolate and tell you what the problem really is or get a new host.
 
bugsy







PostPosted: Fri Apr 25, 2008 11:53 am Reply with quote

Ya that is what i was also thinking I have seen sites with double or thrice hits running faster. One thing i have noticed that even if in statcounter i am seeing say 1200 page loads -- in the 'site info' block around the clock it used to show 100-200 visitors per hour (Even from inside the backend panel i get to see that) so can those be automated hits from bots etc? What my guess is as its a content distribution site many sites and people might be running automated content fetching scripts bots etc on this site and that can be causing the overload...but all that is just a guess (RSS Readers, Syndic 8 and all that).

Java script i will check on as the ones running are the required ones but that even if can make the page slow i do not think can affect the mysql.

This problem was so acute 6 months back it overflowed my hosts shared mysql server - who kept asking me to optimize my queries. And this ones harping about too many connections.

What I have done so far this time is as suggested here
a) Taken out Site Info
b) Cut down stories in home page

Do intend to check on the java scripts also..and surely will have a try at 7.6 soon and if problems persist can think of again shifting i guess!
 
bugsy







PostPosted: Fri Apr 25, 2008 1:21 pm Reply with quote

Hi guys somethings up for sure can be a wild guess also... I ran some check with YSlow and came up with these startling facts!....

Code:
 Make fewer HTTP requests


This page has 24 external JavaScript files.
This page has 4 external StyleSheets.
This page has 18 CSS background images.

Impossible i haven't put 24 javascript and i counted max 6 are there in souurce code

Code:
You can add your own CDN hostname preferences.

These components are not on a CDN:

    * [HTTP headers]  http://www.18mart.org/wp-content/plugins/xspf_player/xspf_player.swf?...
    * [HTTP headers]  http://www.youtube.com/swf/l.swf?...
    * [HTTP headers]  http://www.youtube.com/swf/l.swf?...
    * [HTTP headers]  http://www.google-analytics.com/urchin.js
    * [HTTP headers]  http://www.18mart.org/wp-content/themes/18mart/pngfix.js
    * [HTTP headers]  http://www.18mart.org/wp-content/plugins/flash-video-player/swfobject.js
    * [HTTP headers]  http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/prototype.js
    * [HTTP headers]  http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/scriptaculous.js
    * [HTTP headers]  http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/builder.js
    * [HTTP headers]  http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/effects.js
    * [HTTP headers]  http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/dragdrop.js
     [HTTP headers]  http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/controls.js
     [HTTP headers]  http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/slider.js
    * [HTTP headers]  http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/lightbox.js
    * [HTTP headers]  http://www.18mart.org/flashobject.js
    * [HTTP headers]  http://zirve100.com/CounterV4.js
    * [HTTP headers]  http://logo.webservis.gen.tr/c.js
    * [HTTP headers]  http://www.18mart.org/wp-content/themes/18mart/style.css
    * [HTTP headers]  http://www.18mart.org/wp-content/plugins/lightbox-2/Themes/Dark%20Grey/lightbox.css
    * [HTTP headers]  http://www.18mart.org/wp-content/plugins/pagenavi/pagenavi-css.css
    * [HTTP headers]  http://www.18mart.org/wp-content/themes/18mart/images/bg3.jpg
    * [HTTP headers]  http://www.18mart.org/wp-content/themes/18mart/images/wrapper-corner.gif
    * [HTTP headers]  http://www.18mart.org/wp-content/themes/18mart/images/wrapper-corner2.gif
    * [HTTP headers]  http://www.18mart.org/wp-content/themes/18mart/images/icon-tags5.gif
    * [HTTP headers]  http://www.18mart.org/wp-content/themes/18mart/images/icon-tags7.gif
    * [HTTP headers]  http://www.18mart.org/wp-content/themes/18mart/images/icon-tags4.gif
    * [HTTP headers]  http://www.18mart.org/wp-content/themes/18mart/images/icon-tags.gif
    * [HTTP headers]  http://www.18mart.org/wp-content/themes/18mart/images/icon-tags3.gif
    * [HTTP headers]  http://www.18mart.org/wp-content/themes/18mart/images/left-folder.gif
    * [HTTP headers]  http://www.18mart.org/wp-content/themes/18mart/images/category-bg.gif
    * [HTTP headers]  http://www.18mart.org/wp-content/themes/18mart/images/archive-bg.gif
    * [HTTP headers]  http://www.18mart.org/wp-content/themes/18mart/images/bottomr.gif
    * [HTTP headers]  http://www.18mart.org/wp-content/plugins/lightbox-2/Themes/Dark%20Grey/images/blank.gif
    * [HTTP headers]  http://www.18mart.org/wp-content/plugins/lightbox-2/Themes/Dark%20Grey/images/loading.gif
    * [HTTP headers]  http://www.18mart.org/wp-content/plugins/lightbox-2/Themes/Dark%20Grey/images/closelabel.gif
  * [HTTP headers] 
http://www.18mart.org/wp-content/plugins/print/images/print.gif
    * [HTTP headers]  http://www.18mart.org/mehmetcik.png
    * [HTTP headers]  http://www.18mart.org/300x250.jpg
    * [HTTP headers]  http://www.18mart.org/fotos.png
    * [HTTP headers]  http://www.18mart.org/saruret.png
    * [HTTP headers]  http://www.18mart.org/foto.png
    * [HTTP headers]  http://www.18mart.org/160x600.jpg
    * [HTTP headers]  http://t1.extreme-dm.com/i.gif
    * [HTTP headers]  http://e2.extreme-dm.com/s11.g?...
    * [HTTP headers]  http://www.blogcatalog.com/images/buttons/blogcatalog5.gif
    * [HTTP headers]  http://zirve100.com/Counter.aspx?...
    * [HTTP headers]  http://logo.webservis.gen.tr/logo/2.gif
    * [HTTP headers]  http://www.blogarama.com/images/button.gif
    * [HTTP headers]  http://www.18mart.org/160x600.png
    * [HTTP headers]  http://www.18mart.org/wp-content/themes/18mart/images/rssfeed.gif
   

I have taken out the ones i know from above and I don't have any freaking idea from where these domains are coming into the picture!!
Code:


youtube.com
18mart.org
zirve100.com
blogarama.com
t1.extreme-dm.com
t2.extreme-dm.com
logo.webservis.gen.tr


Then here also..

Code:
These components do not have a far future Expires header:


    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/themes/18mart/style.css
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/plugins/lightbox-2/Themes/Dark%20Grey/lightbox.css
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/plugins/pagenavi/pagenavi-css.css
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/themes/18mart/pngfix.js
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/plugins/flash-video-player/swfobject.js
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/prototype.js
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/scriptaculous.js
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/builder.js
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/effects.js
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/dragdrop.js
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/controls.js
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/slider.js
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/lightbox.js
    * [HTTP headers]  (no expires) http://www.18mart.org/flashobject.js
    * [HTTP headers]  (no expires) http://zirve100.com/CounterV4.js
    * [HTTP headers]  (no expires) http://logo.webservis.gen.tr/c.js
    * [HTTP headers]  (4/25/2008) http://feeds.feedburner.com/kimnededi.2.gif
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/plugins/print/images/print.gif
    * [HTTP headers]  (no expires) http://www.18mart.org/mehmetcik.png
    * [HTTP headers]  (no expires) http://www.18mart.org/300x250.jpg
    * [HTTP headers]  (no expires) http://www.18mart.org/fotos.png
    * [HTTP headers]  (no expires) http://www.18mart.org/saruret.png
    * [HTTP headers]  (no expires) http://www.18mart.org/foto.png
    * [HTTP headers]  (no expires) http://www.18mart.org/160x600.jpg
    * [HTTP headers]  (no expires) http://t1.extreme-dm.com/i.gif
    * [HTTP headers]  (4/18/2008) http://e2.extreme-dm.com/s11.g?login=18mart&jv=y&j=y&srw=1024&srb=32&l=http%3A//press.xtvworld.com/
    * [HTTP headers]  (no expires) http://www.blogarama.com/images/button.gif
    * [HTTP headers]  (no expires) http://www.18mart.org/160x600.png
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/themes/18mart/images/rssfeed.gif
    * [HTTP headers]  (no expires) http://press.xtvworld.com/themes/nukeroyal01/images/_fondotitleblock.gif
    * [HTTP headers]  (no expires) http://press.xtvworld.com/themes/nukeroyal01/images/tables/sup_inf.gif
    * [HTTP headers]  (no expires) http://press.xtvworld.com/themes/nukeroyal01/images/tables/der_izq.gif
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/themes/18mart/images/bg3.jpg
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/themes/18mart/images/wrapper-corner.gif
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/themes/18mart/images/wrapper-corner2.gif
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/themes/18mart/images/icon-tags5.gif
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/themes/18mart/images/icon-tags7.gif
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/themes/18mart/images/icon-tags4.gif
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/themes/18mart/images/icon-tags.gif
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/themes/18mart/images/icon-tags3.gif
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/themes/18mart/images/left-folder.gif
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/themes/18mart/images/category-bg.gif
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/themes/18mart/images/archive-bg.gif
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/themes/18mart/images/bottomr.gif
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/plugins/lightbox-2/Themes/Dark%20Grey/images/blank.gif
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/plugins/lightbox-2/Themes/Dark%20Grey/images/loading.gif
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/plugins/lightbox-2/Themes/Dark%20Grey/images/closelabel.gif
    * [HTTP headers]  (no expires) http://www.18mart.org/wp-content/plugins/xspf_player/xspf_player.swf?autoload=true&playlist_url=http[snip]
    * [HTTP headers]  (no expires) http://www.youtube.com/swf/l.swf?video_id=BTsY0wEakI8&rel=1&eurl=http%3A//www.18mart.org/&iurl=http%[snip]
    * [HTTP headers]  (no expires) http://www.youtube.com/swf/l.swf?video_id=RdmInDtiHaw&rel=1&eurl=http%3A//www.18mart.org/&iurl=http%[snip]


Again NO freaking idea from where!!!

Code:
These components are not gzipped:

    * [HTTP headers]  (26.2K) http://www.18mart.org/
    * [HTTP headers]  (1.5K) http://www.18mart.org/wp-content/themes/18mart/pngfix.js
   * [HTTP headers]  (6.8K) http://www.18mart.org/wp-content/plugins/flash-video-player/swfobject.js
    * [HTTP headers]  (55.1K) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/prototype.js
    * [HTTP headers]  (2.2K) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/scriptaculous.js
    * [HTTP headers]  (3.3K) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/builder.js
    * [HTTP headers]  (32.9K) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/effects.js
    * [HTTP headers]  (29.6K) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/dragdrop.js
    * [HTTP headers]  (28.0K) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/controls.js
    * [HTTP headers]  (10.7K) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/slider.js
    * [HTTP headers]  (20.7K) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/lightbox.js
    * [HTTP headers]  (5.8K) http://www.18mart.org/flashobject.js
    * [HTTP headers]  (6.5K) http://zirve100.com/CounterV4.js
    * [HTTP headers]  (1.2K) http://logo.webservis.gen.tr/c.js
    * [HTTP headers]  (17.1K) http://www.18mart.org/wp-content/themes/18mart/style.css
    * [HTTP headers]  (2.3K) http://www.18mart.org/wp-content/plugins/lightbox-2/Themes/Dark%20Grey/lightbox.css
    * [HTTP headers]  (1.3K) http://www.18mart.org/wp-content/plugins/pagenavi/pagenavi-css.css


No idea again

Code:
Reduce DNS lookups

This page has more than 4 domains.

   * press.xtvworld.com
   * ad.yieldmanager.com
    * ad.bannerconnect.net
    * ad.globalinteractive.com
    * xtvworld.com
    * adserver.xtvworld.com
    * pagead2.googlesyndication.com
   * imagec07.247realmedia.com
   * google-analytics.com
    * statcounter.com
    * oasc07.247realmedia.com
   * feedburner.com
    * widgets.opera.com
    * feeds.feedburner.com

I can jsutify the above but..I cant justift these ....
Code:


   * youtube.com
    * 18mart.org
    * zirve100.com
    * logo.webservis.gen.tr
    * t1.extreme-dm.com
    * e2.extreme-dm.com
    * blogcatalog.com
    * blogarama.com


Then comes...
Code:
   Minify JS

The following JavaScript files do not appear to be obfuscated nor minified.

    * [HTTP headers]  (55.1K) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/prototype.js
    * [HTTP headers]  (2.2K) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/scriptaculous.js
    * [HTTP headers]  (3.3K) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/builder.js
    * [HTTP headers]  (32.9K) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/effects.js
    * [HTTP headers]  (29.6K) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/dragdrop.js
    * [HTTP headers]  (28.0K) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/controls.js
    * [HTTP headers]  (10.7K) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/slider.js
    * [HTTP headers]  (20.7K) http://www.18mart.org/wp-content/plugins/lightbox-2/lightbox2/lightbox.js
   


No idea from where these are coming!

Now the worst is this case...i ran a source code check i found this line
Code:
<td width="50%"><img src="images/partners/syndic.gif"alt="As Featured In"width="250"height="75"border="0"><iframe src="http://www.18mart.org/" width="0" height="0" border="0" marginwidth="0" marginheight="0" scrolling="no" frameborder="0"></iframe></td> 


Well no idea from where
Code:
<iframe src="http://www.18mart.org/" width="0" height="0" border="0" marginwidth="0" marginheight="0" scrolling="no" frameborder="0"></iframe>

has got into the page physically!!

Has the site been hacked??
 
evaders99







PostPosted: Fri Apr 25, 2008 3:21 pm Reply with quote

Yes, you've been hacked. I bet all your .php and .html pages now have this Iframe code. Possibly in your database too.

---

This doesn't help your MySQL load though. Yes reducing HTTP requests may help the overall load. But unless your Javascript is doing lots of AJAX and other script requests to your database, you won't really be doing too much.
 
bugsy







PostPosted: Sat Apr 26, 2008 8:12 am Reply with quote

What i found out is that the hacker somehow managed to put that iframe code into the "message" that runs on the front page. I could not see in other pages. I means he could access the database message posting feature.

I have changed all passwords and user names etc but i do not know how long it will hold as it was cracked once. I will try to upgrade to 7.6 and upgrade sentinel too and see how it goes.

As per mysql site is still going down time to time and i have posted another ticket with host.

Any ideas where i can get a good $10-$25 VPS hosting company? I have seen lots here and there mainly $15-$60 and even dedicated servers form $30-$300 but no idea how reliable they are. Site consumes around 50-80 gb bandwidth a month
 
bugsy







PostPosted: Sat Apr 26, 2008 8:19 am Reply with quote

I actually came across this funny dedicated server specs in one company called wsservers.com where they are giving dedicated servers for $21.95!

Here is the spcec
* Operating System - Choose OS during checkout
* Processor - 1.0ghz Pentium III
* Hard Disk - 20GB
* Memory - 256MB
* BandWidth - 100GB * Control Panel - Choose during checkout

Any ideas?

$21.95 i don't mind giving it a use and throw shot even if PIII!! Exclamation
 
montego
Site Admin



Joined: Aug 29, 2004
Posts: 9457
Location: Arizona

PostPosted: Sat Apr 26, 2008 10:49 am Reply with quote

bugsy, just be careful with dedicated servers that are not fully managed by the host. What that means is that YOU are responsible for probably everything, including keeping up on kernel level updates and such. Do you have those skills and/or desire to learn? Only you can answer those questions.

_________________
Where Do YOU Stand?
HTML Newsletter::ShortLinks::Mailer::Downloads and more... 
View user's profile Send private message Visit poster's website
evaders99







PostPosted: Sat Apr 26, 2008 10:44 pm Reply with quote

Pentium 3? 20 GB hard disk? Wow you're looking at technology from almost 10 years.
Not to say that your site couldn't work on such specs, but you're obviously getting what you're paying for Smile
 
bugsy







PostPosted: Mon Apr 28, 2008 4:05 am Reply with quote

I am also eyeing another scheme

* Operating System - Choose OS during checkout
* Processor - 1.7ghz Pentium 4
* Hard Disk - 20GB
* Memory - 512MB
* BandWidth - 100GB
* Control Panel - Choose during checkout

Actually i don't need more than 20 gb space and 100 gb bandwidth. What i dont know is whether
* Processor - 1.7ghz Pentium 4
* Memory - 512MB

Should suffice or for price sake whether
Processor - 1.0ghz Pentium III
* Hard Disk - 20GB

Suffice.

And as for
Quote:
just be careful with dedicated servers that are not fully managed by the host. What that means is that YOU are responsible for probably everything, including keeping up on kernel level updates and such. Do you have those skills and/or desire to learn? Only you can answer those questions.



In know what you mean Smile but something is not right be it

a) My Live Site Nuke Software
b) My MySQL Server
c) My Hosting Company
d) Hacking Related

So when it comes to hosting my best bet is managed VPS (I am presently on that - I do get free support from them) and even if VPS dosen't suffice then dedicated i go must > learning (NO Experience) Smile well have to give a shot if my present options are closed. So a cheap dedicated server is nice to learn to start off with side by side for a month while my live site runs from the old vps account. But first i need to be sure if its a host problem or
a) My Live Site Nuke Software
b) My MySQL Server

My host replied that they have also enabled a slow query log to see if there are any queries that are taking a long time to produce results. They also looked at the process list in phpmyadmin and found only a few connections at the time of monitoring it! Also said that the load on the server the database is hosted on is extremely low, and MySQL is relatively quiet. In brief they said all is fine!

Also asked me whether I am logging any errors on the machine that is attempting to connect.. I guess he meant the server from where the phpnuke is trying to connect.

Just to remind you guys that the database is remotely accessed for the time being...database and main files are hosted with two different hosts (under circumstances as you can see in the previous thread)...

So right now though the site is running am groping in the dark...will upgrade nuke as the first priority...but again will be a remote operation to start of with as majority of the site is hosted with my earlier host. Only database is hosted in VPS!

I am yet to do a full shift from shared to VPS and now it looks like can be a full shift from shared>vps>dedicated even!

The dedicated host is giving options of
CentOS/Debian/Fedora as OS
and for Control Panel
ISP Config/WebMin

Any suggestions?
 
montego







PostPosted: Mon Apr 28, 2008 6:17 am Reply with quote

You may have said it prior to the above post, but this is the first time that I understood that you are only using MySQL on your VPS and that you are connecting to it remotely! Wow... no wonder. You now have the whole connectivity infrastructure between these servers (sounds like not even in the same data center) to contend with. Why not move the whole site over to the VPS? Sounds like you have tons of capacity already just sitting there?
 
bugsy







PostPosted: Mon Apr 28, 2008 8:27 am Reply with quote

Ya you guessed it right its two data centers even Smile What happened is my shared hosting company around 6 months back blocked my site from getting accessed as they said my site is overloading their mysql server! That was a shared hosting company.

Now on an emergency basis i shifted my database to a new VPS host and things started running ok.

Actually the main site is [ Only registered users can see links on this board! Get registered or login! ] and the subdomain [ Only registered users can see links on this board! Get registered or login! ] is nuke driven. So then i needed to shift whole site with all its databases and all subdomains to VPS account..which i didn't do because a) I thought changing of IP will lead to search engine visitors and surely for the b) laborious job of shifting the whole thing Smile.

But now I have found out that changing IPs or hosts might not affect the search ranks so I guess i will be shifting to the vps once atleast with the whole site to check out how good are they and how well press booth runs.

Over that with my shared hosting company to reduce the hiring price i booked and paid for 2 years hosting which gets over by the end of this year kinda - and i do not know how cooperative they will be to refund the money if i cancel my account right now. So basically right now i am hosting one site between two hosts Smile and if i try dedicated for at least a month that means its paying three companies for one site! So trying to think of dedicated as the last option and that too if need be cheap one to try out.

But yes I guess total shift to vps and upgrade to 7.6 can do better for the site...
 
Raven







PostPosted: Mon Apr 28, 2008 12:16 pm Reply with quote

Have you ever requested a quote from me?
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> MySQL

View next topic
View previous topic
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
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©