The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
0answers
3 views

mongodb compact does nothing - no entry in mongodb.log and nothing in db.currentOp()

We have space problems. The actual data size is only 5 GB, but disk size is 15 GB because of deleted documents. MongoDB (3.0.6) runs in docker container where we can't extend volume. # tail -f ...
2
votes
0answers
16 views

Is there a configuration option that lets me limit the percent of a hard drive that Cassandra uses?

I'm doing some testing with a small hard disk and I'd like to basically stop Cassandra in its tracks if a write or compaction or any other service brings that usage of the disk above a certain ...
0
votes
0answers
19 views

Move large text field to filestream without having to rewrite all codes MSSQL

My MS SQL Express Database keeps hitting the 10G limit. In a few months, we will migrate to Azure DB. In the mean time, to avoid problems, I'm thinking moving a huge text field (storing long html ...
1
vote
2answers
72 views

Reclaim Transaction Log space of SQL Server

I have a SQL Server databases for which log files have grown huge. I have log backup scheduled to run only once a day. But now all the disk space is used by these log files. Can anyone help me ...
4
votes
1answer
34 views

Howto query all files, their fill level and additional drive info with one query?

I need a query that puts together the following results: one row per databse file across all databases additional columns with information about the locigal drive the file is on information about ...
0
votes
0answers
24 views

MongoDB collStats.size compared to collection.totalSize

