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* ).
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).
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/ ]
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.com mailto:joel.willers@sigler.com> wrote:
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> [mailto: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 <mailto: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/ ]
I am just a beginning drupalite but I found updating all my modules to the latest releases got rid of a lot of very similar error lists. I could be totally off base here. Fwiw. Tony. Sent on the Sprint® Now Network from my BlackBerry®
-----Original Message----- From: robert mena robert.mena@gmail.com Sender: support-bounces@drupal.org Date: Mon, 25 Jul 2011 19:43:25 To: support@drupal.org Reply-To: support@drupal.org Subject: Re: [support] Optimizing Drupal6 + finding bottlenecks
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
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 '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/ ]
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.
Hi,
Thanks. I've read the PDF here is some extra info so if anyone has suffered from this can give his/her opinion:
a) I am already using APC b) I am using drupal6 so switch to 7 is not an option right now c) I am seeing the strange performance for a non live site (still under development) So a reverse-proxy probably won't help
My question is how do I identify where it is taking so long?
On Mon, Jul 25, 2011 at 1:52 PM, Marilyn Langfeld langfeldesigns@gmail.comwrote:
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.
-- [ Drupal support list | http://lists.drupal.org/ ]
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 BoostIt 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.
'Carefully' re-reading ur original post now I know I am way off base. Apologies.
Tony Sent on the Sprint® Now Network from my BlackBerry®
-----Original Message----- From: Anthony Malkoun malkouna@yahoo.com.au Sender: support-bounces@drupal.org Date: Tue, 26 Jul 2011 11:06:58 To: support@drupal.org Reply-To: support@drupal.org Subject: Re: [support] Optimizing Drupal6 + finding bottlenecks
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 BoostIt 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 '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/ ]