0
votes
1answer
610 views

INSERT take too much time

I have in my MySQL DB a few tables Most of the time, I'm only doing INSERT in my db. I have up to 4 connections to the DB, each one inserting into a different table. There cannot be two connections ...
3
votes
1answer
80 views

What inefficiency does sharding & partitioning attempt to address? [closed]

I have never implemented sharding or partitioning, but from what I understand, multiple servers are used to distribute large amounts of data. Is this because of a limited hardware budget or to ...
1
vote
0answers
811 views

PostgreSQL problems on Ubuntu 12.04

I'm having terrible problems with PostgreSQL initialization on my VPS. I followed several tutorials on this topic and nothing made my database server work. I followed these steps: sudo apt-get ...
0
votes
1answer
219 views

Where can I get best resources to learn sql? [duplicate]

I am very new to the databases just have basic knowledge about it. I want to learn sql language and dont know where to start. Please help me to start with it. And what is the difference between ...
1
vote
2answers
100 views

Backup architecture for frequent backups of business critical DB

We've got a database (mysql) driven application which contains business critical information, were looking at building a system that will allow us to backup the db frequently (every 15 minutes, ...
1
vote
1answer
122 views

Mongo db and sharding / replica sets concept questions

I have few questions about sharding and replica sets: I am planning to write important logs to a sharded environment. about 100 million rows in a day, If I will connect to a single MONGOS process , ...
1
vote
2answers
43 views

Multiple “model” DBs — or db creation 'profiles'

I know you can't actually have multiple 'model' DBs on the same server instance. BUT, I'd like to have something almost like it. Basically, we have a business model where each customer is its own DB, ...
4
votes
1answer
131 views

redundant foreign keys in PostgreSQL - are there any indexing benefits?

Note: this is not the same as this SO question which is about adding redundant information in the tables themselves. Does the final statement in the below series of statements buy me anything in ...
3
votes
1answer
161 views

Enforcing constraints “two tables away”

I ran into some trouble modeling an electrical schematic in SQL. The structure I'd like to capture is part ←────────── pin ↑ ↑ part_inst ←───── pin_inst where "inst" is short ...
1
vote
1answer
58 views

What problem prevents well defined behavior of a foreign key on a non-unique column?

In my noob opinion, it strikes me that in a serialized environment, this shouldn't be a problem. Is that correct? If not, please explain to me why a foreign key's behavior on a non-unique column is ...
0
votes
2answers
290 views

Configure postgresql recovery again to be slave

