I gang

Optimize drupal 7 database and site

Hi,

My Drupal 7 website is reaching its resource limits on a shared hosting account. I'm looking to optimize the site so that it runs smoothly and doesn't reach resource limits. Possibly by optimizing "database queries to make them more infrequent and efficient." The database itself needs optimization and is quite large.

I got this message recently from my host:

It appears your account is hitting the memory limits built into the server. I see a number of these processes:

/usr/bin/php /home/crimemag/public_html/[url removed, login to view]

That appear to be stuck in a loop and use more and more memory until the server finally stops them. It appears this has been happening for a while, but there might be extra traffic today that is causing the account to run out of memory, displaying the blank page. Please let us know if there's anything we can help with.

I do see some entries in the database restriction log:

[Tue Feb 11 01:16:16 2014] crimemag SLOW limit 30 current value 30 thread 29789926 query - DELETE FROM background_process

[Tue Feb 11 02:41:30 2014] crimemag SLOW limit 30 current value 30 thread 29811486 query - DELETE FROM cache_form

[Tue Feb 11 16:44:32 2014] crimemag SLOW limit 30 current value 30 thread 30052229 query - UPDATE background_process SET start_stamp='1392155042.971536', exec_status='2'

Færdigheder: Drupal, MySQL, PHP

Se mere: Query optimization, optimize mysql, i got a 7, Drupal 7, database queries, database optimization, drupal home, query loop, optimize server traffic, php mysql optimize, mysql optimizing , optimization database, mysql slow query update, slow queries, mysql query slow, optimize site use memory, mysql slow queries, query optimize, drupal page optimization, memory database, optimize php mysql, drupal server optimization, mysql query optimization, query optimize mysql, database optimizing

Om arbejdsgiveren:
( 10 bedømmelser ) Naples, United States

Projekt-ID: #5432053

Tildelt til:

angelsunny25

Yes definitly you need to optimize the database.. We had a same problem the solution was really tricky it really dono depends upon server resources(IT matters but not too much). We fixed our problem now our one server Mere

$155 USD in 5 dage
(3 bedømmelser)
3.1

9 freelancers are bidding on average $179 for this job

lukeyan

Hi we have rich experience in Drupal development, I'm interested in your project, can you show me the site? here is my [url removed, login to view] profile: [url removed, login to view] please check our previous works: htt Mere

$206 USD in 6 dage
(240 bedømmelser)
8.0
mmagr99

aMy few Drupal websites are noted below: - [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] http:/ Mere

$278 USD in 3 dage
(40 bedømmelser)
5.9
danale72

Hi Please consider me as a candidate for the task. As you mentioned the most probable reason of the issue is database malfunctioning e.g. indexes or index type misuse. Please see my working history and employee' Mere

$147 USD in 7 dage
(49 bedømmelser)
5.3
ProfSoftStudio

+++ This is my job. I'm ready to begin now. Pm for me. Thanks Looking forward to hear from you, Feel free to talk about this interesting stuff, give us any questions you have to know more about us ;-) * Europe citizen Mere

$205 USD in 5 dage
(30 bedømmelser)
5.1
ITExpertSolution

........... Give you the service beyond your expectations........... Hi I'm Expert Developer and Designer I'm Ready to Start Right Now Thank You:)

$147 USD in 3 dage
(22 bedømmelser)
4.7
Alfateck

Hi. My name is alex, and i am an experienced drupal developer. I can optimisw your site (do some modificaitions on the views, add some cacheing modules, change the performace setting). I will need to take a Mere

$147 USD in 3 dage
(13 bedømmelser)
4.7
evilcop

we already work on its [url removed, login to view] why you chose us have 5/5 rating with 100% complete rate with here have a little company too so you can depend on us . We provide you industry standard Mere

$128 USD in 7 dage
(7 bedømmelser)
3.6
fixfin

Hi We are expert in creating Portal/Blog/Social Media/e-commerce solution using Drupal. We read your requirement and we are confident to deliver you the best and standard solution. We have a client centric approach Mere

$200 USD in 20 dage
(6 bedømmelser)
3.3