Slow Search - mySQL optimized but still the same

[jyajay]

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]

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

[jyajay]

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

[Zachery]

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

[jyajay]

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]

I assure you, you should try ;)

[jyajay]

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

[JoeWho]

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]

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]

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



[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]

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]

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]

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]

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]

Maybe MySQL or Php hasnt been compiled correctly.

Thats the last thing i can think of

[jyajay]

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

[jyajay]

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.