Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted November 30, 20222 yr Hi Guys, I just moved to a new server that's has much faster hardware, but is geographically much further from me. I noticed that when I click on the Notifications icon, the ensuing popup (see screenshot below) takes much longer to appear than it did on the old server. It takes a solid 4-5 seconds to appear. Does anyone know how to speed this up, or what cause this?
December 1, 20222 yr Community Expert It can only be it loading from the server itself. Note more resources doesn't necessarily mean it performs better. That is more down to the configuration of the server to use those resources in an efficient manner. Check your support area in the admin CP first of all, and see if anything is showing up in the mysql area. If there is, action that and test again. If not, it would likely be a case of tuning your mysql instance to speed it up
December 1, 20222 yr Author 42 minutes ago, Marc Stridgen said: It can only be it loading from the server itself. Note more resources doesn't necessarily mean it performs better. That is more down to the configuration of the server to use those resources in an efficient manner. Check your support area in the admin CP first of all, and see if anything is showing up in the mysql area. If there is, action that and test again. If not, it would likely be a case of tuning your mysql instance to speed it up OK, thanks. Nothing recommended in Support area. I will work on MySQL.
December 1, 20222 yr Author Hi @Marc Stridgen you nailed it. I just tuned mysql and now notifications is super quick. Thank you!
December 1, 20222 yr 6 hours ago, Chris027 said: Hi @Marc Stridgen you nailed it. I just tuned mysql and now notifications is super quick. Thank you! Hi Chris. Could you describe what exactly you changed? Thanks.
December 2, 20222 yr Author 2 hours ago, SeNioR- said: Hi Chris. Could you describe what exactly you changed? Thanks. I made changes to the mysqld options in the conf file. The “best” values for these will be different for everyone. innodb_buffer_pool_size innodb_log_buffer_size innodb_file_per_table innodb_open_files innodb_io_capacity innodb_flush_method Key_buffer_size max_allowed_packet thread_cache_size max_connections Connect_timeout wait_timeout sort_buffer_size bulk_insert_buffer_size tmp_table_size max_heap_table_size query_cache_type query_cache_limit query_cache_min_res_unit query_cache_size
December 2, 20222 yr Community Expert 20 hours ago, Chris027 said: Hi @Marc Stridgen you nailed it. I just tuned mysql and now notifications is super quick. Thank you! Glad to hear it 🙂