I completed a replication setup using PostgreSQL. Everything was working fine, so I proceeded doing a test by bringing down the main database and promoting the slave to be new master (via touch ...
4
votes
0answers
219 views

User locking tables without privileges [closed]

This is a restatement of a question asked on the GIS Stack Exchange here. Although it has GIS-specific elements it may be be a more general PostgreSQL effect. I have a PostgreSQL 8.4.4 database ...
1
vote
1answer
753 views

MONGODB primary became secondary after servers restart

I had this config before restart: { "_id" : "rs0", "version" : 5, "members" : [ { "_id" : 0, "host" : "Ubuntu12041vanilla:27017" }, { ...
1
vote
1answer
908 views

Use MDX to select Dimension-Members instead of Measure Values

Is it possible, with MDX, to select Dimension Members instead of Measure Values? Here is what I currently do (simplified): SELECT {[Time]...} ON 0, {[Gender]...} ON 1 FROM [Cube]; Result: ...
0
votes
1answer
120 views

Unable to re-install an instance using the original instance name

We are trying to uninstall and re-install a 2008R2 instance. We have uninstalled the database engine but when we tried to re-install it we got the error "Original instance id\name in use". The ...
0
votes
2answers
262 views

What is the performance difference between IN (42) and id = 42 in MySQL?

Are there any performance differences between SELECT * FROM table WHERE id IN (42); and SELECT * FROM table WHERE id = 42; ? The question is about just supplying a single value. The ...
8
votes
2answers
883 views

Is adding index on bit column significantly slow down inserts?

I have a table with about 1 million to 5 million records. Small part of that records have one of bit column set to 'TRUE'. Need to fast find that records. I think that index can speed up searching on ...
0
votes
2answers
304 views

Tips on using SQL access advisor in Oracle

Please share how to use oracle SQL access adviser for single or multiple queries. you can assume that we know the sql ids for the queries we are interested in.
0
votes
1answer
237 views

Why am I getting an error in execute immediate command in oracle 11g?

I was just testing an anonymous code which I wrote for audit trail It's just a sample for test. However I am getting this error: [Error] Execution (1: 1): ORA-00984: column not allowed here ...
1
vote
0answers
266 views

Deny permissions for master in SQL Server

I created a new database on a SQL Server 2008 R2 instance and a login/user for it. I have set the user to db_owner so he can't view any other databases on that server but he can see and query the ...
0
votes
1answer
71 views

Beginning Data Warehouse Design [closed]

I am beginning to develop a Data Warehouse. The data does not already exist in a relational database. Instead it will be sourced from various 3rd party vendors. The data requirements have been drawn ...
0
votes
1answer
746 views

mongodb memory leak or big collection?

mongo 2.4.6 x64 RAM 24 GB With normal work memory consume around 10GB. After that we started read data from db (create archive raw data) memory consuming up to 90% of all memory trough 5day. And go ...
1
vote
0answers
82 views

In SQL Server sp_cursorprepare/sp_cursorexecute run extremely slowly

I'm running an application (Pentaho user console with the Saiku Ad-hoc plugin) which creates a query and runs it using sp_cursorprepare & sp_cursorexecute standard stored procedures. My model is ...
0
votes
1answer
893 views

ORA-30009: Not enough memory for CONNECT BY operation

I have a Linux VM (with CentOS 64 bit) where I installed Oracle Database 11g Express Edition. The database is running, I can use sqlplus and I can create tables and stuff. However, when I run a ...
1
vote
1answer
532 views

Oracle silent install on Redhat Linux (The Global database name was left blank.)

I am installing Oracle 11g in silent mode using the response file that is in the database/response directory. It is three response files in that directory(i.e. dbca.rsp, db_install.rsp and netca.rsp). ...
0
votes
1answer
116 views

How to install postgresql on a server? [closed]

Background: I am busy with an MSc in GIS. It involves using postgresql 9.2 with the postgis extension as the spatial database and QGIS to view, edit and analyse the data. I know postgis is also ...
1
vote
2answers
227 views

What useful information can I get from ASH report which I cannot get from AWR report?

What useful information can I get from ASH report which I cannot get from AWR report? What are the common scenarios in which its better to get information from ASH than from AWR?
0
votes
1answer
80 views

Ask about Inner Join & Union

i want to ask about my script this is doesn't work. i need to help ! SELECT A.*,B.mat_nama,C.mats_nama FROM pengeluaran AS A INNER JOIN(material AS B) ON(A.mat_id = B.mat_id) INNER JOIN(mat_satuan ...
6
votes
3answers
16k views

Converting XML to MySQL tables

I have a large XML file in the following format and I need to convert this file into a MySQL table. Please let me know how can I accomplish this? ~~~~~~~~~~ <host starttime="1392325468" ...
3
votes
2answers
4k views

What is a good way to copy data from one Cassandra ColumnFamily to another on the same Keyspace (like SQL's INSERT INTO)?

Trying to find a way to easily transfer all the rows from a Cassandra ColumnFamily/Table to another. The COPY command, as I understand, is a good option. However, as it dumps all the data to .csv on ...
2
votes
1answer
385 views

Can I configure MySQL replication to break when I run a “drop database” or “drop table” command on the master?

Basically, what the title says. This would enhance the failover quality of our systems, becuase we have run into issues of people thinking that they were in a test environment running drop statements ...
1
vote
0answers
547 views

SQL Server Configuration Manager 2012 - TCP/IP, unable to set IP All = No

I have a 4-node SQL Server 2012 SP1 cluster, and under Network Configuration -> TCP/IP -> Protocol (tab), I am able to switch Listen All from Yes to No. However, when I hit OK (or Apply), I get the ...
0
votes
1answer
74 views

How to structure a database to show data for each USA State and Canada Territory on a Per user basis?

I need to build a PHP/MySQL application. I am a bit confused on how to do the database for a project like I am about to explain though. The end result will be a Map of the USA and Canada. Each ...
0
votes
0answers
908 views

Oracle error: UDI-00018: Data Pump client is incompatible with database version 11.01.00.06.00

I'm trying to use data pump to move the database to a different server with this command: impdp dbuser/dbpsw@dbserver directory=data_pump_dir network_link=sourceDB schemas=EMP But I got this error: ...
1
vote
1answer
531 views

Restore postgres data/tablespace to new tablespace (at new mount point)?

I have a bunch of test/development databases which we currently refresh with production data as-needed using a NetApp filer's snapshot capabilities - we have a production slave with its datadir on a ...
7
votes
1answer
2k views

MATCH FULL vs MATCH SIMPLE

I've noticed a MATCH SIMPLE or MATCH FULL option in phpPgAdmin, but I can't find a description in the docs. How do they function? The default is set to MATCH SIMPLE.
3
votes
1answer
1k views

How can I search SQL Server for maintenance plans that execute specific tasks?

Sometimes certain SQL Server maintenance plan tasks can be problematic, like Shrink Database, Rebuild Index, Update Statistics, etc. I'd like to search for the use of one or more of these tasks on an ...
0
votes
1answer
187 views

Digital content eCommerce schema advice? [closed]

I don't have much experience designing databases, I'm looking for some advice on my design from more seasoned designers/developers. I'm developing a digital content eCommerce store which will be ...
0
votes
1answer
395 views

SUM a new value to an existing value

I have a php script which processes a form with a single input. I want the value I send through input to be added to an existing value in database (mysql). For example in database I have value = 10 ...
1
vote
2answers
133 views

Does this medical database look correct?

I'm pretty new to databases and I'm trying to create some schemas. I've been working away at this one for a while, but I can't help feeling that it doesn't look right. Essentially I have the ...
2
votes
1answer
69 views

Get results ordered by a specific column in a looping way

I have heavy difficulties in getting rows ordered in an special way. Two tables are part in this: Table 1 - WORDS: id | char | word | categoryid (<- id of a row in CATEGORY) Table 2 - CATEGORY: ...
2
votes
2answers
833 views

Bad bind variable in audit trail trigger in Oracle 11g R2

I have been trying to construct audit trail triggers and procedures in oracle and I am facing a problem with bind variables. Following is the code create or replace trigger trg_audit_trail for insert ...
21
votes
2answers
2k views

Why does query error with empty result set in SQL Server 2012?

When running the following queries in MS SQL Server 2012 the second query fails but not the first. Also, when run without the where clauses both queries will fail. I am at a loss why either would fail ...
0
votes
0answers
58 views

Do link servers cache remote database connections?

I have set up a link server from a database server (SQL2008) to my local SQLEXPRESS db, using the actual database as its Failover Partner. I then stopped the SQLEXPRESS service and I could still ...
2
votes
1answer
524 views

How to allow connections to SQL Server with 2 differents ip

I have a small issue here: I have a SQL Server instance 2012 (let's call it INSTANCE) on a cluster. I also have 2 network interfaces for this instance: SQLINSTANCE.my.metwork ...
0
votes
1answer
282 views

How to automatically Reset Query Cache for improve table cache hit in MySQL?

I have a VPS running CentOS 6.4 and 2.5GB RAM, Intel(R) Xeon(R) CPU. Its MySQL version is Server version: 5.5.35-cell. I have two active wordpress sites and two inactive sites (inactive sites use for ...
0
votes
1answer
508 views

What is a bucket in database? [closed]

I was implementing a code that involves a database and buckets. Just wanted to ask what is bucket and can someone describe it with an example? Thanks!
0
votes
0answers
22 views

row locking with innodb [duplicate]

What is the most efficient way to lock a specific row for within a mysql transaction. I am currently using for update using select is there another method that im unaware of? if not are mysql locks ...
1
vote
1answer
69 views

mysql multiple database prioritize innodb buffer pool size

With a mysql instance and multiple databases within that instance is there a way to allocate which database you would like to assign priority to the buffer pool size?
0
votes
1answer
85 views

MySQL: What points should we consider when create composite index

There are multiple views behind the logic of creating composite index in a table. Creating composite index is obvious when we have composite primary key. Beside this, we create composite index on the ...

15 30 50 per page