Optimize drupal 7 database and site


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'

Evner: 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

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

Projekt ID: #5432053

Tildelt til:


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 Flere

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

9 freelancere byder i gennemsnit $179 på dette job


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

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

aMy few Drupal websites are noted below: - [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] [login to view URL] http:/ Flere

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

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' Flere

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

+++ 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 Flere

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

........... 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)

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 Flere

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

we already work on its https://www.freelancer.com/u/evilcop.html 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 Flere

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

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 Flere

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