Closed

Drupal Expert for Site Loading Optimization

This project must be done today 1/29

====================================

We have a site running on Drupal D6. The site experiences intermittent loading issues, here are more details:

Web Server:

Server OS: FreeBSD 5.4-RELEASE-p1

Web Server Version: Apache/[url removed, login to view] (Unix)

PHP : [url removed, login to view]

APC

Database Server:

Server OS: Linux

DB: Mysql [url removed, login to view]

Typically the load on the web server averages 2, however every now and then it spikes to 25 and when this happens the site loading decreases to 15sec, which typically is about 5sec. The database server at the same time has average load of 1, no swapping, here is the status:

Threads: 9 Questions: 506853788 Slow queries: 51430 Opens: 32926 Flush tables: 1 Open tables: 2072 Queries per second avg: 175.509

There are slow mysql queries on database server which look like and take 6-10sec to complete.

# Query_time: 6 Lock_time: 0 Rows_sent: 15 Rows_examined: 471175

SELECT [url removed, login to view] AS nid,

node_data_field_image.field_image_fid AS node_data_field_image_field_image_fid,

node_data_field_image.field_image_list AS node_data_field_image_field_image_list,

node_data_field_image.field_image_data AS node_data_field_image_field_image_data,

[url removed, login to view] AS node_type,

[url removed, login to view] AS node_vid,

node_data_field_video.field_video_fid AS node_data_field_video_field_video_fid,

node_data_field_video.field_video_list AS node_data_field_video_field_video_list,

node_data_field_video.field_video_data AS node_data_field_video_field_video_data,

[url removed, login to view] AS node_created

FROM node node

LEFT JOIN content_type_image node_data_field_image ON [url removed, login to view] = [url removed, login to view]

LEFT JOIN content_type_video node_data_field_video ON [url removed, login to view] = [url removed, login to view]

INNER JOIN node_access na ON [url removed, login to view] = [url removed, login to view] LEFT JOIN node n ON [url removed, login to view] = [url removed, login to view] WHERE (na.grant_view >= 1 AND (([url removed, login to view] = 0 AND [url removed, login to view] = 'all') OR ([url removed, login to view] = 0 AND [url removed, login to view] = 'og_public') OR ([url removed, login to view] = 2 AND [url removed, login to view] = 'forum_access'))) AND (([url removed, login to view] != 1 OR [url removed, login to view] = 147108)) AND ( ([url removed, login to view] <> 0) AND ([url removed, login to view] in ('image', 'video'))

)ORDER BY node_created DESC

LIMIT 45, 15;

What we need is somebody who has experience optimizing Drupal (Coding/Development) to fix this problem. So the loading time on the site can be stable.

Skills: Drupal, MySQL, PHP

See more: node web development, node development, expert questions, drupal expert optimization, drupal slow mysql apache php freebsd, loading drupal web site, drupal loading optimization, fix mysql slow queries drupal, what is node, node mysql, order site development, drupal web development, php drupal, NID, moderate, loading, linux os development, linux expert, freebsd, desc, database optimization, APC, coding drupal, web server optimization, unix join

About the Employer:
( 2 reviews ) Westbury, United States

Project ID: #601042

10 freelancers are bidding on average $185 for this job

anuragr

Please check PM.

$200 USD in 3 days
(19 Reviews)
5.7
pkumar125

Please see PMB

$250 USD in 15 days
(9 Reviews)
5.7
itamarjp

I can rewrite your mysql query to run more fast.

$250 USD in 0 days
(37 Reviews)
4.8
nagsept3

Hi My name is Nagaraju, I am the senior DRUPAL developer AND Project Manager. We are specialized in PHP based CMS technologies like DRUPAL, UBERCART, JOOMLA, ZENCART, OSCOMMERCE, WORDPRESS and CRE LOADED etc.. More

$200 USD in 15 days
(8 Reviews)
3.8
alanhelmick

I have installed and configured CMS software since 1986. My expertise includes Linux, MySQL and programming in C and PHP (I program fluently in 7 languages, including Perl) A position I held for years was Data T More

$250 USD in 3 days
(0 Reviews)
0.0
jaijith

lets start...details in pmb.

$50 USD in 5 days
(0 Reviews)
0.0
ONEbolivia

Hi, We are a small team of developers from Bolivia. We are focussed in CMS (Drupal, Wordpress, joomla and MODx). Our main skills are XHTML, PHP, RUBY, FLASH and FLEX. LAST PROJECTS [url removed, login to view] (I More

$150 USD in 2 days
(0 Reviews)
0.0
idreamsinfo

We are able to solve the Loading problem, but we have need to phpmyadmin access as well as code, so please provide me details asap, so we will start work on it, and make the site run smoothly. Waiting for the posit More

$100 USD in 5 days
(0 Reviews)
0.0
toronto0018

Hi please See pm Thank you

$200 USD in 3 days
(0 Reviews)
0.0
skmalviya1979

Please check our PMB.

$200 USD in 10 days
(0 Reviews)
0.0