Database administrator

learn more… | top users | synonyms

0
votes
2answers
221 views

How can delete an orphaned temporary table on Mysql Innodb?

I was issuing an Alter table statement and suddenly the server crashed, Now i can not run any alter table to that table because it shows me the error 1050 and it says that a table named #sql1504d ...
2
votes
1answer
63 views

Ways to Reduce Database Size and possibly improve performace. Untouched enviroment.

I am new to an environment. The Databases are virtually untouched by a seasoned DBA. I am looking for ways to reduce DB size and possibly improve performance. Unfortunately, I only have WEb edition ...
0
votes
1answer
395 views

Slave not getting replicated SERVER_UUID error

Unable to start replication Master-Slave, I have searched a lot for this but unable to get the Server-UUID of both the server. Do we have any solution for this. Scenario: I have created new slave ...
0
votes
1answer
31 views

Unable to connect to mysql remote

I am struggling to connect MySQL database with my application, I am having the following set up 3 Applications running in cluster mode and trying to connect with same DB. MySQL database running on ...
0
votes
1answer
70 views

For multiple mysql instance , fresh download required when one exist?

i need multiple instances of Mysql on same server. I had been through many links , but i confused here : What i have : MySQL 5.6 is already installed on my windows server A. Installed at : "C:\...
0
votes
1answer
152 views

What is contained in the controlfile of oracle database?

As we all know that controlfile contains datafile locations and redo log locations along with their names.It also contains dbname,timestamp,checkpoint info,log sequence number,rman backup info.In ...
0
votes
1answer
49 views

Mysql JOIN with 25million rows

Recently I got stucked with a table where its grown to +25million and I have got a query that's doing a JOIN on it. The query take 2.5hours to execute even though I got Good 96GB RAM and RAID10 with ...
0
votes
1answer
71 views

Can any one Explain me What is the Use of Cascading Replication in Postgresql?

What are the advantages of cascading replication in PostgreSQL. I have done Testing On this With three nodes. M1---->S1----->S2 What is the Use if My master(M1) goes Down(failover). Where the ...
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 ...
1
vote
0answers
36 views

Postgresql with just index storage

I have a PostgreSQL table with a key (bigint) and a value (double). The table has tens of billions of rows. I have a single btree on the (key,value) for aid lookups by key. The table is never updated. ...
1
vote
0answers
54 views

A call to a package procedure fails after upgrade to PSU24

We have just upgraded an Oracle Database 11.1.0.7 from PSU6 to PSU24. We have set a AFTER SERVER ERROR trigger to track application errors a while ago and checked its history table. Summary We see ...
1
vote
0answers
48 views

Identify a blocking process in MongoDB

I have a single MongoDB instance is performing quite badly. I noticed that db.currentOP().inprog.length quite often becomes quite big, sometimes even goes up to 100. When I drill down to the actual ...
0
votes
0answers
15 views

Cannot create a database connection SQL Developer

I will try to explain the current situation in the best possible way. Well, I got a VM with SQL Developer already installed but could not run properly. After some reasearch, I solve the problem ...
0
votes
0answers
41 views

How Can I move data among the datafiles

I have almost 1 tb of database which have 4 datafiles in primary file group that have data unevenly A-data file has 300 gigs B- has 430 gigs c- has 200 gigs D- has 12 gigs what should I do in order to ...
0
votes
0answers
21 views

PostgreSQL Redhat Cluster Implementation(Active-Passive) With Streaming Replication setup For DR failover

We have a scenario Where Customer is looking For Cluster kind of solution with DR failover Setup. I am Planning to suggest the attached Architecture with customer. Few Clarification as per ...
0
votes
0answers
35 views

postgres vacuuming query: value of datfrozenxid increased after vacuuming

I checked the datfrozenxid values, and performed "vacuumdb --analyze -a", Normally postgres, template1 values are very high and they return to around 1,000,000,000 after vacuum. But I found something ...
0
votes
0answers
12 views

dba_tab_partitions we have all columns except MAXVALUE column

i want to cross check all partitions were created properly or not according to the timestamp, TO_DATE(' 2013-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', is there any way to cross check partitions??? ...
0
votes
0answers
59 views

Error 1129: Host '' blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'

When I run a python code which connects to mysql, I see this error; "Error 1129: Host '' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'". Here is what I have ...
0
votes
0answers
167 views

Teradata 15: install TTU 15, The installation of Shared ICU-32 bit appears to have failed

I downloaded Teradata Tools and Utilities (TTU 15) from Teradata support site. After I uninstalled the TTU 15, now I cannot install it again! I am using Windows 7 Enterprise version. Here is my ...
0
votes
0answers
82 views

create table in a different schema

I am trying to create a table on a different schema without using "create any table" privilege. I have an application user/schema. TABLESPACE_NAME USEDMB MAXMB ----------------...
0
votes
0answers
17 views

AlwaysOn Availability Groups with Different subnets

Am Successfully configured the Always On with different sub nets. but I have one small glitch here every time am manually flushed out the DNS (command prompt ipconfig /flushdns) while fail over is ...
0
votes
0answers
141 views

Teradata how to create a sysdba super user

I am relatively new to Teradata. I was told by my Teradata consultant to create a super user or a role for DBAs to use, in stead of using DBC. I tried the following syntax, but kept getting errors: ...
0
votes
0answers
26 views

events not getting completely written in binary log file MySQL 5.0.32

referring this question : Records not getting replicate from Mysql 5.5.32 to MySQL 5.6 i found that binary log files which has been created at master database server , i see following surprising ...
0
votes
0answers
229 views

MySQL replication: most important config parameters on slave for performance on master server?

This query is almost the same as this question. But in this case, a configuration to make the master perform faster or just the same. Case We have a Master-Slave setup on a Mysql 5.0.77 - MariaDB 5....
0
votes
0answers
27 views

SPExecuteSQL;1 keeps executing internally

Having a major issues with this procedure called SP_ExecuteSQL;1. It keeps executing internally in SQL Server 2000 with high utilization of CPU. When I pass its SPID in DBCC inputbuffer it shows as ...
0
votes
0answers
50 views

Restore data from MYSQL Bin log

I am trying to restore some data from mysql bin log file. But when it encounter some special characters, query gets break and I am not able to continue after that. Is there any way to handle special ...
0
votes
0answers
37 views

Can it Possible to do Mysql Active - Active Replication between Redaht linux 6.4X and Ubuntu 12X?

I have small doubt regarding Mysql Active-Active Replication. Can it Possible to do Mysql Master-Master (Active-Active) replication in Mysql between Redhat Linux and Ubuntu? Thanks & regards, ...
0
votes
0answers
749 views

A issue on DB link between Postgres and Oracle?

I am trying to create a DB link between Oracle and PostgreSQL using OCI. CREATE DATABASE LINK oraedb CONNECT TO hr IDENTIFIED BY 'hr' USING oci '//127.0.0.1/xe'; CREATE DATABASE LINK When I ...
0
votes
0answers
499 views

Creating and tuning a materialized view in oracle for use by Cognos BI

I am currently in the middle of a Cognos BI implementation and am having difficulty in tuning a view in order for SQL Server to select its contents for fulfilling the incremental load in a timely ...
-1
votes
0answers
20 views

How to prevent database server from lagging when auto back up of data to backup DB is in progress?

We have a windows 2008 r2 server with MSSQL server running on it as our application's database server (we use it 24 hours). It has auto back up every midnight (as it is the time when less users are ...