Promoshake
El Presidente
Just Getting Started
Member Likes (0)
hello i'm having issue in my hosting about the database consuming and my website have been blocked twice. i have removed some plugin and ask for another check for the hosting and that is the reply.
Unfortunately, when I removed the restriction, a lot of processes were spawned (see below).
Running Proceses:
---Pass 1---
aaelch 9051 22.0 0.4 299356 37480 ? RN 04:12 0:00 | \_ /usr/bin/php /home/aaelch/public_html/index.php
aaelch 9051 42.0 0.7 323040 61540 ? RN 04:12 0:00 | \_ /usr/bin/php /home/aaelch/public_html/index.php
aaelch 9051 64.0 1.1 360460 97920 ? RN 04:12 0:00 | \_ /usr/bin/php /home/aaelch/public_html/index.php
---Pass 2---
aaelch 9127 20.0 0.4 296460 34692 ? RN 04:12 0:00 | \_ /usr/bin/php /home/aaelch/public_html/index.php
aaelch 9118 20.5 0.7 322768 61128 ? RN 04:12 0:00 | \_ /usr/bin/php /home/aaelch/public_html/index.php
aaelch 9127 31.0 0.5 310124 48444 ? RN 04:12 0:00 | \_ /usr/bin/php /home/aaelch/public_html/index.php
aaelch 9118 26.0 0.9 337164 75080 ? RN 04:12 0:00 | \_ /usr/bin/php /home/aaelch/public_html/index.php
aaelch 9127 41.0 0.7 322212 60608 ? RN 04:12 0:00 | \_ /usr/bin/php /home/aaelch/public_html/index.php
aaelch 9118 31.0 1.1 355340 93220 ? RN 04:12 0:00 | \_ /usr/bin/php /home/aaelch/public_html/index.php
aaelch 9127 51.0 0.9 336396 74548 ? RN 04:12 0:00 | \_ /usr/bin/php /home/aaelch/public_html/index.php
aaelch 9118 35.5 1.3 368908 106684 ? RN 04:12 0:00 | \_ /usr/bin/php /home/aaelch/public_html/index.php
---Pass 3---
aaelch 9127 42.0 1.9 426508 163616 ? RN 04:12 0:01 | \_ /usr/bin/php /home/aaelch/public_html/index.php
aaelch 9118 36.7 1.9 426508 163880 ? RN 04:12 0:01 | \_ /usr/bin/php /home/aaelch/public_html/index.php
aaelch 9127 33.5 1.9 426508 163876 ? RN 04:12 0:01 | \_ /usr/bin/php /home/aaelch/public_html/index.php
aaelch 9118 31.0 1.9 426508 163880 ? RN 04:12 0:01 | \_ /usr/bin/php /home/aaelch/public_html/index.php
aaelch 9127 34.7 1.9 426508 163876 ? SN 04:12 0:01 | \_ /usr/bin/php /home/aaelch/public_html/index.php
aaelch 9118 32.0 1.9 420108 157724 ? RN 04:12 0:01 | \_ /usr/bin/php /home/aaelch/public_html/index.php
aaelch 9127 37.0 1.9 426508 163876 ? RN 04:12 0:01 | \_ /usr/bin/php /home/aaelch/public_html/index.php
aaelch 9118 33.0 1.8 417284 155284 ? RN 04:12 0:01 | \_ /usr/bin/php /home/aaelch/public_html/index.php
---Pass 4---
MySQL Processes:
Incoming Connections:
74.202.255.243 aaelch.org /downloads/2012/02/gadiel_dell_arricia.jpg
74.202.255.243 aaelch.org /photos/
93.66.0.27 aaelch.org /wp-content/plugins/bp-album/includes/css/general.css?ver=3
93.66.0.27 aaelch.org /wp-content/plugins/buddypress-easy-albums-photos-video-and
93.66.0.27 aaelch.org /wp-content/plugins/contact-form-7/jquery.form.js?ver=3.08
93.66.0.27 aaelch.org /wp-content/plugins/contact-form-7/scripts.js?ver=3.1.2
93.66.0.27 aaelch.org /wp-content/themes/bp-corporate/_inc/global.js?ver=20120110
93.66.0.27 aaelch.org /wp-content/themes/bp-corporate/_inc/images/social-single.p
can you please help to understand what it's means ?
i also have the recomandation to test the site with http://gtmetrix.com
i have these suggestions for example:
The following cacheable resources have a short freshness lifetime. Specify an expiration at least one week in the future for the following resources:
http://daddyconcept.com/chateau/wp-content/uploads/2010/06/copainsdavant.gif (expiration not specified)
http://daddyconcept.com/chateau/wp-content/uploads/2010/06/france-roma-300x45.jpg (expiration not specified)
http://daddyconcept.com/chateau/wp-content/uploads/2010/06/mail_plain.png (expiration not specified)
http://daddyconcept.com/chateau/wp-content/uploads/2010/06/social_facebook.png (expiration not specified)
http://daddyconcept.com/chateau/wp-content/uploads/2010/06/social_skype.png (expiration not specified)
http://daddyconcept.com/chateau/wp-content/uploads/2010/06/trombi.gif (expiration not specified)
http://www.aaelch.org/wp-content/plugins/buddypress/bp-core/images/mystery-man.jpg (expiration not specified)
http://www.aaelch.org/wp-content/themes/bp-corporate/_inc/images/admin-menu-arrow.gif (expiration not specified)
http://www.aaelch.org/wp-content/themes/bp-corporate/_inc/images/nav-arrow.png (expiration not specified)
http://www.aaelch.org/wp-content/themes/bp-corporate/_inc/images/spacer.gif (expiration not specified)
http://www.aaelch.org/wp-content/themes/bp-corporate/_inc/images/submit-term.jpg (expiration not specified)
http://www.aaelch.org/wp-content/themes/bp-corporate/_inc/preset-styles/corporate-orange.css (expiration not specified)
http://www.aaelch.org/wp-content/themes/bp-corporate/_inc/preset-styles/corporate-orange/side.png (expiration not specified)
http://www.aaelch.org/wp-content/themes/bp-corporate/style.css (expiration not specified)
http://www.aaelch.org/wp-content/uploads/2012/01/cropped-header1.jpg (expiration not specified)
how can i correct these "errors"?

