| Excerpt |
|---|
If your HDD is almost full, delete (or export) the old logs data and optimize the MySQL disk utilization. |
| Table of Contents |
|---|
Introduction
| Warning |
|---|
This guide include some suggestions in order to keep safe and clean your xCally database. We strongly recommend you to refer to your DBA before doing any operations on the database. |
First of all, backup the data!
Perform a database dump is not a complex operation, but you need to know which is exactly the database size because you will need enough space to save the dump file.
You can get the DB size by running the following query
| Code Block | ||
|---|---|---|
| ||
SELECT table_schema "Data Base Name",
SUM( data_length + index_length ) / 1024 /
1024 "Data Base Size in MB"
FROM information_schema.TABLES
GROUP BY table_schema ; |
| Page Properties | ||
|---|---|---|
| ||
|