Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 07 Jan 2017, 21:21
SilverBoy SilverBoy is offline
 
Join Date: Feb 2002
Real name: Malik
High Mysql Queries!!

Hi

I have an issue with server load as we think because of too many queries we have in every single page.

take this as an example
http://www.manshor.net/forum/content...AB%D9%8E%D9%89
it is an article, with some widgets (all of them except one are default last articles widget) but the debug mode tell me the # of queries is 190 !!

what is wrong, and who can help to fix things?

Thanks in advance.
__________________
One of highly customized vBCMS used for news site.
www.manshor.net
Reply With Quote
  #2  
Old 07 Jan 2017, 21:45
MarkFL's Avatar
MarkFL MarkFL is offline
 
Join Date: Feb 2014
Real name: Mark
My local dev site, which has a HUGE number of products running with lots of additional queries, has 48 queries on the home page.

How many queries do you get if you disable the plugin hooks?
__________________
Former vBulletin.org Staff Member



Support for my products (as well as updates/new product publishing) has been moved to MHB - vBulletin Products and TAZ - Add-ons
Reply With Quote
  #3  
Old 08 Jan 2017, 00:08
SilverBoy SilverBoy is offline
 
Join Date: Feb 2002
Real name: Malik
It really strange Mark, I disabled every plugin in my site including plugins that not related to CMS, and left only product CMS enabled, I even removed all widgets from this page, and result is 87 queries !!

So I think there is a problem in the core system it self !!

--------------- Added 08 Jan 2017 at 00:10 ---------------

Actually I disabled the hooks to from config file, and the same result!!
The strange thing is that this article don't contains attachments too !!
__________________
One of highly customized vBCMS used for news site.
www.manshor.net
Reply With Quote
  #4  
Old 08 Jan 2017, 18:33
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
The CMS uses a lot more than people are used to seeing from just the forum.

If you have widgets and/or other stuff on the page then 80+ isn't uncommon.
__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote
  #5  
Old 08 Jan 2017, 19:43
SilverBoy SilverBoy is offline
 
Join Date: Feb 2002
Real name: Malik
Thanks Paul
Actually when I talk about 80+ queries in this article, the hooks was disabled and all widget was removed from their section layout.
__________________
One of highly customized vBCMS used for news site.
www.manshor.net
Reply With Quote
  #6  
Old 09 Jan 2017, 15:04
Mattwhf Mattwhf is offline
 
Join Date: May 2016
Check your log files carefully or see server load when your site is in high load

Honestly I don't think it is high queries or high load that forums are under ddos attacks.

I have same problems and thought they are high load or having so many queries on threads/posts but I was wrong, they are ddos attacks, enable ddos attacks can help you in the case your forum is under a ddos attack.

Some guys on my forum are web hosting experts, you can contact them and they can support you if your hosting service is high load or having problems.


Hope that helps!
__________________
Web Hosting Forum - Learn web hosting and offer your hosting services for FREE!
Reply With Quote
  #7  
Old 09 Jan 2017, 18:52
SilverBoy SilverBoy is offline
 
Join Date: Feb 2002
Real name: Malik
Originally Posted by Mattwhf View Post
Check your log files carefully or see server load when your site is in high load

Honestly I don't think it is high queries or high load that forums are under ddos attacks.

I have same problems and thought they are high load or having so many queries on threads/posts but I was wrong, they are ddos attacks, enable ddos attacks can help you in the case your forum is under a ddos attack.

Some guys on my forum are web hosting experts, you can contact them and they can support you if your hosting service is high load or having problems.


Hope that helps!
Thank you Mattwhf for your reply and your help.

Actually I don't think it is ddos attack, because forum (threads) pages don't use a lot of queries, the problem only in the CMS articles.

As I mentioned before in this thread, in one of the articles I removed all widgets after disabling hooks and get 80+ queries in that page.

BTW, if you have a time, please check the CMS article page that I put in the previous reply and check the debug message if it can help.

Another thing, could you help me regarding log files, which files and what I have to look at them exactly?

Thanks.
__________________
One of highly customized vBCMS used for news site.
www.manshor.net
Reply With Quote
  #8  
Old 09 Jan 2017, 20:52
In Omnibus's Avatar
In Omnibus In Omnibus is offline
 
Join Date: Apr 2010
Real name: Kris
You have 11.65MB loading every time the page refreshes. 6MB of that is JS. For comparison, I have 2.65MB total loading on my index page. If you disable your ads, facebook, and revert to the default theme you would see far fewer queries. You don't need to go to any log files or look for any ddos issues. You just need to have someone who actually looks at your site with the proper development tools before giving you advice. The bottom line is you are running a large number of JS queries and you should decide if the modifications and add ons that run those queries are necessary for your site. If not, uninstall them.
Reply With Quote
  #9  
Old 09 Jan 2017, 22:31
SilverBoy SilverBoy is offline
 
Join Date: Feb 2002
Real name: Malik
Originally Posted by In Omnibus View Post
You have 11.65MB loading every time the page refreshes. 6MB of that is JS. For comparison, I have 2.65MB total loading on my index page. If you disable your ads, facebook, and revert to the default theme you would see far fewer queries. You don't need to go to any log files or look for any ddos issues. You just need to have someone who actually looks at your site with the proper development tools before giving you advice. The bottom line is you are running a large number of JS queries and you should decide if the modifications and add ons that run those queries are necessary for your site. If not, uninstall them.
Thank you Omnibus for your reply.

Are you talking about the homepage or this page?
http://www.manshor.net/forum/content...AB%D9%8E%D9%89

Btw, could you help in fix my issue?
__________________
One of highly customized vBCMS used for news site.
www.manshor.net
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 10:58.

Layout Options | Width: Wide Color: