The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

0
votes
0answers
105 views

Differing AUTO_INCREMENT values between 5.1 vs 5.6 slaves

I have a MySQL 5.6.21 slave and a MySQL 5.1.73 slave that are both replicating from the same MySQL 5.1.73 master. I noticed that for several of the tables ( I said several because when I try to rerun ...
0
votes
3answers
147 views

Database Design for Paper Submission System

I am learner of Database design, I want to design a database for a journal paper submission system in which one paper can be submitted by one or more author. I have initially two tables Author and ...
0
votes
0answers
101 views

Last synchronization time between master and slave (replication)

During replication process where a Master is connected with slave. Some times connection between these two goes down. Any options to get the details of the last synchronization time?
1
vote
1answer
94 views

many Servers of SQL server 2012 needs mirroring

I have two SQL server 2012 instances and I want to configure mirroring between the 2 servers with database. My questions are: How can it automatically change host of one if the other one was dropped ...
2
votes
3answers
1k views

How to enable windows authentication on server that is not part of domain

We have an SQL server instance running on a standalone server (not part of the organizations domain network). Is there any way that we can use windows authentication to logon to sql server without ...
0
votes
1answer
967 views

Best Innodb Buffer Pool Size for 8GB RAM?

I found out that my MySQL server is configured with only 128MB for innodb_buffer_pool_size. That is not enough considering that I have a 8GB RAM server. It hosts MySQL server and an Apache/Catalina ...
1
vote
1answer
4k views

DB2 Commands — Different ways of stopping database

I'm hoping to get a more in-depth explanation of the following DB2 commands, which all relate to stopping the database in some way, and how they differ from each other. How do DBAs think about these ...
0
votes
1answer
141 views

Copy database from one mysql sever to another mysql server

Following are the details of the database and server: Server1: Host Name: abc Port Num: 01 database: test Server2: Host Name: xyz Port Num 02 database: spareparts userid: spts password: abcdefgh@123 ...
1
vote
1answer
460 views

Accuracy of mysqldbcompare vs other tools like pt-table-checksum

I was curious to hear what everyone's experiences are with using mysqldbcompare vs pt-table-checksum( from Percona Toolkit ) to find the differences between two MySQL databases. I have heard that pt-...
0
votes
1answer
61 views

Index file - size changed

I realised today that my index file(which is about 250GB) is smaller than yesterday for about 7GB. Everything, I done in the meantime, was index rebuild. Is it possible that index rebuild is the ...
0
votes
1answer
43 views

Database state set to an earlier state before creating new indexes

This is a remote server (SQL Server 2008). We are trying to get benchmarking of some stored procedures. One stored procedure was taking avrg 44 seconds, we have checked this approx 20 times for a ...
3
votes
2answers
392 views

Stored procedure takes 18 seconds on first load, 0 seconds on subsequent loads, waiting several minutes makes it slow again

I have a stored procedure that returns a lot of data for a business dashboard. On first load it takes 18 seconds, after that it takes 0 seconds, even if I change the input parameters at random it ...
0
votes
2answers
238 views

Restore Database with Multiple Restore commands

For automation, I have to dynamically construct the restore commands and thus I have created a script. A .bak file is created on a remote server and I receive it daily. The script builds the restore ...
0
votes
1answer
157 views

How to solve “Servlet error” when using database control in Oracle 12c?

When I want to use Oracle 12c GUI, I receive an error as written below: Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in ...
0
votes
0answers
34 views

Proxy user for DDL

I'm experimenting with the proxy user feature of oracle. My sample: user_a has only object privileges and user_b has only system privileges. user_b is allowed to log in as user_a. So DDL and DML are ...
0
votes
2answers
282 views

Cannot find .bak in a backup file [closed]

My database backup works well or you can see the backup in the backup file. But the backup has no format of a backup file. I mean you cannot see the .bak associated with it, therefore unusable by ...
-4
votes
1answer
157 views

When you type an SQL query in interpreter, what does happen? [closed]

Actully this question is asked in an interview from me . When you type an SQL query in interpreter, what does happen? How is the query processed?
5
votes
1answer
1k views

How do I track logins, connections, user accounts, queries, …?

I am a BI person who has been asked to step in and pretend I am a DBA. I am not a novice with databases but AM a novice at the admin type stuff. We have a SQL Server database that is going to be ...
0
votes
1answer
68 views

Oracle dataguard - Redo apply

In a low bandwidth environment when a transaction commits that generates a large amount of redo data will cause other independent transactions to slow down. This is because the redo data of small ...
2
votes
1answer
97 views

Create failed for Availability Group 'AGN'

I tried creating availability group (AOH) many times but no luck , It got failed every time. Please help me on this case. I configured Windows cluster (Name as 'WINCLUSTER') with two nodes. They are ...
0
votes
0answers
270 views

SA Admin SQL-Server 2012 x64 keeps changing constantly

I know this is a newbie question, but really I can't find some precise info on this issue. I'm trying to figure out how to create a new user with admin server role on SQL Server 2012 x64. I mean, I ...
1
vote
1answer
41 views

different log file for master and beta mysql

Hi i am facing a problem while shipping my database log I have three database server dev, beta and master and i maintain log files for dev on github and every log file has a version given to it like ...
5
votes
1answer
176 views

What is the best storing device for DB transaction log?

I'm using MySQL with InnoDB storing engine. Transactional log is placed to dedicated HDD. Still as it is HDD atopsar shows big load (>50%) to this HDD because of big amount of small IOs (about 50 ...
1
vote
1answer
4k views

How to reclaim the unused Space in a database

The database is almost of size 55GB. This database should have never grown to this size as some of the maintenance jobs were not running. I have deleted almost 30GB of data. Now the database size is ...
0
votes
0answers
3k views

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor at the time of switchover using data guard broker

I have a oracle data guard setup with nodes - one as primary and other as physical standby. I also, have configured the data guard broker on it. The problem is when I tried to switch over , I just ...
0
votes
1answer
46 views

Who should own the staging database right

At my company we are re-assessing which developers will take on the deployment for xyz ticket. At the moment when a developer is done with his ticket, a deployment ticket is created and another ...
0
votes
0answers
102 views

sql server linked server does not consider indexes [closed]

We have a query with a join between two tables. The first is in the database and the second is in another listener, connected by a linked server. I am executing this query in SQL Management Studio ...
-2
votes
0answers
24 views

increasing Mysql DB Size and Server Size [closed]

I have installed xampp on my windows machine, i'm using MySQL, How to increase the size of mysql server and databases in it? Kindly help me..! Thanks in advance...!!!?
1
vote
2answers
275 views

Monthly report by time [closed]

I work in a parking company. We need a report of monthly vehicle exits by time. select hour(datetimeout) as 'dateout',count(*) from to_leaveveh where datetimeout between '2014-09-01' and '2014-09-...
0
votes
1answer
24 views

Is it possible to run a trigger on Table Creation in MySQL

Simple Question. Is it possible to create a Trigger that runs everytime a Table is created. The goal is to create a metadata table for each table, but I can worry about dynamically passing the table ...
1
vote
2answers
255 views

Relational Model vs. Database Products [closed]

The formal Relational Model (logical level) for databases is not exactly the same thing as you get with MySQL, Oracle or other major products / implementations of ‘relational’ database management ...
2
votes
2answers
665 views

Duplicate login details per user in error log

Being able to view details of who successfully logs into a database and which user's login failed via the error logs is a good thing. However I have a scenario that I need help with: For some reason ...
0
votes
0answers
2k views

Log full and an Active_transaction on database

I have limited access to this server eg I cannot SELECT * FROM sys.dm_tran_session_transactions for example I, perhaps foolishly, ran this query to insert some test data... begin transaction update ...
0
votes
1answer
2k 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
2answers
5k views

DB2 - how to safely blow away database on linux?

I'm using (I believe) 10.1.2, on CentOS 6.5 (for sure). The underlying problem I have is that the database upgrade package prepared in house isn't working for me, in at least the sense that the ...
0
votes
2answers
1k views

MySQL: How to fetch nth level child menus of a parent menu

I have a menu which is parent of multiple menu items and each child menu has their own child menus. This pattern is continued till 5-6 vertical hierarchy level. I don't want to write a query which ...
1
vote
0answers
46 views

Restore postgresql database from remote sql file

I would like to know if it's possible to restore a database from a remote sql file. The problem: - Working with PostgreSQL 9.2.4 - I have an small remote server with 10GB left in storage - I have a ...
0
votes
2answers
231 views

The dump database on a SSD disk is slowly restored in SQL Server

I prepared new server for my DB on Windows 2008R2 + SQL Server 2005 SP4. I always estimated time of restore database of a backup as time of copying of the file of a backup at that place where the ...
0
votes
0answers
3k views

Need Help in DFD Diagram for online hotel booking system

Hi friends, I am creating a data flow diagram for online hostel booking system. not sure if i created a correct diagram or not any help would be appreciated. thanks in advance
0
votes
3answers
3k views

SQL Server Create Database File Error

I get the below error running a CREATE DATABASE script... CREATE FILE encountered operating system error 5(failed to retrieve text for this error. Reason: 15105) while attempting to open or create ...
2
votes
1answer
86 views

Is data warehouse monitoring same as database monitoring? [closed]

I have a requirement, where data warehouse population is to be monitored. I am in confusion, and needed a clear picture. Is data warehouse different than database? eg. For monitoring database we ...
1
vote
2answers
117 views

MySQL: How to sync on demand beetwen two database in the same server

I'll like to know if it's possible to have a systeme on synchronisation beetween two database in the same server. I have a production database in my server , i want a dev database (same database with ...
1
vote
2answers
411 views

Need Help maintaining multiple databases for a multi-tenant application?

i need some information about multiple databases for a multi-tenant application ? I am working on a project in which we are maintaining separate database for every company? The Companies Database ...
1
vote
1answer
338 views

Create user to monitor database activity on Postgres

Postgres 9.3 Debian 7 I want to create a monitor user called monitor that the only permission is to run queries to monitor all the database activity. I created the user and it can select from ...
1
vote
1answer
697 views

Beginner questions about SQL and relational algebra

I'm doing some exercices waiting for the exam. I have some doubt. RELATIONAL ALGEBRA These are the table: Newspaper (Cod_n, Name_n, Publisher) Article (Cod_a, Title, Topic, ...
0
votes
1answer
3k views

What's a good workbench tool for sqlite similar to MySQLWorkbench for MySQL? [closed]

What's a good workbench tool for sqlite similar to MySQLWorkbench for MySQL? I'm used to MySQLWorkbench for working with MySQL databases. Now I have some sqlite databases to work with and would ...
0
votes
0answers
314 views

How to change the domain name or IP address in mysql database in every tables

I was using Openfire chat server in Ubuntu, whose IP address was 192.168.1.15. Then, I wanted to move it to other ip (192.168.1.55), so i took a backup of my database. The database I was using is ...
1
vote
2answers
15k views

ORA-01033 “ORACLE initialization or shutdown in progress” caused by ORA-10567 “REDO is inconsistent with data block”

I faced an error while logging to database with regular user (non SYS/DBA): C:\Users\user>sqlplus tester@orcl ORA-01033 ORACLE initialization or shutdown in progress However I can connect via ...
0
votes
0answers
136 views

cronjob(script) that sends(mail x) the query co-ordinator SID whenever parallels are invoked in queries

i am a junior dba im looking for help with a shell script that needs to be put in the crontab(which runs every 15min) which sends(via mail x) the query coordinator session id(SID) and other details ...
3
votes
2answers
93 views

Designating databases to certain CPUs

SQL Server 2012. AlwaysOn Cluster with two nodes, each has 4 cores We are consolidating SQL server instances and moving bunch of databases from various locations to a single cluster which has two ...