What does the sub-database and sub-table partition of the database mean?

what do you mean by sub-database and sub-table partitioning of the database?


Database sub-table: split a single business table redundant in a single database into N "logically related" business child tables;
Database sub-database: divide the business tables in the original single database into N "logically related" databases according to some algorithms;
Database partitioning: divide databases that were previously stored in a single physical storage area into less than N physical storage areas.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e49422-666bd.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e49422-666bd.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?