Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: drop-table

Postgresql – how to securely delete the storage freed when a table is dropped?

By adminPosted on January 5, 2023

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

By adminPosted on November 11, 2022

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

By adminPosted on November 3, 2022

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

By adminPosted on May 26, 2022

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?

By adminPosted on May 11, 2022

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

By adminPosted on February 3, 2022

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]

By adminPosted on January 4, 2022

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

By adminPosted on November 8, 2021

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

By adminPosted on August 13, 2021

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

By adminPosted on July 26, 2021

Question : Is it possible to allow a user to only drop tables and views that he/she created in MySQL? […]

  • 1
  • 2
  • 3

Recent Posts

  • Get column names and data types of a query, table or view
  • What is the effect on primary keys when moving a CLUSTERED index to a new filegroup?
  • Order of returned rows with IN statement
  • Do not want to allow Queries to take more than x minutes?
  • How would i create a report involving multiple many to many relationships
  • web interface port for oracle 11g
  • Getting the exact and closest Search using CONTAINS/CONTAINSTABLE in SQL
  • How can I check if a user have a quota on tablespace
  • Can alias in SQL Server contain slash?
  • Why store /var/lib/mysql when you can just create SQL dumps for backup purposes?
  • Fix OGR2OGR “failed when converting the varchar value to data type int” issue in the MSSQL table –
  • Sum on distinct and group by
  • Is a join optimized to a where clause at runtime?
  • Simple select is taking too long
  • GROUP BY with subqueries for a Group?
  • SERVERPROPERTY(‘Edition’) AS [Edition]
  • Do MySQL sub-queries essentially use as much overhead as separate queries?
  • select fieldvalues and column-description of a table
  • Secure database access from particular applications
  • How to optimize and estimate DB recovery times?

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding