The discipline of Operational and Architectural Management of Database Systems.

learn more… | top users | synonyms

3
votes
2answers
806 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
2answers
612 views

Generalisation in databases

I am working on a Hospital Management project in DB2. I have one table for staff with a primary key of staff_id. The hospital has to have different staff... e.g doctors,nurses,e.t.c. Is it better to ...
1
vote
0answers
204 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 ...
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
994 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 ...
1
vote
1answer
88 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 ...
1
vote
1answer
302 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
651 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 ...
3
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 ...
4
votes
1answer
290 views

Speed inserts in database with a table with +47 million data per each year, containing more than 10 years?

I'm moving my database to mysql but there is one table that is pretty big (more than 47 million rows for each year) and it takes years to insert all the data. I already tried everything I found in ...
2
votes
2answers
3k 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
2answers
283 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 ...
0
votes
1answer
268 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. ...
4
votes
1answer
615 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
461 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
2answers
180 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 ...
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." ...
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 ...
5
votes
3answers
228 views

How do you approach refactoring an ugly procedure/query?

I've inherited a database which contains several procedures which are 1000-1500 lines long, with complex nested sub-selects going up to 7 or 8 levels deep in places. I desperately need to refactor ...
4
votes
1answer
383 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 ...
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 ...
3
votes
1answer
8k 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 ...
3
votes
3answers
984 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 ...
1
vote
2answers
282 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
4k 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.
6
votes
5answers
879 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 ...
1
vote
1answer
155 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
2
votes
1answer
700 views

Are there any good database management applications for JDBC/Java databases?

I am working with an Apache Derby/JavaDB database via JDBC. Before have I been working with MySQL and used phpMyAdmin as a good Database Management tool. Is there any good desktop application for ...