vb.org Archive - Slow Search - mySQL optimized but still the same

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-16-2006 07:30 PM

Slow Search - mySQL optimized but still the same

1 Attachment(s)

I have a problem with some kind of commands with vBulletin. For example when you run a search the result page shows up after about 10 seconds (in this case the server load is almost at 0) and the creation time is something like "0.30~0.50seconds".

Another slow respond case is if you post a new thread, but not if you add a reply(!) or when you click on a link to the newes post of a thread "showthread.php?goto=newpost&t=5383" for example. This action takes about seconds again. But If you go to the same thread without this option it shows up instantly.

How can you explain this?

Zachery

10-16-2006 07:36 PM

Are you using similiar threads functions? I'd disable them.

jyajay

10-16-2006 07:43 PM

No, this has no effect on my forum at all. I tested it with this function turned on and off.

Zachery

10-17-2006 12:12 AM

Did you disable them showing or disable them 100%? there are 3 settings that control them.

jyajay

10-17-2006 09:39 AM

Originally I had this function turned off, after turning it on there was no extra slow-down. I assure you this has nothing to do with my problem.

Zachery

10-17-2006 09:40 AM

I assure you, you should try ;)

jyajay

10-17-2006 09:46 AM

I did, thats why I told you it really has nothing to do with it.

JoeWho

10-17-2006 11:03 AM

Quote:

Originally Posted by Zachery

Did you disable them showing or disable them 100%? there are 3 settings that control them.

What are the 3 settings that control them?

Thanks.

jyajay

10-17-2006 11:10 AM

AdminCP -> Messag Searching Options -> Automatic Similar Thread Search
AdminCP -> Thread Display Options (showthread) -> Show Similar Threads?

I just found two settings that have a direct control over that. Anyway I enabled these after i noticed my problem, still no change at site creation tme.

Ntfu2

10-17-2006 03:43 PM

backup your old my.cnf and replace it with this one.

Code:



[mysqld]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

skip-locking

skip-innodb

query_cache_limit=8M

query_cache_size=256M

query_cache_type=1

max_connections=500

max_user_connections= 300

interactive_timeout=20

wait_timeout=20

connect_timeout=6

thread_cache_size=128

key_buffer=16M

join_buffer=1M

max_allowed_packet=16M

table_cache=1024

record_buffer=1M

sort_buffer_size=2M

read_buffer_size=2M

max_connect_errors=10

# Try number of CPU's*2 for thread_concurrency

thread_concurrency=4

myisam_sort_buffer_size=64M

#log-bin

server-id=1



[mysql.server]

user=mysql

basedir=/var/lib



[safe_mysqld]

err-log=/var/log/mysqld.log

pid-file=/var/lib/mysql/mysql.pid

open_files_limit=8192



[mysqldump]

quick

max_allowed_packet=16M



[mysql]

no-auto-rehash

#safe-updates



[isamchk]

key_buffer=32M

sort_buffer=32M

read_buffer=16M

write_buffer=16M



[myisamchk]

key_buffer=32M

sort_buffer=32M

read_buffer=16M

write_buffer=16M

Then restart MySQL. Also what version of MySQL and PHP are you running.

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 03:28 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01016 seconds Memory Usage 1,744KB 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)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (17)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 bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: