marklcfc Posted July 31, 2018 Posted July 31, 2018 My site and another forum on the same host has this issue where the first, and only the first page of new posts is slow loading (it can take upto 15-20 seconds, compared to almost instant if there is more than one page). I think is obscure error and limited to these two sites. I don't think anyone else has it but if you can test it it'd be much appreciated. This is the process which Invision managed to replicate, but have no solution.. Mark forum as read. Wait for 15-20 minutes for at least 10 new topics depending on your forum activity. Click Unread Content, it is delayed loading this page. If it isn't, read one topic, and try again. Then it will be every time you click view new posts, UNTIL there are enough new topics so that there are more pages. Then it will load quick every time (until you reach that first page again.) I've been on at my hosts for over a year but there is no solution. I first contacted Invision about this 18 months ago, and I've sent in further tickets over the past month because I've had enough of it. Invision have suggested it is mysql related, does anything look wrong? [mysqld] user=mysql symbolic-links=0 max_connections=2000 max_user_connections=2000 wait_timeout=300 interactive_timeout=300 skip-name-resolve max-connect-errors=1000000 #skip_networking = 1 #InnoDB innodb_file_per_table innodb_flush_method=O_DIRECT innodb_flush_log_at_trx_commit=0 innodb_buffer_pool_size =8G innodb_log_file_size=256M innodb_read_io_threads=4 innodb_write_io_threads=4 innodb_buffer_pool_instances=8 innodb_buffer_pool_dump_at_shutdown = 1 innodb_buffer_pool_load_at_startup = 1 transaction-isolation = READ-COMMITTED innodb_flush_neighbors=0 innodb_file_format=BARRACUDA innodb_large_prefix=1 binlog_format=MIXED innodb_autoinc_lock_mode=2 #MyISAM key_buffer_size=32M aria_pagecache_buffer_size=256M ft_min_word_len=3 #Thread Cache thread_handling = pool-of-threads #Table cache table_open_cache=8000 open_files_limit=10000 #Buffers join_buffer_size=512M read_buffer_size=128K sort_buffer_size=256K #Query Cache query_cache_type=1 query_cache_size=128M query_cache_limit=6M query_cache_strip_comments=1 #Temporary Tables tmp_table_size=256M max_heap_table_size=256M #Slow Queries #slow_query_log = 1 #slow_query_log_file=/var/log/mysql-slow.log #long_query_time=5 #log_slow_verbosity=Query_plan,explain,Innodb max_allowed_packet=268435456 This is what Invision showed me when the managing to replicate it, pointing out it was a very clean query https://dne4i5cb88590.cloudfront.net/client-area/monthly_2018_07/486472271_SQLToolbox2018-07-3115-19-53.jpg.b7f220c01cbb78df42273a5f1cbaf307.jpg I've tried the whole disabling applications, hooks etc.
Bluto Posted July 31, 2018 Posted July 31, 2018 I use Centmin Mod (centminmod.com) that has some my.cnf templates for different type servers. https://github.com/centminmod/centminmod/tree/master/config/mysql You could probably just go with one of the stock ones above and then use mysqltuner to adjust. Hope that helps.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.