vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   General Hosting/Server Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=197)
-   -   Slow Search - mySQL optimized but still the same (https://vborg.vbsupport.ru/showthread.php?t=129252)

jyajay 10-17-2006 04:18 PM

All info is attached at my first post. PHP 5.1.6 & mySQL 5.0.24 Community Edition.

I'll try out your suggestion.


The 1:1 replacement of with your config caused mySQL not to start anymore so I replaced just some major commands with my existing one. Still there is no speed up at all. I'd say you did just copy for configuration so it is not any helpful in my case.

Thanks for the efforts anyway. ;)

Ntfu2 10-17-2006 07:02 PM

Remove your similar threads :lol: sorry couldnt resist.

I had serious load issues with php5.1.5 and MySQL 5.x and downgrading to php 4.4 and MySQL 4.x seemed to fix tons of my problems, if thats a viable option for you, you may wish to consider it

jyajay 10-17-2006 07:05 PM

I just did the exact reverse of yours and it gave me a significant speedup compared to how it was before. I don't think that is an option.

jyajay 11-01-2006 08:50 PM

Not even you experts can give me tip? This was from the very first day since I installed vBulletin and was the only one surfing on the board so I must be the server configuration. You can also write me a pm.

I'd really appreciate some help.

Ntfu2 11-01-2006 09:15 PM

Maybe MySQL or Php hasnt been compiled correctly.

Thats the last thing i can think of

jyajay 11-01-2006 09:18 PM

It was compiled by my webhoster several times so it should be ok.

jyajay 11-03-2006 04:35 PM

1 Attachment(s)
I turned debug mode on and triggerd 'new posts' with an actual server load of ~1.2, the page loaded 16 seconds later but the generation time is 0,5 seconds with only 13 queries is why I am so confused. There is really not much traffic right now on my board and no other apps are running.

I attached the debug output.


All times are GMT. The time now is 12:54 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01088 seconds
  • Memory Usage 1,724KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete