The disk-space tag has no wiki summary.
1
vote
2answers
86 views
Database running out of space
My database has 16MB of space left.
I used to just truncate as I was taught but I found these links that advise against truncating:
...
4
votes
2answers
81 views
Partitioning and freeing disk space
I am running MySql innodb with innodb_file_per_table.
As a daily script, I would like to create a new partition for a set of tables, as well as delete yesterday's partitions. What command would need ...
3
votes
2answers
89 views
Disk space full but logical space available in database
We have a fairly big MS SQL 2008R2 database that resides on a SSD drive. The drive itself only has ~110Gb of space, and the database files are the only files on the drive.
The database is in "Simple" ...
1
vote
0answers
63 views
SQL Server 2005 Unexpected Disk Usage during Backups [closed]
On our SQL Server 2005 SP4 server we have a maintenance plan in place which performs a full backup of selected databases on a nightly basis. The databases are configured in Simple recovery mode and ...
2
votes
2answers
68 views
View Disc Usage
Is this statement correct?
Behind the scenes SQL Server actually stores the data in the view as a
physical table which must be updated if any of the data behind the
view changes
I did some ...
1
vote
1answer
107 views
Is there a tuning parameter for MySQL that allows you to set an on-disk gap between non-sequential primary keys?
I understand that one of the primary issues with using a non-sequential primary key is that every disk/memory write that does not come after the last known key causes a re-write of everything from the ...
2
votes
0answers
165 views
How much disk space needed for 100GB of DBs?
Hard to explain in the title, but I'm planning a migration from SQL Server 2000 databases to SQL Server 2008 R2. The databases are under 100GB total space, but this is only with the Simple recovery ...
1
vote
2answers
176 views
Should a SQL Server TempDB space be allowed to be reclaimed?
If I don't have space concerns at the moment, should I size my TempDB as a large space initially and not let it's space be reclaimed?
What's the best way determine what the optimal initial size for ...
4
votes
1answer
245 views
Safe way to truncate SQL Server Error Log
We are running out of space. What is the safe way to clear the error log?
2
votes
2answers
346 views
Get disk space percentage free with SQL Server 2005?
I am currently using SQL Server 2005 and (undocumented I believe) master..xp_fixeddrives to get free space on my database volumes as part of my monitoring.
However, this only gives me an absolute ...
2
votes
3answers
1k views
T-SQL query to report disk space allocation and used space for auto-grow SAN databases
We are using 6 databases in total for an application, and we can only share 4TB of space for all 6 databases (via SAN storage). I'd like to write a query (report) for a single database indicating the ...
1
vote
1answer
170 views
Disk space recovery on Mongodb replicaset secondaries
Is it possible to recover disk space on replica set secondaries based on the results of a repairDatabase call performed on a primary? I can't seem to locate anything that would work short of bringing ...
1
vote
1answer
150 views
Diskspace usage of DB
I have a production database that's consuming a significant amount more disk space than it should be.
Using sp_spaceused (only the interesting tables), I get.
Table Name Reserved (KBs) Data ...
1
vote
1answer
139 views
Imports & exports under storage constraints and preallocations
I have a 5GB oracle database that I want to export and then import on my own local database. Easy right?
The point is, I use oracle XE 10g which allows me to use up to 4GB. I then decided to make the ...
3
votes
2answers
5k views
How do I shrink the innodb file ibdata1 without dumping all databases?
InnoDB stores all tables in one big file ibdata1.
After dropping a big table, the file is keeping its size no matter how big the table was.
How can I shrink that file without having to dump and ...
1
vote
1answer
180 views
Why is SQLite adding unused disk space to “free-list” after deleting a lot of data in a database?
The SQLite FAQ states the following:
(12) I deleted a lot of data but the database file did not get any
smaller. Is this a bug?
No. When you delete information from an SQLite database, the ...
6
votes
3answers
2k views
Measure the size of a PostgreSQL table row
I have a PostgreSQL table. select * is very slow whereas select id is nice and quick. I think it may be that the size of the row is very large and it's taking a while to transport, or it may be some ...
2
votes
1answer
921 views
How do we free up disk space from allocated namespace? / ORA-03297
We are running out of disk space.
The server has a 420 GB HDD, and runs a Microsoft SQL Server and an Oracle Server(10g).
The Oracle server uses up to 315 GB space. We have just loaded a 100GB ...
1
vote
2answers
110 views
Does an analysis/optimization tool like SqlYog exist for SQL Server 2005 (and later)?
I'm curious about effective space allocation of my tables, so:
does something like SqlYog exist for SQL Server 2005 (and later)?
Of course I know SSMS, but I was looking for something more precise ...
0
votes
1answer
33 views
Does a numeric field always use the same disk space?
When you have a numeric field in MySQL(MYISAM) (E.g. Integer) will it always use the same disk space, no matter what number is actually stored?
2
votes
1answer
542 views
Drop user did not reduce size of tablespace file
I have a development environment in which I frequently copy a certain schema.
When I'm done with the copy, I will use OracleEM to drop that user/schema.
My problem is that this does not seem to ...
3
votes
2answers
213 views
SQL Server 2005: Full-text search space requirements
Is there a way to calculate the physical drive space required for a full-text search catalog? Space is cheap, but I'd like to know what I'm getting into.
I'm looking at a table of about 200 articles ...
8
votes
2answers
311 views
Strategy to handle an SQL Server DB with too many files (BLOBs) in it?
Scenario:
SQL Server 2005 database servicing an ASP.NET application (on a separate web servers).
Database:
DB has about 5GB of "normal" data in it, and about 15GB of "files" (e.g.: a 200k PDF stored ...
1
vote
1answer
837 views
Freeing disk space after dropped database
I'm working on a dev system, and I have been restoring to a database, say "foo", that I'm using for dev purposes. As I'm working through the kinks, I've just been running DROP DATABASE foo. However, I ...
3
votes
1answer
1k views
How to free up disk space? which logs/directories to clean? [ORACLE 11g]
I want to free up the disk space on my Linux machine. I've drill down the space usage and found that the following directories have a big size
/u01/app/11.2.0/grid/cv/log
...
3
votes
1answer
1k views
Understanding block sizes
My question targets Postgres, but answers might just be good enough coming from any database background.
Are my assumptions correct:
Disks have a fixed block size?
RAID controller can have a ...
1
vote
1answer
146 views
Oracle block usage
I am wondering about a weird deadlock and after checking all other components I am considering it to be a INITRANS problem in Oracle 11.2.
Now three questions arose:
Is there some way of analyzing ...
2
votes
3answers
2k views
Can I specify a different disk for a specific MySQL table?
I use my home machine as my personal database for my hobby analytics project. This machine has an SSD for the main drive where MySQL stores its data. It also has a secondary hard drive that is ...
1
vote
2answers
1k views
PostgreSQL: Query for location of global tablespace?
I have been trying to make our database clients pro-active about not filling up the partition on which the database they are using resides.
As all our clients are on the same host as the database ...
1
vote
1answer
448 views
SQL-Server: sp_spaceused gives zero rows but big dataSize for cleaned table
After cleaning my table with DELETE FROM MyTable (and executing DBCC shrinkdatabase('MyDB') should that matter) I run the statement EXEC sp_spaceused MyTable. The results confuse me:
tableName ...
5
votes
2answers
2k views
How to delete a Backup from a backup set in SQL Server 2008 R2
The title pretty much sums it up. We are running out of space on our backup disks, and need to remove old backups out of the set. I can't seem to find any information on this.
9
votes
5answers
408 views
SQL Server Backups - A couple of questions
We run our weekly backup job at 9pm on Fridays and we are experiencing a couple of issues with regard to disk space (which gets perilously low at times) and performance. We're looking at ...
4
votes
1answer
178 views
Is there some drawback to define SPARSE columns?
I have a table which has a lot of NULL values in columns. But some columns don't contain NULLs at all (although nullable). Is there some drawback to declare all of these columns as SPARSE?
2
votes
1answer
6k views
How to Recover an InnoDB table whose files were moved around
So I have a test db server that was setup on a replication stream. Over the name an optimize came through that quickly filled up the space on the slaves datadir. Mysql dutifully was just waiting for ...
2
votes
1answer
425 views
What are all the reasons/possibilities that may fail to release disk space occupied by TEMPORARY table?
We're using PostgreSQL v8.2.3. Ours is a web-based application and we're using pgpool-II v 2.0.1 purely for connection pooling (we
don't use other features of pgpool like Replication, Load Balancing, ...
10
votes
3answers
987 views
Why might a table's data space take up 4x the size of the raw data?
I have a table with 490 M rows and 55 GB of table space, so about 167 bytes per row. The table has three columns: a VARCHAR(100), a DATETIME2(0), and a SMALLINT. The average length of the text in ...
2
votes
2answers
467 views
PostgreSQL: Separate tables vs single table to perserve disk space?
I have 2 tables with the below schemas with equal number of rows. When I run the SELECT relname, relpages FROM pg_class ORDER BY relpages DESC command, they show up as 23GB each even though the data ...
4
votes
4answers
2k views
Empty strings in VARCHAR(MAX) consuming space which cannot be recovered
I have a table with a non-nullable VARCHAR(MAX) column where every row contains an empty string (third party database so I can't change it). I see a huge amount of space use, over 15GB for 1 million ...
4
votes
2answers
440 views
Index Generation in Postgres
We have a database with a single table made up of around 700 million entries.
We update the database by adding new entries on a server then transfer the server to the production server using pg_dump:
...
7
votes
1answer
851 views
PostgreSQL: Disk space not released after TRUNCATE
I haveTRUNCATEd a huge (~120Gb) table called files:
TRUNCATE files;
VACUUM FULL files;
The table size is 0, but no disk space was released. Any ideas how to reclaim my lost disk space?
UPDATE:
The ...
