For questions about the persistent storage of database data.

learn more… | top users | synonyms

1
vote
1answer
27 views

Copying database to different hard disk

Total noob at database administration here, excuse my ignorance. I have a server running a Rails application that's using PostgreSQL. The database is saved on drive /z/, which seems to have filled ...
1
vote
1answer
34 views

Dividing data from one table to multiple storage

I have the following tables: [Table_A] [Table_A_Changes] The two tables are pretty large (more then 50GBs). The first one contains some data, and the second one records' changes.The database is in ...
0
votes
1answer
35 views

Automatic change of “initial size” of a database?

I just had a problem : days ago, on one of my client's databases, the LDF file suddenly grew up to 100% of the disk capacity. .TRN backups are correctly done every 15min (I don't think reducing this ...
0
votes
0answers
39 views

MySQL - Database has huge overhead but tables don't

I have some problems with two MySQL databases. The databases have huge overheads but none of the tables do. When I recreated the tables the overhead just reappeared aswell. I hope you can help me. ...
0
votes
1answer
46 views

What are the problems with sharing an Access database through online storage service, like Dropbox?

I have a desktop database I created in Access. I'd like to share the database with a single collaborator, who can have full privileges to the database (table access). However, my collaborator is much ...
1
vote
1answer
30 views

Are Blob Sizes Fixed?

I'm using sqlalchemy to store objects in a database. The kind of object I'm creating is unknown until run time. I could be storing something as simple as a string. I could be storing a jpg. I ...
0
votes
1answer
89 views

SQLIOSIM fails to run when using UNC path

I'm trying to run SQLIOSIM on NAS cluster's NTFS shared folder. Here's the command line: sqliosim.com -dir \\c16\vol1cifs -size 512 -d 600 But it repeatedly fails to create files during the ...
0
votes
1answer
44 views

Best open source DB technology to store and query large, sparse matrices [closed]

I have a large vector space model, in which each point is a multi-variate observation. In other words, I have a large number of pretty large records, mostly of ints and floats. I started with ...
0
votes
1answer
38 views

Proposal: MySQL blob handling revision [closed]

Why does MySQL store blobs in the direct table rather than off to the side so that if it needs to read the corresponding stuff it will read the stuff off to the side? Essentially it would create its ...
0
votes
0answers
27 views

Optimal layout strategies for Time-Series using Columnar storage

In the context of time-series and specifically columnar storage systems. Question: What are the processes or heuristics that are used to determine how best the columns of contiguous values be grouped ...
0
votes
1answer
43 views

Store logging in separate or existing database?

In a .NET WebForms project we want to log certain actions in a database for a year. The estimate is that the log will have a maximum size of 1GB (20.000 records per day of 10 fields) that will ...
0
votes
1answer
36 views

Is there any relation between BSON storage for mongoDB and MySQL storage?

I am working on an application where I need to make analysis that what will be the storage size of BSON structure if same data is stored which is stored in MySQL. Basically I am comparing MongoDB and ...
3
votes
2answers
280 views

RAID Storage Technology Outdated? [closed]

I am working on designing requirements for new SQL Server installation. I have been researching disk storage and everything seemed to point to using RAID. However, I found this article, which ...
0
votes
0answers
25 views

Drawbacks of storing files in a database [duplicate]

I have developed a web application, with a page page that uploads pdf files and stores them in a database table. Is there any performance decrease or other drawbacks of this storage approach? Is there ...
0
votes
0answers
90 views

Cluster with shared storage

I actually use MariaDB Galera Cluster with 3 master nods. Workload is about 70% read, 30% write and it's very important to have consistent data with every select - this is why I choose Galera ...
0
votes
2answers
132 views

PostgreSQL 9.3 - standard_confirming_strings option in postgresql.conf not affecting remote machine

I am updating a program at work that communicates with a postgreSQL 9.3 database. I need to turn off an option in the postgresql.conf file called standard_conforming_strings, so that I can store ...
1
vote
1answer
48 views

Reference implementation of a scalable storage system with strong consistency?

Is there a storage system with these properties? horizontally scalable - can handle arbitrary read and write throughput if you add enough nodes to the cluster consistent, in the sense that all reads ...
0
votes
1answer
28 views

