Question : I’ve accidentally executed DROP TABLE statement on a wrong table. I have backups that are several days old […]
Tag: drop-table
Shrink database after drop table?
Question : I had a table with 70+ million records in a SQL Server database, I dropped that table (a […]
Drop table taking too long
Question : I have a table with approx. 200 million rows (approx. 0.5 TB) and I want to drop it, […]
Proper Way to Remove Mysql Tables
Question : I was going to ask why mysqldump was trying to write dropped tables but I found that answer […]
Difference between DROP and TRUNCATE
Question : What does the TRUNCATE do differently to drop? I believe it deletes all the data in the table […]
PostgreSQL drop view in case of unknown whether materialized or not
Question : I’m trying to drop a view, of which I cannot assure whether it is a MATERIALIZED VIEW or […]
Postgresql – how to securely delete the storage freed when a table is dropped?
Question : For a system with sensitive information stored in a PostgreSQL 9.5 database, in which data stored in a […]
Can’t do simple query or drop table due to out of memory error, but pg_locks return no lock
Question : I received this out of memory error when trying to drop a large table (70GB including index) but […]
DROP TABLE mysql.failover_console;’ replicates to slaves, but ‘Use mysql; DROP TABLE failover_console;’ does not
Question : I am currently looking to setup automatic failover for my MySQL 5.6.21 Master on CentOS 6.6. I have […]
Reclaim disk space after dropping table(innodb_file_per_table = ON), strange scenario
Question : I know it is often asking question. But I can’t find answer for my scenario with specific condition. […]