The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

1
vote
0answers
206 views

Where does a DBA work? [closed]

I want to study for a DBA certification, maybe MySQL or Oracle 11g. I always have worked in small and medium companies. I wonder, in a big company like Google or Facebook, Where does a DBA work? in ...
2
votes
5answers
6k views

Small sample database for practicing database administration?

I'm looking for a portable sample database that can be created from a script has a simple ER model has little data for database administration practicing purposes. I know that there is e.g. ...
19
votes
1answer
28k views

What is the best way to reduce the size of ibdata in mysql?

I have some Production servers whose ibdata files increases in size day by day. It has already consumed 290GB of space. The tables in the servers are mostly InnoDB and there are high read and write ...
6
votes
2answers
4k views

Difference between Row based and statement based replication in Mysql?

What is the Actual difference between Row based and Statement based replication I actually looking in terms of replication effect's on slave. If I am using Row based replication then whats is the ...
3
votes
1answer
1k views

Master and Slave having same id's

I am working as a remote DBA for some of the production servers. There was replication from Master to Slave. There is something changed in the scenario they have made one of the Slaves as master ...
1
vote
1answer
1k views

Problem with MySQL Master/Slave reboot when in replication

There is a master and number of slaves connected to it. Due to some patches, we have to Reboot the Master and Slave. Afterwards, we have to make sure replication is running fine. While doing this ...
3
votes
1answer
2k views

Does `Seconds_Behind_Master` show exact Slave Lag from Master?

Does Seconds_Behind_Master always show the correct number of seconds the slave is behind the master? I have also Implemented the mk-heartbeat replication monitoring. It was showing the other result ...
4
votes
1answer
3k views

What memory should be given to the variables of my.cnf ?

Installing a MySQL server is quite easy. However, after installing, configuring the server is an important task for a DBA. Having 2GB of RAM and 250GB of disk space, how should I tune MySQL server so ...
2
votes
1answer
728 views

BACKUP and RESTORE MySQL Database

I have very specific question. I have seen the instructions on how to backup and restore mysql database using SSH but they barely explain the process when backing up on one server and restoring on ...
1
vote
1answer
92 views

What is QP layer?

