sethserver.com

MySQL

MySQL

10 MySQL Performance Tuning Tips for Faster Queries

Updated: December 22, 2025

Discover 10 essential MySQL performance tuning tips to optimize your database queries. Learn about proper indexing, query optimization, table structure, caching, server configuration, and more to significantly improve your database efficiency and speed. read on »

MySQL

MySQL User Creation: Stop Using Root and Set Passwords Correctly

Updated: March 18, 2026

Stop using MySQL <code>root</code> the moment setup is done. Create dedicated users, lock them to the right host, and grant only the permissions your app really needs. The easy mistake: <code>CREATE USER 'app'@'%';</code> without <code>IDENTIFIED BY</code>-which can leave you with a user that connects without a password. Boring work, fewer 3am disasters. read on »

Newsletter

One email, once a week.

Notes on databases, systems, and the occasional strong opinion about Python. No spam, unsubscribe anytime.