Does database require block storage always?

I was reading the difference between block, file and object storage and I read somewhere that database require the underlying storage to be block storage. Is this true? Can I not install a database on ...
2
votes
1answer
410 views

Partition Style - MBR or GPT

I am setting up a new server and I am designing the server for performance over capacity. Planning the disk partitioning style I would like to use GPT over MBR but am not sure which is best. I am ...
0
votes
5answers
1k views

Is it impossible to store 2^266 records on a database of some kind? [closed]

Each records weighs 52 bytes, is it possible in today's technology if someone had the storage needed? What kind of db would hold the data and will make it possible to retrieve it. An example record: ...
0
votes
0answers
90 views

How to Upgrade from Oracle 10G to Oracle 11G without bringing down the database

I have an Oracle 10G database running on two machines in a resilient environment with shared storage. So when one of our system fails we simply switch the GSS to second database instance. Now I need ...
3
votes
1answer
100 views

Use of integer instead of interval (of one type)

Our DB design presently has a interval column which will only be storing days (no other interval type) so it is making sense to use INT2 (smallint) instead of interval. Reference to documentation. ...
2
votes
0answers
142 views

SQL Server 2012 Database Engine Configuration Storage type Raid [closed]

I just inherited a Server that I have to rebuild for SQL Server 2012, I was wondering what would be the best disk configuration for the database engine. This is what I have: 6 x 300GB 10k: 2 x 1TB ...
0
votes
2answers
135 views

SQL Server storage limits on Azure

Looking at SQL Server maximum capacity limits on here: http://msdn.microsoft.com/en-us/library/ms143432(v=sql.120).aspx Database size can be as big as 524,272 terabytes. Here, you could see VM size ...
0
votes
1answer
130 views

I have delete database from mysql but storage is not freed

I have deleted multiple databases (schema) from mysql on amazon RDS but the storage is not freed, is there anything else I should do to free up the storage? I have a mysql database that the total ...
0
votes
1answer
110 views

ERP (Oracle) real time backup [closed]

