Hi Thanks for your input.

It is always good to receive feedback. In my case I have the server so it is not a hosting issue in terms that I need to conform (or leave it).

So the more specific question would be starting points to try to narrow this slowdown origin.

On Mon, Jul 25, 2011 at 9:15 AM, Joel Willers joel.willers@sigler.comwrote:

There are many things that can be done to optimize sites, including Drupal sites. Incorrectly configured modules, poor programming, poor module interaction, slow MYSQL server (or unoptimized).

I used Godaddy as my host for a while, but they had horribly slow Drupal sites (other sites were fine). When I switched to BlueHost, all my performance issues vanished. I hope that helps some.

Joel

From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of robert mena Sent: Sunday, July 24, 2011 7:49 PM To: support@drupal.org Subject: [support] Optimizing Drupal6 + finding bottlenecks

Hi,

I have a drupal6 website that is behaving strangely with some occasional slowdowns.

Any tips while trying to identify why it is like that?

I am ruling out hardware problems or even access since other sites (not drupal based) are hosted and does not behave like that.

Under admin/reports/dblog I see lots of messages such as

Warning: Invalid argument supplied for foreach() in webform_phone_form_alter() (line 38 of//public_html/drupal/sites/all/modules/webform_phone/webform_phone.module).

or

User warning: Duplicate entry 'admin/content/node-type/news/fields/field_embed_others_video' for key 1 query: INSERT INTO menu_router (path, load_functions, to_arg_functions, access_callback, access_arguments, page_callback, page_arguments, fit, number_parts, tab_parent, tab_root, title, title_callback, title_arguments, type, block_callback, description, position, weight, file) VALUES ('admin/content/node-type/news/fields/field_embed_others_videos', '', '', 'user_access', 'a:1:{i:0;s:24:"administer content types";}', 'drupal_get_form', 'a:3:{i:0;s:23:"content_field_edit_form";i:1;s:8:"news";i:2;s:25:"field_embed_others_videos";}', 63, 6, 'admin/content/node-type/news/fields', 'admin/content/node-type/news', 'Embed video', 't', '', 128, '', '', '', 0, 'sites/all/modules/cck/includes/content.admin.inc') in _db_query() (line 136 of/public_html/drupal/includes/database.mysql.inc). -- [ Drupal support list | http://lists.drupal.org/ ]

Hi,

I have to check to see if this switch is possible.

My question is I don't see why I get so many errors, specially those DUPLICATE ones. This should be a starting point but again I do not see what is trying to insert and how to solve it.

On Mon, Jul 25, 2011 at 9:47 AM, Don donald@fane.com wrote:

A quick boost for drupal 6 if you're seeing php errors is replace your core with pressflow. That handles watchdogs messages differently and I've seen a large difference. Of course, in the long run you want to fix the errors but this will help in the meantime. -Don-

On 7/25/2011 9:34 AM, robert mena wrote:

Hi Thanks for your input.

It is always good to receive feedback. In my case I have the server so it is not a hosting issue in terms that I need to conform (or leave it).

So the more specific question would be starting points to try to narrow this slowdown origin.

On Mon, Jul 25, 2011 at 9:15 AM, Joel Willers joel.willers@sigler.comwrote:

...

There are many things that can be done to optimize sites, including Drupal sites. Incorrectly configured modules, poor programming, poor module interaction, slow MYSQL server (or unoptimized).

I used Godaddy as my host for a while, but they had horribly slow Drupal sites (other sites were fine). When I switched to BlueHost, all my performance issues vanished. I hope that helps some.

Joel

From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of robert mena Sent: Sunday, July 24, 2011 7:49 PM To: support@drupal.org Subject: [support] Optimizing Drupal6 + finding bottlenecks

Hi,

I have a drupal6 website that is behaving strangely with some occasional slowdowns.

Any tips while trying to identify why it is like that?

I am ruling out hardware problems or even access since other sites (not drupal based) are hosted and does not behave like that.

Under admin/reports/dblog I see lots of messages such as

Warning: Invalid argument supplied for foreach() in webform_phone_form_alter() (line 38 of//public_html/drupal/sites/all/modules/webform_phone/webform_phone.module).

or

User warning: Duplicate entry 'admin/content/node-type/news/fields/field_embed_others_video' for key 1 query: INSERT INTO menu_router (path, load_functions, to_arg_functions, access_callback, access_arguments, page_callback, page_arguments, fit, number_parts, tab_parent, tab_root, title, title_callback, title_arguments, type, block_callback, description, position, weight, file) VALUES ('admin/content/node-type/news/fields/field_embed_others_videos', '', '', 'user_access', 'a:1:{i:0;s:24:"administer content types";}', 'drupal_get_form', 'a:3:{i:0;s:23:"content_field_edit_form";i:1;s:8:"news";i:2;s:25:"field_embed_others_videos";}', 63, 6, 'admin/content/node-type/news/fields', 'admin/content/node-type/news', 'Embed video', 't', '', 128, '', '', '', 0, 'sites/all/modules/cck/includes/content.admin.inc') in _db_query() (line 136 of/public_html/drupal/includes/database.mysql.inc). -- [ Drupal support list | http://lists.drupal.org/ ]

-- [ Drupal support list | http://lists.drupal.org/ ]

Read the messages again; it tells you exactly what it is trying to insert and where. My question is why the Embed Video module is mucking with the menu system; that's either something you messed up in the settings somewhere, or a serious bug in that module. Either way, open an issue.   For performance, I always start with the Devel query log. There is always at least one module that is doing far more queries than it needs to. Open an issue to get it (or them) fixed.   Make sure anonymous caching and CSS compression are turned on. Check for the Statistics module - do you really need it? And evaluate the need for the access log. While you are playing with Devel, turn on the error reporting; you will find other errors that don't normally get reported, but are slowing you down anyway - report them.   Check that query caching is turned on and set at a realistic size - go to your status report and click on the MySql release number for stats on the database.

Nancy   Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.

From: robert mena

My question is I don't see why I get so many errors, specially those DUPLICATE ones.   This should be a starting point but again I do not see what is trying to insert and how to solve it.User warning: Duplicate entry 'admin/content/node-type/news/fields/field_embed_others_video' for key 1 query: INSERT INTO menu_router (path, load_functions, to_arg_functions, access_callback, access_arguments, page_callback, page_arguments, fit, number_parts, tab_parent, tab_root, title, title_callback, title_arguments, type, block_callback, description, position, weight, file) VALUES ('admin/content/node-type/news/fields/field_embed_others_videos', '', '', 'user_access', 'a:1:{i:0;s:24:"administer content types";}', 'drupal_get_form', 'a:3:{i:0;s:23:"content_field_edit_form";i:1;s:8:"news";i:2;s:25:"field_embed_others_videos";}', 63, 6,

'admin/content/node-type/news/fields', 'admin/content/node-type/news', 'Embed video', 't', '', 128, '', '', '', 0, 'sites/all/modules/cck/includes/content.admin.inc') in _db_query() (line 136 of/public_html/drupal/includes/database.mysql.inc

I just attended CapitalCamp in DC, and one of the sessions was High Performance Drupal: Step by Step. http://www.capitalcamp.org/sessions/high-performance-drupal-step-step

The slides from the session are available on the page referenced above. The presenter, Fabian Franz from Trellon, made one point early on:

*"If you build the house on one pillar, it'll not **hold long ..."*

Then went on to say the four pillars of high performance for Drupal sites are:

- Pressflow / Drupal 7 - APC - MemCache - Varnish and Boost

It may not possible to use Pressflow (with an installation profile). In that case he suggested to use the other three.

The slides have a little more detail though the presentation included much more, and he showed how quickly all four could be added using command line His style is a somewhat unusual (you'll see if you check out the pdf), and the information seemed good. See what you think.

On Mon, Jul 25, 2011 at 10:08 AM, Liviu Nicolicioiu < liviu.nicolicioiu@epoint.ro> wrote:

Check your cron usage, the execution time.

Just some semi random thoughts...

If trying to find a sporadic bottleneck and using MySQL I find the slow query log to be invaluable. For general slowness a quick problem determination can be performed by installing the devel module and turning on performance tracking. Long term performance monitoring probably needs something like Cacti installed. If most of your traffic is to anonymous users think about using Drupal's inbuilt cache. I've had some success with non anonymous use by setting up mod_deflate to compress everything.

On 6:59 AM, Marilyn Langfeld wrote:

I just attended CapitalCamp in DC, and one of the sessions was High Performance Drupal: Step by Step. http://www.capitalcamp.org/sessions/high-performance-drupal-step-step

The slides from the session are available on the page referenced above. The presenter, Fabian Franz from Trellon, made one point early on:

/"If you build the house on one pillar, it'll not //hold long ..."/

Then went on to say the four pillars of high performance for Drupal sites are:

* Pressflow / Drupal 7
* APC
* MemCache
* Varnish and Boost

It may not possible to use Pressflow (with an installation profile). In that case he suggested to use the other three.

The slides have a little more detail though the presentation included much more, and he showed how quickly all four could be added using command line His style is a somewhat unusual (you'll see if you check out the pdf), and the information seemed good. See what you think.

On Mon, Jul 25, 2011 at 10:08 AM, Liviu Nicolicioiu <liviu.nicolicioiu@epoint.ro mailto:liviu.nicolicioiu@epoint.ro> wrote:

Check your cron usage, the execution time.

Hi,

What (and where) should I check? THe system cron does not contain anything related to this site.

On Mon, Jul 25, 2011 at 10:08 AM, Liviu Nicolicioiu < liviu.nicolicioiu@epoint.ro> wrote:

Check your cron usage, the execution time.

On Mon, Jul 25, 2011 at 3:48 AM, robert mena robert.mena@gmail.com wrote:

...

Hi, I have a drupal6 website that is behaving strangely with some occasional slowdowns. Any tips while trying to identify why it is like that? I am ruling out hardware problems or even access since other sites (not drupal based) are hosted and does not behave like that. Under admin/reports/dblog I see lots of messages such as Warning: Invalid argument supplied for

foreach() in webform_phone_form_alter() (line 38 of//public_html/drupal/sites/all/modules/webform_phone/webform_phone.module).

...

or User warning: Duplicate entry &#039;admin/content/node-type/news/fields/field_embed_others_video&#039;

for

...

key 1 query: INSERT INTO menu_router (path, load_functions, to_arg_functions, access_callback, access_arguments, page_callback, page_arguments, fit, number_parts, tab_parent, tab_root, title, title_callback, title_arguments, type, block_callback, description, position, weight, file) VALUES

(&#039;admin/content/node-type/news/fields/field_embed_others_videos&#039;,

...

&#039;&#039;, &#039;&#039;, &#039;user_access&#039;, &#039;a:1:{i:0;s:24:&quot;administer content types&quot;;}&#039;, &#039;drupal_get_form&#039;,

&#039;a:3:{i:0;s:23:&quot;content_field_edit_form&quot;;i:1;s:8:&quot;news&quot;;i:2;s:25:&quot;field_embed_others_videos&quot;;}&#039;,

...

63, 6, &#039;admin/content/node-type/news/fields&#039;, &#039;admin/content/node-type/news&#039;, &#039;Embed video&#039;, &#039;t&#039;, &#039;&#039;, 128, &#039;&#039;, &#039;&#039;,

&#039;&#039;,

...

0,

&#039;sites/all/modules/cck/includes/content.admin.inc&#039;) in _db_query() (line 136 of/public_html/drupal/includes/database.mysql.inc).

...

-- [ Drupal support list | http://lists.drupal.org/ ]

-- [ Drupal support list | http://lists.drupal.org/ ]