GoAdmio
GoAdmio Documentation

Restart MySQL

From the GoAdmio knowledge base.

Restart MySQL

This page explains how to restart the MySQL/MariaDB database service in GoAdmio. The database server powers every hosted application that stores data — WordPress, Joomla, Drupal, e-commerce stores, CRMs, and custom apps.

Location: Admin Panel → Restart Services → MySQL Server


Overview

MySQL (or MariaDB, its drop-in replacement) runs as a system service on the server. It stores all databases and serves queries from PHP applications, scripts, and the panel itself.

Restarting MySQL:

  • Reloads the database configuration (my.cnf / mariadb.cnf)
  • Recovers from a crashed or hung database server
  • Applies new settings (buffer sizes, connection limits, etc.)
  • Clears stuck connections and locks
  • Rebuilds InnoDB crash recovery if the server shut down uncleanly
> Warning: Restarting MySQL interrupts every database query on the server. Websites that use a database will show errors (e.g., "Error establishing a database connection") until MySQL comes back online. Active transactions may be rolled back. Restart during low-traffic hours, and never restart while a large transaction or backup is in progress.

When to Restart MySQL

Restart MySQL after:

| Change | Why |
|---|---|
| Editing my.cnf | Applies new database settings |
| Changing buffer pool size, max connections, etc. | Requires a restart (most settings do) |
| Installing or removing a database extension | Loads the new module |
| MySQL is not responding | Recovers a hung or crashed server |
| Too many connections | Clears stuck connections |
| A database is locked | Releases locks held by stuck queries |
| After restoring a large database | Applies the new data and clears the cache |
| After a server crash | InnoDB crash recovery runs on startup |

> Tip: For configuration changes, some settings support SET GLOBAL at runtime — no restart needed. But most buffer sizes and file locations require a restart. Check the MySQL documentation for the specific setting.


How to Restart MySQL via the Panel

  1. Log in to the GoAdmio Admin Panel.
  2. Navigate to Restart Services.
  3. Locate MySQL Server.
  4. Click Restart.
  5. Confirm if prompted.
  6. Wait for MySQL to come back up — typically 5–30 seconds.
> Note: MySQL takes longer to restart than Apache or PHP-FPM — it must flush buffers, run crash recovery (if needed), and reopen all databases. Large databases take longer.

Verify the restart

  1. Open Service Status — confirm MySQL is running. See Service Status.
  2. Visit a site that uses a database — confirm it loads.
  3. Open phpMyAdmin or Adminer — confirm you can connect.
  4. Check the MySQL error log:
```bash tail -n 50 /var/log/mysql/error.log # or tail -n 50 /var/log/mariadb/mariadb.log
↑