#MYSQL INSERT SQL FILE UPDATE#

#MYSQL INSERT SQL FILE UPDATE#

I addressed something like this last year : How do I get % progress for 'type db.sql | mysql' UPDATE 14:09 EDT If the table is InnoDB and you have innodb_file_per_table disabled, not even the OS point of view can help. Of course, you need to compare that with what the table size was before on the other DB server you imported from. The reason? The table is write-locked throughout the reload. If the table is InnoDB and you have innodb_file_per_table enabled, the only way to monitor is from the OS point of view. If the table is MyISAM, the only way to monitor is from the OS point of view. Sorry for not noticing that there is only one table. If you want to know what tables are in the dumpfile, run this against foobar.sql cat foobar.sql | grep '^CREATE TABLE' | awk '' When the dump is reloaded, the DB Connection will vanish.

You could just do a SHOW PROCESSLIST and find out the DB Connection running the mysqldump.

Naturally, the reload of the mysqldump into a database would also be in alphabetical order. When you execute a mysqldump of a single database, all tables are dumped in alphabetical order. Non-clustered index sizes, in pages, multiplied by the InnoDB page Index size, in pages, multiplied by the InnoDB page size.ДЇor MyISAM, INDEX_LENGTH is the length of the index file, in bytes.ДЇor InnoDB, INDEX_LENGTH is the approximate amount of memory allocatedДЇor non-clustered indexes, in bytes. The MySQL 8.0 Reference states the following about the accuracy:ДЇor MyISAM, DATA_LENGTH is the length of the data file, in bytes.ДЇor InnoDB, DATA_LENGTH is the approximate amount of memory allocatedДЇor the clustered index, in bytes. SELECT table_schema 'Data Base Name', sum( data_length + index_length ) / 1024 / 1024 'Data Base Size in MiB'ДЇROM information_schema.TABLES GROUP BY table_schema This can be helpful if you know the total size of the. If you've already started the import, you can execute this command in another window to see the current size of your databases.

Mysql insert sql file