Just looking at my database... it's pretty big -
pf# mysql -u pf -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
<snip>
mysql> use pf
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> SELECT table_schema "DB Name",
-> Round(Sum(data_length + index_length) / 1024 / 1024, 1) "DB Size
in MB"
-> FROM information_schema.tables
-> GROUP BY table_schema;
+--------------------+---------------+
| DB Name | DB Size in MB |
+--------------------+---------------+
| information_schema | 0.0 |
| pf | 8465.4 |
+--------------------+---------------+
2 rows in set (1.07 sec)
mysql>
What's the best way to clean up the database of old data?
addons/database-backup-and-maintenance.sh
?
-
Pete Hoffswell - Network Manager
pete.hoffsw...@davenport.edu
http://www.davenport.edu
------------------------------------------------------------------------------
_______________________________________________
PacketFence-users mailing list
PacketFence-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/packetfence-users
