MariaDB: Troubleshooting

Common MariaDB issues and their solutions

👋 Welcome to the Stackhero documentation!

Stackhero offers a ready-to-use MariaDB cloud solution that provides a host of benefits, including:

  • Unlimited connections and transfers.
  • phpMyAdmin web UI included.
  • Effortless updates with just a click.
  • Optimal performance and robust security powered by a private and dedicated VM.

Save time and simplify your life: it only takes 5 minutes to try Stackhero's MariaDB cloud hosting solution!

phpMyAdmin timeout issues

Handling large datasets in phpMyAdmin may lead to timeouts. These timeouts are often caused by limitations in the PHP environment that phpMyAdmin depends on.

To mitigate these challenges, you could consider utilizing the MariaDB command-line interface (CLI) or other database management tools. These alternatives generally provide enhanced efficiency and reliability for managing large datasets and performing complex queries compared to browser-based tools.

Resolving the "SSL connection error: unknown error number" in MariaDB

If you encounter the following error:

ERROR 2026 (HY000): SSL connection error: unknown error number

This typically indicates that the database client software you are using does not support the modern TLS protocols required by secure MariaDB servers.

MariaDB instances, particularly those hosted on platforms like Stackhero, implement updated TLS protocols and secure cryptographic suites to ensure strong security practices. Consequently, connections using outdated protocols, such as TLS v1.1, will fail.

To resolve this issue, update your database client software to a version that supports the latest TLS standards. Regular updates to your client software will help maintain secure and compatible connections to MariaDB servers.

Restoring the root user and permissions

If you find that the root user has been removed or its permissions or password altered unintentionally, you can restore it by restarting the MariaDB instance. Doing so reinstates the root user along with its default permissions and password.

Reclaiming disk space after data deletion

Deleting data from a MariaDB table does not automatically release the disk space it occupied. To reclaim this space, you can execute the following SQL command:

OPTIMIZE TABLE <table>;

This command rebuilds the table by creating a temporary table, transferring the data, and replacing the original table. During this process, the table will be locked and unavailable. The duration of this lock depends on the size of the table.

To minimize the impact on database performance, it is advisable to run the OPTIMIZE TABLE command during periods of low activity or maintenance windows.

Other articles for MariaDB