UnderHost
Knowledgebase Docs

Databases

MySQL, MariaDB, SQL, optimization, and database management.

20 articles Updated regularly

Beginner guides

4 guides

Intermediate guides

14 guides

Database administration basics-users, permissions, maintenance

Create MySQL/MariaDB users and databases, manage permissions, import/export data, monitor performanc...

Intermediate 13 min Database Administration June 2026

Database backup strategies-full, incremental, and point-in-time

Plan database backups: full backups, incremental backups, retention policy, off-site storage, and di...

Intermediate 11 min Database Backups June 2026

Database import and export-migrate data between servers

Export database via mysqldump or phpMyAdmin, import to new server, handle large exports and compress...

Intermediate 10 min MySQL Migration June 2026

Database indexes-speed up queries dramatically

How indexes work, PRIMARY KEY vs UNIQUE, composite indexes, when to add indexes, and finding missing...

Intermediate 11 min MySQL Performance June 2026

InnoDB storage engine-ACID compliance and transactions

InnoDB provides ACID transactions, row-level locking, and crash recovery. Use InnoDB for WordPress a...

Intermediate 10 min MySQL Transactions June 2026

MySQL locks and transactions-prevent data corruption

Understand row-level locks, table locks, deadlocks, and ACID transactions in InnoDB....

Intermediate 10 min MySQL Locking June 2026

Database monitoring-health checks and performance metrics

Monitor MySQL/MariaDB health, query performance, disk usage, connections, and detect issues before t...

Intermediate 11 min MySQL Monitoring June 2026

Database optimization-speed up MySQL queries

Optimize MySQL and MariaDB performance: run OPTIMIZE TABLE, add indexes, tune my.cnf settings, and u...

Intermediate 10 min MySQL Performance June 2026

Slow query analysis-find and fix performance issues

Enable slow query log, analyze with EXPLAIN, identify bottlenecks, and optimize database performance...

Intermediate 10 min MySQL Analysis June 2026

MySQL user management-create, grant, and revoke permissions

Create MySQL users, grant specific permissions per database, revoke access, and reset passwords secu...

Intermediate 10 min MySQL Users June 2026

UTF-8 character encoding-store international characters correctly

Set UTF-8 encoding for databases, tables, and columns to support international characters (accents, ...

Intermediate 9 min MySQL Encoding June 2026

MariaDB vs MySQL-differences and compatibility

Compare MariaDB and MySQL: performance differences, storage engines, JSON support, and compatibility...

Intermediate 10 min Database Comparison June 2026

MySQL Performance Tuning: Speed up database queries

Improve MySQL performance through indexing, query optimization, and configuration. Learn slow query ...

Intermediate 6 min MySQL Performance June 2026

Advanced phpMyAdmin-queries, imports, and maintenance

Use phpMyAdmin for SQL queries, large imports, table optimization, user management, and database rep...

Intermediate 10 min MySQL phpMyAdmin June 2026

Advanced guides

2 guides

Related categories

Can't find what you need?

Our support team is ready to help-open a ticket and we'll look into it directly.