very slow when replying to a topic

[BliNeR-KeY]

Hello everyone. I'm new in the forum and greetings to everyone.
idont known is here to solve my problem or on vbulletin.com

im using vb.4.2.2 version .

but have some serios problem.

the forum is very slow when replying to a topic.
I do not understand why.
many times the delay is very much coming out double post.

im using a verygood VPS with webmin

please check picture servers to runing my vb.

[Dave]

Check your plugins, big chance a plugin is causing this.

[BliNeR-KeY]

Check your plugins, big chance a plugin is causing this.

i disabled all plugins... but same.. the problem is same

[Dave]

So creating a thread works fine, but replying to a thread is slow?

[Lynne]

Have you tried using a default style to see if this still happens? Have you checked your error_logs (if you don't know where they are, ask your host)? Have you added the following line to your config.php file under the <?php line?:


define('SKIP_DS_ERRORS', true);

[BliNeR-KeY]

So creating a thread works fine, but replying to a thread is slow?

on creating or all is all ok..

problem is just on answer just on answer ...

maybe my config on apache or msql server is bad?

[Dave]

Maybe you should repair and optimize your tables in the admin control panel > maintenance > Repair / Optimize Tables. Might take a while if you have a big database.

[BliNeR-KeY]

admin pls check my config.php

i edit my data

[BliNeR-KeY]

Maybe you should repair and optimize your tables in the admin control panel > maintenance > Repair / Optimize Tables. Might take a while if you have a big database.

yes lots time i try to Optimize Tables but same is same.

my SQL db. is a 266MB without files atach..

[Lynne]

admin pls check my config.php

i edit my data
You didn't add the line I told you to add in post 5, nor do you have your plugins disabled.

[BliNeR-KeY]

i added on php file but same..

maybe i forget to say.. on testing code
define('SKIP_DS_ERRORS', true);

tested i open a new post in private admin section
and maked 38 post. and is all ok.


i replay in one old post public post #34

is low..

--------------- Added 1412448668 at 1412448668 ---------------

is not so faster like here... my good i dont undestand why

[Lynne]

Perhaps you should post in the Server Configuration forum on vbulletin.com for help optimizing your server.

[Zachery]

Do you have the similar thread search turned on?

[BliNeR-KeY]

Do you have the similar thread search turned on?

yes i have it. if i disable or enable is same on replay post.

you think i need to remove the files from server?

--------------- Added 1412498188 at 1412498188 ---------------

i have 125 files on server ( File not recognized as part of vBulletin )

is a old... i dont removed from server. just i remove from plugins on vb.

--------------- Added 1412500792 at 1412500792 ---------------

new test...

i used just USED files vbulletinsuite_4-2-2_Patch_Level_1_VBF2XXXXXX
/upload

Disable all Plugin/Hook.
disable site offline


###############

site is little faster.



defult skin all tests.. files missing other skins.

my.site.com/online.php = slow / 6 utenti e 38 ospiti
replay topic = little more faster.
similar thread is on = Plugin/Hook off

i think the problem is on database.

[Lynne]

You think it's the database? How large is your database? Do you have a lot of attachments and are they served from the database or the filesystem?

[BliNeR-KeY]

no i think is not a lots the attachments...

attachments = 1,649 / 1,586 totaly
Size File Attachments ALL = 1.03 GB
database.sql (no Attachments) = 269 MB from backup daily
database = 350 MB from phpmyadmin

i dont use the attachments in db forum.

searchcore_text core is a very big... if empty have some problem?

[Zachery]

Make sure to disable similar thread searching and displaying.

[BliNeR-KeY]

Pls help how to disable similar thread ..

i disabled all plugins on Plugin/Hook System.
i removed Check similar thread before posting a new one from plugins&products.


Similar Threads disabled from ACP
https://www.vbulletin.com/docs/html/main/vboptions_group_showthread

but same replay is low

######################

searchcore_text core is a very big... if empty have some problem?

[Lynne]

If you empty the searchcore_text table, then you can't search.

Zachery is saying to set AdminCP > Settings > Options > Message Searching > Automatic Similar Thread Search to No.

[BliNeR-KeY]

If you empty the searchcore_text table, then you can't search.

Zachery is saying to set AdminCP > Settings > Options > Message Searching > Automatic Similar Thread Search to No.

add no on message searching


Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, [no address given] and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

[ozzy47]

What is the error from your server error logs? If you don't know where those are, ask your host.

[BliNeR-KeY]

What is the error from your server error logs? If you don't know where those are, ask your host.

i have a root access..

fix problem internal error = FCGId (run as virtual server owner)

solution working is = CGI wrapper (run as virtual server owner)

in apache2..

______________

but same problem is slow on answer on replay topic

[Lynne]

You didn't answer the question about what is in your error_logs?

[Dave]

Do you have a slow query log? Refer to https://rtcamp.com/tutorials/mysql/slow-query-log/ for more information on how to configure it. Then just look for the /var/log/mysql/mysql-slow.log file.

[BliNeR-KeY]

Do you have a slow query log? Refer to https://rtcamp.com/tutorials/mysql/slow-query-log/ for more information on how to configure it. Then just look for the /var/log/mysql/mysql-slow.log file.

ADD Oo my cfg.

dhis is my.cnf




















[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock





[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0

[mysqld]



user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking



bind-address = 127.0.0.1



key_buffer = 384M
max_allowed_packet = 2G
thread_cache_size = 8


myisam-recover = BACKUP






query_cache_limit = 1M
query_cache_size = 32M





















expire_logs_days = 10
max_binlog_size = 100M
innodb_file_per_table = 1
thread_concurrency = 8
myisam_sort_buffer_size = 64M
read_rnd_buffer_size = 8M
read_buffer_size = 2M
sort_buffer_size = 2M
table_cache = 512
big-tables





slow-query-log = 1
slow-query-log-file = /var/log/mysql/mysql-slow.log
long_query_time = 1
log-queries-not-using-indexes















[mysqldump]
quick
quote-names
max_allowed_packet = 1073741824

[mysql]


[isamchk]
key_buffer = 256M
write_buffer = 2M
read_buffer = 2M
sort_buffer_size = 256M





!includedir /etc/mysql/conf.d/




dhis is my log 5-10 min. pls download

pls check my.cnf is set good or problem with my.cnf

[Lynne]

I thought you disabled your plugins? There are several lines in there regarding the chatbox, autoreply and thanks mod. I don't think those are your problem, but you did say you disabled your plugins and so those shouldn't be in there.

You said you have a VPN so you have access to modify php and mysql settings? If so, then you should post over in the Server Configuration forum at vb.com and see if George can help optimize your server.

[magenik]

I had the same issue long ago
and the issue was due GlowHost - Spam-O-Matic and since i reenabled it the issue appear again
even if i did install the script with last update
and my server has i7 + 48 giga ram so it's can't be server side :)
hope this might help