For questions about the persistent storage of database data.

learn more… | top users | synonyms

9
votes
1answer
416 views

Storage snapshots for consistent backup of postgresql - different data and log volumes

We are running many Linux VM's in a vmware/shared storage environment, each running its own instance of postgreSQL (a mix of 9.0 and 9.3). Currently, the entire VM sits on a single root partition/...
1
vote
1answer
42 views

IBM FlashSystem V9000 storage - should the os, mdf and ldf and tempdb be separated onto different volumes?

Is there any benefit that justifies separating the os, mdf, ldf and tempdb onto separate volumes? RAID and redundancy is already included. Connection options to the host are: 16 x 16/8/4 Gb Fibre ...
1
vote
1answer
34 views

ASM and IPv6 Compatibility

In the whitepaper mentioned below, Under 'Limitations' it says ASM and fan based notifications are not supported by IPv6 in Oracle. I'm just curious what ASM has to do with ipv4 or ipv6 or ipv4? ASM ...
3
votes
0answers
65 views

Different Disk Drive Same Backend Storage

I have a database running on a VM which is getting hammered during a large load, in particular I can see waits of WRITELOG happening. My initial thought is to split the files out on to their own ...
2
votes
0answers
432 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 VM'...
2
votes
0answers
287 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 ...
1
vote
0answers
37 views

SQL query fills up RDS free storage space after upgrade to MySQL 5.7

After the upgrade to MySQL 5.7 the execution of a SQL query fills up the free storage space. The upgrade was performed through the AWS console, selecting the automatic procedure to upgrade the RDS ...
1
vote
0answers
20 views

Is there a way to store more than 65KB in NDB engine?

I have to store some json files that are larger than 64KB so they cannot be stored in TEXT fields in NDB engine. Is there a practical way to solve this problem? 2 points: I have no option but to use ...
1
vote
0answers
84 views

Storing and searching user location using latest MySQL 5.7 spatial features

I want to use MySQL spatial features to store user location. I have read about MySQL spatial geometry data type. According to this article this works very well in MySQL 5.7 http://mysqlserverteam.com/...
1
vote
0answers
71 views

SQL Server index rebuild cause database growth

I have a 80GB database with about 20GB of indices size. Whenever I build the indices online the database file will grow to gain 20GB of unallocated space, and if the unallocated space is less than ...
1
vote
0answers
26 views

Split Mirror Backup in db2

In my database apart from storing the daily backup, the disks are getting used for other purposes also. So how can I do the disk mirroring for Split Mirror Backup if I don't use external storage?
1
vote
0answers
42 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 ...
0
votes
0answers
7 views

Diskspd and high latency

Hope someone can help here. I am trying to understand the high latency reported by Diskspd. Please help how to investigate this further. OS : Windows server 2008 Local disk, Not SAN or NAS RAID :...
0
votes
0answers
29 views

MySQL Storage Engine and Memory

I recently found out that, the databases does not have standard architecture(data model), some of them are, No relationship between tables(entities). No indexes defined. Only integer and varchar ...
0
votes
0answers
14 views

Default Space in WAMP

What is the Default Space for MySQL in WAMP SERVER? We are using MySQL as the back-end for our application development, and it is running out of space. How can we increase the disk space? Or are ...
0
votes
0answers
32 views

What is database storage structure?

I'm curious that there is a term "storage structure" in the context of databases, but there is no clear definition to be found in the textbooks. Wikipedia https://en.wikipedia.org/wiki/...
0
votes
0answers
23 views

Is it possible to use secondary indexes with Mariadb and Spider?

I'm working upon a Mariadb cluster with 3 data nodes + 1 master node running Spider storage engine. Running queries from spider node, I cannot force data nodes to use secondary indexes, as happens ...
0
votes
0answers
36 views

MongoDB: poor compression rates

I'm importing a small set of data from Oracle in MongoDB. Basically, I have a table which is about 1Gb in Oracle (avg_row_len x nb. rows, i'm not counting the index sizes. Though data is compressed). ...
0
votes
0answers
37 views

Rule of Thumb on OS Free Space

This may be a difficult question to answer, but I have a PostgreSQL database running on a Linux server with 1.3 TB of storage. I'm currently at 73% utilization of storage space with a slow but steady ...
0
votes
0answers
29 views

Storage strategy for polynomials

What is the most space efficient way to store arbitrary length univariate polynomials? I have a large amount of polynomials that look like 3*x^7 + 12*x - 13 9*x^32 - x^14 + 2*x^3 - 9 ... Each ...
0
votes
0answers
162 views

How calculate per tenant disk usage in a multitenant database with tenant_id columns?

I would like to provide forum hosting as a service, for forum software I'm developing. The data is stored in a PostgreSQL database, in tables with a forum_id column. That is, all forums share the same ...
0
votes
0answers
70 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. ...