I work in a small company, that runs an ERP that holds about 600MB of data. My task at hand is, to find a way to always have real time backup of the erp (Oracle 11g) that can be retrieved easily (so ...
1
vote
0answers
33 views

Data mirroring suggestions

On my test environment, I have a SQL 2012 2-node physical cluster that accesses a common iSCSI storage on a separate Windows Server 2012 box. What options are there if I want to backup this storage to ...
2
votes
0answers
131 views

How to use Blob Storage as shared storage in a Windows Azure Failover Cluster?

In the context of SQL Server 2012 Standard Edition, is it possible to make Azure Blob storage available to a SQL Failover cluster directly as a shared SCSI resource on a Windows Cluster composed on ...
1
vote
2answers
136 views

Independent pairs of RAID 1 is superior to RAID 10 [closed]

I am rather new to databases. I was reading up on RAID Storage and it seems that the consensus is that RAID 10 is RAID 10 is best is terms of performance and redundancy However at the end ...
0
votes
1answer
100 views

What are the low-level storage requirements? [closed]

Typically, DB engine fulfils some request and any modifications must stay persistent (you call it durability). How is the persistence is ensured/assumed? Which requirements are imposed on the HW/OS? ...
2
votes
1answer
132 views

SQL Server data files and RAID

I have a server with a RAID1 volume (OS + apps) and a RAID10 volume (database). The RAID10 volume has 6 physical disks. Should I split the SQL Server database into 6 datafiles (one for each physical ...
0
votes
1answer
43 views

Allocating Filegroups and Storage

I have upto 10 databases running on a single SQL Server instance on a single server. I have read about best practice for storage and concluded the following... 1) Transaction Log on own RAID array ...
0
votes
3answers
91 views

SQL Server RAID Storage [closed]

I have been reading about recommended SQL Server storage and RAID 5 or RAID 10 controllers have been recommended. On my existing Database server I can see 4 Storage controllers under Device Manager. ...
0
votes
2answers
199 views

What is the default size of text field in Postgres?

In the official documentation (http://www.postgresql.org/docs/9.1/static/datatype-character.html), it states text field is variable unlimited length. I wonder what is the default size of this field ...
1
vote
4answers
363 views

What is a Scalable Storage Mechanism for large TTL data collections

We currently have a legacy webservice that stores each xml request/response in Sql Server. The data only needs to persist for 3 days before it is considered expired. Sql Server is not good at deleting ...
1
vote
2answers
134 views

Single disk for Data, System, User, Temp and Backup when installing Fail Over Cluster?

I have a Windows cluster with two nodes. I am trying to make Fail Over Cluster using SQL Server 2012. On both nodes there is 2 TB storage available which I can access as: ...
3
votes
1answer
134 views

Help with Cybernetics SAN Configuration

There are tons of articles out there recommending RAID/ LUN/ drive configurations for SQL Servers, but most leave me still questioning as they usually state "it depends" and for this reason I'd like ...
1
vote
1answer
302 views

Need a solution to store cheaply a big MongoDB collection

We have the typical problem of Twitter's timeline tweets, or Facebook profile's news: we need to show the users only the new information (storing them in a fast db), and put all the old ones somewhere ...
0
votes
1answer
241 views

Help with Postgres 9.1 data import (is 4x expected data size, 4x slower than MySQL, and index still needed)

I have 25 billion <int, int, float> rows that I'm trying to import into Postgres, and after 77% of the data being imported, the Postgres data folder is taking up 840GB, about 4x the storage ...
2
votes
1answer
100 views

Meaning of SQLIO output “counts per second”

I realise that my question isn't strictly 'database' but I know that a lot of DBA's will use the SQLIO tool to check I/O performance on their systems so I'm hoping that somebody here will be able to ...
2
votes
0answers
171 views

always on availability group with different speed disks

I'm looking to set up SQL Server 2012 installation with an Always On Availability Group, where the 'passive' replica will be hosted at another site on the WAN and using synchronous data commit - the ...
0
votes
1answer
132 views

How would you track DB storage use and then extrapolate it?

I need to track the size of various DBs we have, then see it's growth rate so that we can guess where it will be at certain times. I'm using Oracle 11g first, but will eventually be applying this to ...
3
votes
1answer
650 views

How to determine Oracle LOB storage footprint?

With SECUREFILE storage I can specify whether I want compression (and the level of it) and deduplication, and it's all a trade-off between time and space. Timing is fairly easy to profile but what's ...
1
vote
1answer
190 views

Any way to estimate the required space for a SQL dump file?

I want to import a Wikipedia XML dump file into MySQL. The uncompressed XML dump file is 65GB. Does this mean I should free up almost 64GB in the MySQL data path? Is there any way to estimate the ...
3
votes
1answer
185 views

How un-clustered is a CLUSTER USING table in PostgreSQL

I have some tables which benefit greatly from CLUSTER ON/CLUSTER USING in Postgres SQL: # CLUSTER table USING index_name; # ANALYZE VERBOSE table; # CLUSTER VERBOSE; A maintenance task periodically ...
4
votes
1answer
130 views

Are database query optimizers aware of storage performance differences?

As I understand it, the query optimizer in SQL Server (or any other RDBMS, really) isn't aware of the performance of the storage underneath the database, and will make decisions as if all storage has ...
1
vote
3answers
691 views

do MYSQL views occupy physical space?

do MYSQL views occupy physical space? Or in other words, is a MYSQL database limited to a certain number of views?
-1
votes
1answer
66 views

best database for a real estate system [closed]

Which is the best database suits for a real estate system. Considering the storage space, security, crash recoveries, speed etc. There will be around 1000 fields and trillions of rows!!!
3
votes
2answers
1k views

Multiple SQL Server data files on same SAN disk

I'm currently in the process of creating a new database, and have previously only ever used a single data file and a single log file. I've done some research online regarding the benefits of multiple ...
6
votes
3answers
4k views

Stop SQL Server service(s) before defragmenting drive?

Our production SQL Server 2005 database's data files live on a separate physical drive, which Microsoft Windows 2003's Disk Defragmenter tool reports as 99% fragmented. We scheduled a task to ...