How to separate data tables, but can still be used together on the site? As there is more and more data, the SQL file size becomes larger and larger.

the problem I face now is
I have a datasheet that is almost 1 million.
it"s not a way to go on like this.
how can I separate it out, but I can still use the data from the datasheet?
because suppose I export it to the drop table
I can"t use it on my website, so it can"t be used with the newly generated data?
I have also thought about opening another table and renaming the table with a lot of data, but the size of the backed-up file will get bigger and bigger.
can you give me some advice

Mysql-optimized php7 mariadb mysql php

Jun.01,2022

millions of small case, don't worry about it at all
if you really want to take it apart, make sure you still want to use your old data? If you want to use it, it can only be a normal horizontal sub-table (such as by id or by date); if you can not use it, just move the unused old data to another table every day

personal suggestion:

;
:text;
:

based on what your table is based on, you can do sub-tables, and then route to different data tables according to the requested object

MySQL can still cope with millions of levels. If you are simply afraid of affecting performance, you can build an index. If you really want to split it, name the table by time, such as table_2019_01_31, and then switch flexibly according to conditions when querying.

Previous: Compile and install zlib-1.2.11, still report error libz.so.1 () (64bit)

Next: How not to start the program during the SpringBootTest test?

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-1b37a92-2c0aa.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-1b37a92-2c0aa.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?