Skip to main content

Server for MySQL DBAs

The MySQL server layer is the mysqld process and everything around running it: startup and shutdown, system variables, the data directory, logs, and the sys and performance schemas. Server administration decides how MySQL behaves day to day, from connection limits to log locations.

Stage: Setup · Part of the MySQL DBA roadmap · Last reviewed 19 November 2026

What to learn in Server

Server interview questions

What does SET PERSIST do in MySQL 8?

SET PERSIST changes a global system variable immediately and also writes the value to mysqld-auto.cnf in the data directory, so the setting survives a restart. SET GLOBAL alone changes only the running server and is lost on restart.

How would you find which connection is blocking others?

Query performance_schema or the sys schema, for example sys.innodb_lock_waits, to see waiting and blocking threads. SHOW PROCESSLIST gives a quick view of long running statements, and KILL can end the blocking connection if needed.

Where Server fits in the MySQL DBA roadmap

Server belongs to the Setup stage (beginner level), which takes about 33 hours. Install and learn the basics.

Back to the full MySQL DBA roadmap