From blogs.innodb.com: InnoDB Memcached with Binlog Capability In our earlier Labs release, we presented a MySQL NoSQL solution through InnoDB Memcached Daemon Plugin (see earlier Calvin’s and my ...
7
votes
2answers
16k views

What is the Best Way to create MySQL Master-Slave Replication Setup and Troubleshoot it?

I am very new to Database Administration. I face a lot of problems while setting up mysql master-slave replication. I also face regular mysql replication troubleshooting issues. Can anybody helps ...
7
votes
3answers
2k views

Is there an Open Source Metadata Management Solution? [closed]

Is there an Open Source Metadata Management Solution? I'd like to create a Metadata Repository that will hold the details of the metadata of database schemas, tables and data items of hundreds of ...
1
vote
2answers
1k views

Sybase - How to get logsegments off my data devices?

I'm running Sybase ASE 15.7 and coming up to speed to clean up a database server installed by a non-DBA. I have a database that has the following device configuration: I want to have data1 and ...
2
votes
1answer
440 views

PostgreSQL archive_command on Windows

What is the best method for WAL log transfer on Windows? I have two servers with Windows Server 2008, PostgreSQL 9.0 64bit. Servers do not have any shared SAN disk, they are on different hosts, ...
2
votes
1answer
3k views

Cannot browse for Backup files using SSMS [duplicate]

I'm facing a strange problem. When I try to backup or restore any database using a SQL Server user (not sa) that belongs only to "public" server role, i have the following error when i click the ...
2
votes
2answers
4k views

Generate sample data for an Oracle database [closed]

Good morning, What free [or trial] software can I use to generate sample data for an Oracle database? I've been trying with various tools, but none work. Thanks for all suggestions, Alec Taylor
0
votes
1answer
269 views

sql server express lan

I want to know if sql server (express) need to have always admin right on a computer. I ask my company to have a version on my pc, but I need a tech to install it because I dont have admin right. ...
1
vote
2answers
2k views

sql server express admin tool portable/web

Is there a way to manage sql server express db, remotly, without installing a software. As a portable apps or a web admin (like phpmyadmin)
0
votes
2answers
306 views

Is command BACKUP asynchronous operation

I got strange delays when backed up a group of databases (20 more) in one scope (TSQL) to the same file location. Is it possible that multiple backup operations are running at the same time? I have ...
11
votes
3answers
6k views

SQL Server 2008 R2 “Ghost Memory”?

We have a dedicated SQL Server 2008 R2 machine that is experiencing some strange memory issues.. The machine itself has plenty of resources including two quad-core processors, 16gb of RAM and 64bit ...
4
votes
2answers
847 views

Website is too slow when number of records increases?

I have developed a web application called Referral Program, It it developed by using PHP, MySQL. Users can joining the website and when they introduce new members, he/she gets a commission. The system ...
2
votes
3answers
249 views

How to validate and upgrade my knowledge of SQL Server with MCSA

My story is that I am working now almost 10 years as an administrator, I deal with SQL Server and other IT stuff, most of my knowledge is self taught by reading books, dealings with problems and ...
4
votes
1answer
667 views

What are the concepts that need to be gone through for MySQL DBA?

I am a MySQL Developer, besides I am handling some DBA activities like backup, restore, mysql installation, etc at a top level. Now I wanted to shift to DBA, So I wanted to know in depth, like which ...
7
votes
2answers
467 views

SQL Server schema intact but every record from every table is gone

We recently set up a new virtual machine running Windows Server 2008 and slapped a copy of SQL server 2005 on it. The server had running and in use without a hitch for about two weeks. The only real ...
2
votes
1answer
82 views

How to get dependencies order

I have a Database Called Total and I have about 40 tables in it.I am trying to move the tables in the database into a different server So I have prepared all the create table scripts but the problem ...
2
votes
4answers
694 views

Tool to monitor database data

I would like to tool that when record data changed inside all tables. so later i would get a report like table user added record - 3,user3.. deleted record - 2,user2..
2
votes
2answers
186 views

How to compare the database of a backup from another environment

Has anyone had any luck with taking a backup (approx 30 tables) from an Oracle database's live environment, then loading a test environment with this backup and doing a comparison between the test ...
14
votes
4answers
20k views

How do you identify InnoDB table corruption?

I have some tables that are partitioned and have several indexes on a replicated slave. After copying the snap shot (verified safe) to a new slave and upgrading mysqld from 5.1.42 to 5.5.15 and ...
1
vote
1answer
337 views

MySQL Grant Permission

I want to Grant a user only INSERT permission. When I try to insert data, it throws the error "Access Denied". What permission do I give a user to use/select database in mysql and how? I have given ...
2
votes
1answer
2k views

Error restoring SQL differential database files

Occasionally I'm having problems restoring DB differentials. I'm getting the error "the differential backup cannot be restored because the database has not been restored to correct earlier state." ...
4
votes
3answers
20k views

Oracle 11g - Create Database fails?

I've just installed Oracle 11g and linked it to SQL Developer. I want to create a database for my django install. CREATE database 'django'; Error starting at line 1 in command: create database ...
2
votes
2answers
4k views

getting error installing oracle 11gR2: cannot access node

I'm installing Oracle 11.2 on dedicated hosted server (centOS 5.5). I've gone through the Oracle Quick Installation guide diligently. I believe I've set everything up correctly, although I'm not a DBA ...
9
votes
2answers
404 views

Which areas of a DBA's knowledge should a developer delve into? [closed]

I must admit the question is quite broad, so I'll try narrowing it down a bit. In our company we are 3-4 developers and have some SQL Server based installations running at our customer's sites ...
4
votes
2answers
1k views

Creating partitions on a production database

I have a production MySQL 5.1 database that is running well but I want to improve query performances. I have never used Partitions and just going through the manuals. I have two tables that involve a ...
18
votes
7answers
703 views

Where can I find some guidance on index strategies?

Most of us will probably agree that using database indexes is good. Too many indexes and performance can actually be degraded. As a general rule, which fields should be indexed? Which fields should ...
3
votes
1answer
9k views

How do I open a MySQL Database Dump?

I work for a doctor's office, and we are in the process of switching EMR systems. The previous system has provided a physical 'dump' of the database. I however, don't know how to open this database ...
5
votes
2answers
2k views

What is the point of the TABLE_CATALOG column in INFORMATION_SCHEMA.TABLES?

In MySQL's table INFORMATION_SCHEMA.TABLES, there's a column named 'TABLE_CATALOG'. The documentation is sparse on this column and I'm wondering what the heck is the purpose of this? Any killer-app ...
2
votes
2answers
1k views

Unknown Db file format - best way to find out?

A client has given me the data he wants visualised in my project - but I don't know what DB format it's in. He's pretty unclear, also.. I have access to the table structures, but don't know how to ...
2
votes
1answer
687 views

Pgpool-II: sequences advanced by 1 after PITR recovery

I have tested pgpool-II 3.0.1 and pgpool 3.0.4, PostgreSQL 8.4 In both cases I'm getting the same result: after online recovery on primary and target nodes all 'serial' values got "+1". Other nodes ...
3
votes
3answers
1k views

Suggestion required for Large Database Optimization and performance

We are creating a large database with estimated growth rate 200 million+ records per annum. The database is use for analysis purpose and we will generate different tabular and graphical reports from ...
2
votes
1answer
89 views

Forums about getting SQL Server 2000 Administration help?

What I'm trying to accomplish is that I need to migrate the SQL Server 2000 installation into a SQL Server 2008 installation, and I would like to say that I am afraid that after this operation I will ...
80
votes
15answers
29k views

Why is Database Administration so hard?

I know a lot of Database Administrators and they are all over 28-29 years old. Is all database administration like that? I mean, is this about getting experience more than at least 7-8 years? Or is ...
1
vote
2answers
296 views

Setting up a CDBMS server

I read something in wikipedia about CDBMS. I have no idea how to setup a CDBMS server! Is it comparable to how I am currently using mysql? I have some extremely large databases and I want to ...
4
votes
3answers
5k views

How to reduce the log file size without shrinking it in SQL server

In SQL server, how do you reduce the log files size without (DBCC) shrinking it. I know shrinking the log file will free up some space, but will also cause fragmentation. Doing a checkpoint in simple ...
0
votes
1answer
4k views

Maintenance plan delete backup

I succeeded in making a backup through maintenance plan. All I need now is to find how to delete a folder (containing old backup) through the same maintenance plan.
40
votes
12answers
4k views

How could DBAs be more 'programmer friendly'?

The answers and comments on the dba.se version and programmers.se version of the question "What are the arguments against or for putting application logic in the database layer?" are very revealing ...
6
votes
5answers
961 views

How do I rule out SQL Server as the reason for a slow website

A website we host has recently been experiencing slow load times. It's been ruled out that the problem lies with the web server and it maybe database related. What steps or procedures do I take to ...
21
votes
7answers
33k views

How can I tell if a SQL Server database is still being used?

We're looking to decommission a SQL Server instance which has a couple databases still remaining on it. How can I tell if they are still being used by users or a web application? I found a forum ...
4
votes
1answer
394 views

Oracle AWR shows missing stats for SQL ID as top elapsed statement

Why SQL ID has null number of executions and elapsed time / execution in AWR report. SQL ID is among top elapsed command on AWR but no details stats whoing time / execution. Would it be because shared ...
1
vote
1answer
157 views

Dates in openldap acl rules

Is it possible to use dates in OpenLDAP's ACL entries? I'm looking to do something like to * by this/termDate < NOW none by * break