Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [disk-space]

For questions about the storage space used by databases or database objects.

0
votes
0answers
28 views

How to manage Oracle diagnostics logs not managed by adrci?

How can I identify Oracle log files that are not managed by adrci? I wish to manage disk space usage, in a similar scenario to this article: "How to free up disk space? which logs/directories to ...
-4
votes
1answer
49 views

PRODUCTION DATABASE RUNNING OUT OF SPACE [on hold]

My database has 9556.97MB of space left. I do have about 2TB free disk space. The database is in full recovery mode and doing full backup everyday, also TLOG backup every 24 minutes. I used to just ...
5
votes
2answers
480 views

Do I need to leave some extra space available on the disk which my database log files reside, for log backup operations to successfully occur?

If I size my log files to evenly split the entire drive they reside on, leaving no extra space available, will log backups still be able to occur successfully? I have several databases, with one log ...
1
vote
0answers
21 views

Why is my InnoDB table size so much larger than the data?

I have a MySQL table (version 8.0.13). One table is unreasonably large and doesn't correspond to the current data. I rebuilt the table by running ALTER TABLE users FORCE and OPTIMIZE TABLE users, but ...
0
votes
0answers
46 views

Mongoexport and mongodump disk usage rationale

I just had an interesting experience with the mongoexport tool and came out with a doubt about the exporting process' disk usage. I was trying to dump a 50 MB collection to a disk that had 3 GB free ...
-1
votes
1answer
30 views

Database volume completely full

/dev/mapper/pgdatavg-base 138304552 131262788 16384 100% /var/lib/pgsql/data/base pg_xlog is on a separate volume, and it's got plenty of space. [postgres@fpslbxmbstgl05 ...
1
vote
0answers
21 views

One of the mongo shards consuming too much disk space.

We have mongo cluster with 10 shards of each having 3 replicas. Recently we are facing an issue, exceptionally in a couple of shards, the disk space among all the 3 replicas has reached above 90%. ...
2
votes
1answer
167 views

Mongodb replica set primary and secondary node conf fail when one slave is down

In my env, I had created MongoDB replica set conf for high availability so one server fails should be handled by other also in my conf I have 3 DB server and 1 arbiter too but, my slave's server ...
0
votes
1answer
50 views

why when I change a column from DATETIME to DATE, I can't see any storage improvement?

Long story short. I have a table with more than 10millions rows with a datetime field. WE can change that to DATE ( because date uses 3bytes, and datetime 8). I thought if I: alter table table1 ...
2
votes
2answers
61 views

Upgrade in-place with low disk space on C: drive

I am due to upgrade SQL Server 2005 Express to 2014 Express. This will be an in-place upgrade. It's not my preferred way of upgrading, but being a physical machine and in a specific secure network ...
1
vote
1answer
34 views

Why does this tsvector update use so much space?

This is my table structure: Column | Type | Collation | Nullable | Default | Storage | Stats target | Description -------------+---------------...
1
vote
1answer
39 views

Use T-SQL to return free space on a network share

I'd like to be able to calculate the amount of free space I have for offsite backups so I can prevent any jobs from running should there not be the relevant space and also be able to send alerts when ...
-2
votes
2answers
533 views

How to query system specs (cpu, memory, data disks, free space) using t-sql [closed]

