Question : For a system with sensitive information stored in a PostgreSQL 9.5 database, in which data stored in a […]
Tag: drop-table
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. […]
Can a TRUNCATE or DROP table ever be very time consuming?
Question : A couple of months ago, I discovered in a (not so well maintained) database a totally useless table […]
Speedup DROP huge MySQL replicated table
Question : I’ve a huge InnoDB table customer_users_old (150G) that it’s not in use anymore in the database, it was […]
What is preventing DROP TABLE from removing a Postgres table? [duplicate]
Question : This question already has an answer here: Understanding psql prompts (1 answer) Closed 6 years ago. I have […]
Allow user to drop only tables / views created by that user in MySQL
Question : Is it possible to allow a user to only drop tables and views that he/she created in MySQL? […]
Massive DROP on a production database with the shortest downtime
Question : I was redesigning legacy database and have merged lots of tables into just four and now I’m looking […]
Allow user to drop only tables / views created by that user in MySQL
Question : Is it possible to allow a user to only drop tables and views that he/she created in MySQL? […]