Responses (19)
Member (joined April 2010) Likes (0)
i solved parted of the issue with W3 plugin , but what can i do for the spwaned proccess?
Thank you for the support.
Inactive (joined February 2012) Likes (0)
Hello Promoshake,
Let me forward this to our development team and see what they have to offer. Hang on :)
Member (joined April 2010) Likes (0)
thanx a lot. Waiting for their suggestion...
Developer (joined February 2012) Likes (1)Liked by: 
Hi Promoshake,
Normally using W3T should be sufficient, but I checked your website and saw that first byte time is too long. Is W3T active for your homepage at the moment?
For the second part of your question:
1. Take a backup of your htaccess file.
2. Add the following inside htaccess:
If you encounter a server error after this change, revert back to your backup file and we discuss again.
Cheers,
Hakan
Member (joined April 2010) Likes (0)
1) W3T is active now (please watch the screen shot for the setting)
Developer (joined February 2012) Likes (0)
Hi,
We are talking about this url: http://www.aaelch.org Is that right?
Try to change "Page Cache Method:" as Disc:Basic
Are you really using a CDN here? I don't know the meaning of Generic Mirror, and I assume you checked CDN enable option knowingly.
Please write again when you are done.
Cheers,
Hakan
Developer (joined February 2012) Likes (0)
Also please check if "Cache home page" checkbox is checked on "Page cache" page.
Cheers
Hakan
Member (joined April 2010) Likes (0)
yes it's checked and i have add in the htaccess the code you gave me.
Member (joined April 2010) Likes (0)
1) yes the site is aaelch.org
2)i'm not using the cnd because i don't know excactly how to configure it.
3) made the change to basic.
Thanx.
Developer (joined February 2012) Likes (0)
Hi Promoshake,
It is ok now :) Your website is optimised.
Please also uncheck CDN enable as you are not using it.
Please also note that this is almost the best you can do given the constant resources (shared hosting I assume). If your hosting still complains about database usage, it can only be because of high traffic. Then you will be having two options 1) Change your hosting company 2) Upgrade to a higher account of theirs.
Cheers,
Hakan
Member (joined April 2010) Likes (0)
ok thank you for your support ,
another question what about the spwaned proccess? was they related to the set up?
i mean these like this:
aaelch 9118 35.5 1.3 368908 106684 ? RN 04:12 0:00 | \_ /usr/bin/php /home/aaelch/public_html/index.php
can you explain me please what they are ( is possible and it does not take to much of your time...)
Thanx again
Developer (joined February 2012) Likes (0)
That shows a list of running processes. Hosting companies send such lists to prove that there is an issue with your website, and responsibility is not theirs. But they have no practical meaning for us. Because they do not show where the issue is. Which plugin? Which file? How much resource? These questions stay unanswered.
We just look at the final result: If page is loading fast, it must be using less resources. Simple and exact.
Cheers,
Hakan
Member (joined April 2010) Likes (0)
oooops...
i was checking the website and all the links are not working anymore.... :(
Not Found
The requested URL /qui-sommes-nous/ was not found on this server.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Member (joined April 2010) Likes (0)
when i remove the code you gave me in the htaccess the links are available.
Developer (joined February 2012) Likes (0)
Thats why I told you backup your htaccess file at first place :)
Ask your hosting if they support "ExpiresActive" in htaccess. If they don't, then just forget about it.
Cheers,
Hakan
Member (joined April 2010) Likes (0)
thanx for your support , now i'm just waiting the hosting response.
Support Kangaroo (joined March 2011) Likes (0)
Greetings Promoshake,
Any response from your hosting team yet?
Please advise.
Cheers, Joe
Member (joined April 2010) Likes (0)
the performance seems to be ok now!
Thank you a lot.
problem solved.
Inactive (joined February 2012) Likes (0)
@Promoshake - Glad to hear that :)
Become a member