Is there an ability to query below system specifications using t-sql ? 1. cpu (show number of processors / cores / frequency) 2. memory (show total amount of RAM on a machine; show allocated RAM; ...
2
votes
3answers
139 views

How to set space usage alert for database using SQL Server 2012 with Amazon RDS as managed service?

I have a database whose initial size is set to 1000 GB. Is there a way where i can set an alert when the max space is used and database size is nearing to 1000 GB, for eg when it reaches maybe 995 or ...
0
votes
2answers
123 views

Impact on database while increasing database initial size

I have a database whose initial size is 900 GB for .mdf file and 13 GB for log file, I want to increase its initial size to + 100 GB , while doing that in the properties -> filegroup->initial size, do ...
0
votes
1answer
192 views

What happens when an auto grow event is triggered to the database?

I want to know what happens when an autogrow event is triggered... Does it hold up all the database processing including reads and writes during that time? For instance, our database encounters for ...
0
votes
2answers
48 views

Drive holding my database is running out of space. What are my options?

I am new to database administration. I've been scraping a website for a month now. I have two drives, each 2TB in size. I have PostgreSQL 10 on my first drive (c:) and it has 50GB left. I've only ...
1
vote
1answer
90 views

Is there any string compaction option for PostgreSQL?

I have a table like this: CREATE TABLE BLOG( CATEGORY CHAR(32) ); Category is a column, which stored enum values. For example, I have 1 millions of rows and 10 unique values of Category. Let'...
-1
votes
1answer
140 views

Allocation of disk space to new created databases in production [closed]

Our current production database has total disk space of 2 TB. (SQL Serve 2012 standard RTM version.) Currently we have database size allocation as attached. Apart from FUNDSDB and DBAdmin, remaining ...
0
votes
1answer
109 views

Autogrowth Analysis in PROD DB based on the trace file data

I have used the below query to check our Production Database Autogrowth events so that we can set to a value which is much more realistic than the current value of 200 mb , unrestricted for mdf file ...
0
votes
2answers
266 views

Recommended Auto Grow settings suitable for database whose size is 867666.25 MB [closed]

I need recommendations for setting/modifying the auto grow options for our production database. size of FUNDSDB 867666.25 MB Also, I have attached the current autogrowth statistics , looks like ...
2
votes
1answer
227 views

Implementing disk quota for MariaDB

I want my Linux MariaDB database to have disk quota implemented. How can I achieve this these days? I have found some tools but they are for MySQL, don't know if they are supposed to work on ...
2
votes
1answer
62 views

Where in the database file is an index rebuild started? Alternative to SHRINKFILE?

When rebuilding an index in SQL server, where in the datafile does it put that data? Does it start at the beginning of free space and fill in the gaps from there? Context: I have some large .ndf ...
1
vote
1answer
36 views

Guideline for MySQL free space

What is the guideline for how much free space to keep available on a MySQL AWS RDS instance (SSD)? In the past for an on-premises SQL Server install we used to use something like 2x the largest table ...
2
votes
1answer
76 views

Disk Architecture on SQL Server [closed]

I am building a new environment using the SQL Server 2017 Always-On system. This will be active 24/7 and there will be lots of DML processes. I have a 100GB SAS for the OS, a 1TB SAS for Data and a ...
0
votes
0answers
44 views

Expanding Cluster Drive space

I will need to expand my existing cluster drive (sql cluster with 2 node active and passive) which has sys and user database data files. My san admin told he will need to delete all the existing data ...
0
votes
1answer
232 views

Reduced copy of zabbix database

I've a relatively big postgresql database that tooks a lot of space in a server. The database stores a zabbix system used to monitor data that I've to safely keep, so history tables are quite big. My ...
1
vote
1answer
49 views

Not find the table of the oid

I have a database running under PostgreSQL which normally has to have a size of 300 GB. Unfortunately it is now 3,5 TB in size. I noticed that the directory of this database , the pgdata path is /...
6
votes
1answer
3k views

If no plans to uninstall, can Log and Update Cache folders in Setup Bootstrap folder be removed?

I have several versions of SQL Server, used for testing, installed on my laptop (2012, 2014, 2016, and 2017). I noticed the other day that there was a folder containing prior versions of files across ...
0
votes
0answers
102 views

MySql tables use 3GB, but disk usage is 40GB

I have a 48GB Linode machine. The ONLY thing this machine runs is docker with the standard mysql:8.0.3 docker image. Looking in information_schema.TABLES I can see I use in total 2.8GB. However, when ...
0
votes
1answer
73 views

Back Up - Free Drive Space

Is there a way to know the free disk space available on the drive that the back up file will be created? For example, SQL Server is installed in Server 1 and the back up file is scheduled to be ...
0
votes
2answers
1k views

SQL Server 2016 out of disk space

I'm running SQL Server 2016. I have a database that has run, apparently, out of space on the D: drive. The daily index rebuild started producing the error shown below. Msg 1101, Level 17, State 12, ...
1
vote
1answer
83 views

Decrease size of database (with an expression index)?

This is my current table definition in a Postgres 10.1-1 database: CREATE TYPE CUSTOMER_TYPE AS ENUM ('enum1', 'enum2', 'enum3', '...', 'enum15'); -- max length of enum names ~15 CREATE TABLE ...
0
votes
2answers
342 views

Purging Binary Logs from Master in a Replication Environment

Replication Set up 6 Masters and their respective Slave. All 6 slaves writing to a Master - which has its own Slave. Now, I want to purge binary logs on the 6 original masters and set expiry to 15 ...
10
votes
2answers
3k views

Does taking transaction log backups every 15 minutes consume more disk space than log backups every 6 hours?

In our environment the network storage is low on space. At the same time I would like to make sure that we take transaction log backups every 15 minutes instead of current every 6 hours. My question ...
2
votes
3answers
149 views

Why does my DELETE command require huge amount of temporary run storage?

I am trying to perform a cleanup operation on a table using DELETE and I receive the following error: Could not allocate space for object 'dbo.SORT temporary run storage: 140767697436672' in ...
1
vote
1answer
260 views

How to reclaim unused space from clustered index table

I have a clustered index table with more than 11,000,000 records running on SQL Server 2008 R2 Standard Edition. I have noticed the table has about 90 GB of free space. This is the table definition: ...
0
votes
1answer
620 views

Freeing unallocated space

I have a server that the database drive is running out of space. i have deleted some of the old log data and historical data to try and free up the space.what is the best way to free allocated space ...
2
votes
1answer
70 views

How does combining columns save disk space?

I am creating a table in SQL server and inserting records. Three columns from this table are AAA int, AAB int and AAC int. If I merge AAB and AAC into one column Comb1 char(2), it consumes 20% less ...
1
vote
1answer
475 views

How to Determine Optimal Disk Cluster Size for Firebird 2.5

I'm using Firebird 2.5.6 Classic Server on a Windows 7 64-bit machine. We're moving the database to a separate disk (32GB NTFS Volume) and are now provisioning that disk. My question is, what should ...
5
votes
0answers
983 views

VARCHAR(MAX) taking more space than NVARCHAR(MAX) [duplicate]

I have a table in SQL Server 2012 Enterprise Edition that has ~100GB of data. Most of this data is attributed to a single NVARCHAR(MAX) column which has an average length of 4500 characters. It stores ...
0
votes
0answers
43 views

Master binlog has stopped

Couple of days ago all of my slaves weren't able to sync data from the master. After searching deeply, Here is my findings: 1- Seconds_Behind_Master= NULL. All the slaves. 2- The error was 'binlog ...
3
votes
1answer
495 views

How does SQL Server reuse reserved pages after deleting a table

I just want to know: How SQL Server reuses reserved space after dropping a 1GB table? (call the table T1) How SQL Server reuses reserved space after truncating a table? (call this table T2) Both are ...
0
votes
1answer
117 views

Creating indexes vs Rebuilding indexes (larger db/log file)

I am a bit lost on what it the right way to do this. I am migrating data from one db to another (corrupt errors) so i did the following: Create a new blank db Generate a object script from my source ...
1
vote
1answer
1k views

How to reclaim database space on Azure SQL Server after setting nvarchar values to null [duplicate]

There is db space challenge at hand on Azure SQL Server database. 490 GB out of 500 GB is used. That's what I read from nice pie chart on Azure portal. Notice that some of the techniques used on-prem ...
-2
votes
1answer
80 views

Disk space problem regarding MongoDB [closed]

I have 12 servers in which there are 4 replicas. The architecture of the mongo servers and the disk spaces are present like: 1st replica s1-rep1 - 287GB s1-rep2 - 0GB s1-rep3 - 0GB 2nd replica ...
2
votes
1answer
3k views

Does InnoDB ever release unused disk space?

A large MySQL association table with 500M rows recently ballooned into 1B rows due to a bug (now fixed). Disk usage went from ~130GB to 240GB. Unfortunately there is not room on this server for any ...
5
votes
2answers
370 views

1000 MB vs. 1024 MB

Is there any authoritative documentation regarding whether 1 GB = 1000 MB or 1024 MB in reference to 1 ) disk space and / or 2) RAM? Based on my research the "official" breakdown of 1 GB used to be ...
0
votes
1answer
107 views

Optimal data type for storing numbers in SQL Server [closed]

Similar to varchar that stores strings of varying length, is there an alternative for numbers of varying length that allocates space depending on the size of the number? I have a large table with 50 ...
1
vote
0answers
155 views

Disk space for non-persisted In-Memory tables

I have a database on a SQL Server 2014 SP2, CU5 Enterprise edition. The database has a memory optimized filegroup. There are two tables in it, both are set to DURABILITY = SCHEMA_ONLY and have a low ...