Home > database >  Mysql backup and restore index size and table size, and is not the same as the query speed
Mysql backup and restore index size and table size, and is not the same as the query speed

Time:09-18

Today on the server database backup with sqlyog tools into. SQL file on the local situation, and then back to the local database, found in a SQL query to the local database data is very slow, and query the data on the server is very fast, then looked at the table takes up space attribute,  two database with a table takes up space, use explain command to explain after   results as shown above, the backup when tried structure and data backup at the same time, also tried to separate and then import the data backup, but they had no effect, to solve the...
  • Related