I have a collection which has the following dimensions: rs0:PRIMARY> db.myCollection.totalSize() 2188206080 rs0:PRIMARY> db.myCollection.stats() { "size" : 5899660704, "avgObjSize" : ...
1
vote
2answers
52 views

scaling options for mysql on linux vm (ubuntu) : how to scale when the RAID 0 is out of space

I was asked to give a scaling road map for our mysql database. Currently, I have a single mysql instance v5.6.28 running on an ubuntu VM on azure. It has a (software) RAID 0 disk made with two 1TBs. ...
2
votes
1answer
50 views

Temp DB space allocated- will it be reclaimed ever?

I have observed that the tempdb in the production environment has grown over to 100 GB after initializing it. I understand that due to server load and some expensive queries have resulted to the ...
1
vote
1answer
29 views

Does a read-only MySQL slave need log-bin in addition to relay-bin logs?

I'm running out of disk space on a newly initiated MySQL slave server. The bulk of disk space is in /var/log/mysql where I see both mysql-bin.000XXX and mysql-relay-bin.000XXX logs, each 1.1G. Does a ...
0
votes
2answers
73 views

Deleting old postgresql log files (Ubuntu)

In a Ubuntu machine hosting a postgresql database, I have 16G space taken up at /var/lib/postgresql/9.3/main/pg_log. Apparently, log files from many months ago are being stored as well. I manually ...
1
vote
1answer
41 views

DB2 archive log extraordinary growth for any operation after runstat/reorg

My environment: DB2 10.1.4 Enterprise, IBM Security Identity Manager 6.0 FP6, AIX 7.1 Each archive log have a size of 40MB Yesterday, we do a maintainance on ISIM database by doing online backup. The ...
0
votes
0answers
11 views

MySQL disk usage due to failure on dump import

I've just SCPed a 400 MB database from a live server. I dumped it with mysqldump and gziped it as following: mysqldump --single-transaction=TRUE -u dbuser -p dbname | gzip> /home/user/database.gz ...
0
votes
1answer
126 views

MySQL dump with low disk space

I have an asterisk PBX that has call recordings stored in a SQL database table. This table has 9199 rows and is consuming 21GB on my server. I want to dump the data in this table to restore space on ...
0
votes
1answer
35 views

Mariadb uses all /tmp space

I am running a galera cluster with mariadb 10. One of my node report 100% usage disk for /tmp table. /dev/mapper/vg0-LV--Tmp 1,8G 1,7G 228K 100% /tmp I can't see files in /tmp with ls ...
0
votes
1answer
22 views

Mysql datadir and binlogs: same partition or not?

On a MySQL cluster, does it make sense to store MySQL database files and binlogs in different partitions? (This is about partitions on the same physical disk. If they were on different physical ...
0
votes
1answer
42 views

Will this SQL snippet REINDEX my GIN index? Why is it renaming an old index onto another?

I have a large PostgreSQL 9.3 database. One index on one table is quite large and appears to be bloated. I am using pgcompact from pgtoolkit to reduce database bloat without heavy table locks. However ...
0
votes
0answers
42 views

Is it possible to do a VACUUM FULL and allow read-only access to the table?

I have a PostgreSQL (9.3ish) database which has a lot of data written to it frequently. Disk space is constantly being used. I have had success with VACUUM FULL with trimming the bloat and reducing ...
0
votes
2answers
49 views

Process to reclaim free space from mongodb ,replication is there

We are facing space pressure on production server so we are planning to reclaim space from prod instance.replication is there ,can anyone help me to know complete process in sequence to reclaim ...
1
vote
1answer
161 views

How to reduce size of PostgreSQL table after dropping columns?

I have a PostgreSQL database. One table is very large. I want to extract a TEXT column into a separate table and see how much I can reduce the size. The problem is that the size appears to stay the ...
6
votes
1answer
244 views

Running out of disk space running MySQL query

I have been trying to create a "gaps and islands" identification routine in MySQL. See the previous question regarding setup here and computational resources required here. I increased the RAM of the ...
0
votes
2answers
55 views

Reclaiming space from data files in Oracle

Is it good to reclaim space using resizing datafiles? What are the things to be taken care before resizing the datafile?
1
vote
1answer
96 views

Is my postgres index being used?

I have a large PostgeSQL 9.1 database in production use. I want to free up some disk space. There is a large index, and I'm unsure if it's being used. select * from pg_stat_all_indexes where ...
3
votes
1answer
115 views

Reclaim disk space from dropped column without downtime

I have a heavily used table (with around 5 million rows) in a PostgreSQL database in which I want to drop a column and reclaim the space the column used. The docs suggest doing a table rewriting ...
3
votes
1answer
63 views

Disk Size Considerations for a SQL Server 2008 R2 database

What's the rule of thumb for Disk size considerations for hosting a mirrored database that supports about 100 writes every second during peak. Current database full back up size is approx 150 MB. ...
0
votes
2answers
59 views

Where does extra bytes come from

Here is my table: +-------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | ...
0
votes
1answer
37 views

SQLite Data Types In Context of Disk Space

I would like to better understand which data types in SQLite take up more disk space. I've looked through official documentation but could not find anything in context of storage space. Any guide ...
1
vote
1answer
77 views

Monitor disk usage with MongoDB Ops Manager

We use MongoDB Ops Manager 1.6.2.251. I searched Activity -> Alert Settings. Is there a way to monitor disk usage? To get an alert if this changes to 90%: # df -h /data/ Filesystem ...
1
vote
0answers
60 views

Space usage when copying

Short version Copy table took up more space than I expected or tested Why would that be? Could it be the replication / binlog? If so, what then is written to the binlog during this query: INSERT ...
3
votes
1answer
653 views

Database server down: file /dev/vda1 used up all diskspace

My database server went down last night because there was no diskspace available. I checked what used up diskspace and it was 28GB by /dev/vda1 I have no clue what this is. The database all together ...
8
votes
1answer
92 views

How to reclaim space taken by an index that partially built and was terminated by a power outage

I'm running postgres (postgis) 9.4.2 on a mac (10.10.4). I've got a couple big tables (several TBs). During an index build on one of them that takes about a week, I watched the available HD space ...
2
votes
2answers
165 views

Disk size and log file growth during upgrades

I have four SQL Server databases. Per the maximum load requirements, each database file can be between 1 and 2 TB in size. The HDD is a multi-disk DAS with about 9TB of space. During a database ...
0
votes
0answers
209 views

Running out of disk space when removing documents error

I'm trying to remove unused document from a production instance of MongoDB but, when I try to execute this query: db.collection.remove( { date: {$lt: new Date((new Date())-1000*60*60*24*90)} } ) ...
1
vote
0answers
53 views

selecting from information_schema increases free disk space

Some background: There are 3 database servers - two in a master/master replication config with only one server accepting writes. And one other slave replica replicating from the write-master. The ...
1
vote
0answers
141 views

PostgreSQL suddenly using all my disk space

Today I fired up my linux mint via my virtual computer (host is windows 8), left for 30 minutes, and when I was back, I got an error saying I was out of disk space. Yesterday I had about 20 free GB ...
0
votes
0answers
17 views

Options for reducing transaction log size when disk space is restricted [duplicate]

I have a very unfortunate situation in which I have some SQL Server (standard edition) databases living on a small (~120gb) disk, and a transaction log which has grown to 50gb+. Unfortunately, the ...
3
votes
2answers
545 views

What is the difference between Used and Allocated space?

I am learning Database operations and I have found a couple of resources online that have given me a loose understanding, but I still couldn't explain the difference myself. Explain like I am five ...
-1
votes
2answers
105 views

how can I delete records when my disk drive is full?

My data folder of SQL as filled up the space of my local drive. I have 150KB free space left in the drive. So I have to delete some records to regain space. But when I run the delete query it says ...
1
vote
1answer
133 views

postgres: WAL files not being deleted during PITR

I have got an issue with setting up PITR on my postgres server: WAL archiving and restoring works quite well, as well as restoring to a specific point in time. The issue however is, that if i do a ...
0
votes
1answer
230 views

Why can't I get the available free space after shrinking?

My disk drive was full. So I deleted some records. Then I tried to shrink and it indicated available free space of around 5GB as indicated in the below image. Once I ran the shrink for data file, ...
0
votes
1answer
20 views

Old Data on SFTP [closed]

There are several old files on an sftp of mine that date back to two years ago. These files are ingested into a MySQL database. I am wondering what to do with the old raw files. The reason I am asking ...
2
votes
1answer
33 views

Handling Recovery of Disk Space in MySQL and MongoDB

So I have worked with MySQL all my life (not as a DBAdmin, but a programmer), and I have some limited knowledge about maintaining MySQL databases. Recently a portion of our database has been moved to ...
2
votes
1answer
129 views

Controlling how tempdb activity is split across drives (tempdb on both solid state and spinning drives)

I'm seeing the following tempdb I/O behavior over a one hour period: There is a fair amount of disk I/O generated by multiple DW workloads executing on the machine, some of which cannot fit in the ...
6
votes
3answers
1k views

Get MS SQL Server to release disk space

A poorly managed database table has grown to be enormous. 48+gigs of orphan records. I am trying to clean it up and put my dangerously full hard drive back to a normal state. I will be deleting approx ...
0
votes
1answer
190 views

Analyse and report disk usage growth historically

Is it possible to use historic information to show disk usage growth? I haven't keep much in the way of database setup and disk usage information. So I can't say how much disk growth has occurred in ...
3
votes
3answers
3k views

Monitoring free space in SQL Server data files

I have manually resized mdf/ndf files to a big size to avoid autogrow operations on SQL Server databases. Since the files are bigger there is very little free space on disk partitions and the ...
0
votes
0answers
151 views

Instance consuming large amount of disk space

I have an environment that is Microsoft Server 2000 and Microsoft SQL Server 2000. The database has a file size of 112 GB. The total size of the disk is 122GB. For some reason in less than a few ...
3
votes
1answer
511 views

Postgres: check disk space taken by materialized view?

I know how to check the size of indexes and tables in Postgres (I'm using version 9.4): SELECT relname AS objectname, relkind AS objecttype, reltuples AS "#entries", ...
0
votes
2answers
170 views

What causes disk space growth from Informatica load onto SQL Server?

We've been dealing with huge disk growth on SQL Server from Informatica. After the load, the database grows to 2.4TB. After the database shrink, it goes to 1.05TB. What could likely cause this to ...
2
votes
3answers
227 views

SQL Server 2012 enlarge database space

I tried to enlarge a database size of database instance on my SQL Server 2012. I manually added a new .MDF file under database instance After restart on shrink database dialog I can see available ...
1
vote
1answer
152 views

Alter column opreation failed due to disk space in SQL Server

I am attempting to alter a column on a specific table; however the process is failing because the log file runs out of space once the disk runs out of space. The size of the table is less than the ...