A reminder about optimizing speed

[Dennis]

We moved our TCAdmin web server to a more powerful server a while ago, but somehow TCAdmin started performing really bad. Load times got slower and slower.

 

Today I remember that we used to use skip-name-resolve in our MySQL server configuration. After adding that and restarting the MySQL server, pages load completely in around 1-1.5 seconds instead of 5 seconds.

 

I'd guess I'm not the only one to forget about adding skip-name-resolve to my.cnf.

[Mods]

We noticed the same. Around 3000+ active servers we started to notice delays which worsened over time. Properly optimizing your MySQL server is critical with higher-volume as well.

[Streamline Servers]

We noticed the same. Around 3000+ active servers we started to notice delays which worsened over time. Properly optimizing your MySQL server is critical with higher-volume as well.

 

Definitely easy to miss. We noticed the same, had to deploy a MYSQL cluster system to share the load across multiple MYSQL nodes.