Slow Notifications Popup

[Chris027]

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? 

 

[Marc]

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

[Chris027]

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. 

[Chris027]

Hi @Marc Stridgen you nailed it. I just tuned mysql and now notifications is super quick. Thank you!

[SeNioR-]

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.

[Chris027]

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
 

[Marc]

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 🙂