Data at Your Fingertips: Explore Our New Reporting and Statistical Capabilities By Ryan Ashbrook 23 hours ago
Chris027 Posted November 30, 2022 Share Posted November 30, 2022 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? SeNioR- 1 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted December 1, 2022 Share Posted December 1, 2022 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 SeNioR- 1 Link to comment Share on other sites More sharing options...
Chris027 Posted December 1, 2022 Author Share Posted December 1, 2022 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. Link to comment Share on other sites More sharing options...
Chris027 Posted December 1, 2022 Author Share Posted December 1, 2022 Hi @Marc Stridgen you nailed it. I just tuned mysql and now notifications is super quick. Thank you! SeNioR- 1 Link to comment Share on other sites More sharing options...
SeNioR- Posted December 1, 2022 Share Posted December 1, 2022 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. Link to comment Share on other sites More sharing options...
Chris027 Posted December 2, 2022 Author Share Posted December 2, 2022 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 SeNioR- 1 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted December 2, 2022 Share Posted December 2, 2022 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 🙂 Link to comment Share on other sites More sharing options...
Recommended Posts