The discipline of Operational and Architectural Management of Database Systems.
0
votes
1answer
20 views
replication breaks after upgrading master
I have a set up of replication with master 5.1.30 and slave 5.5.16
and the replication is working good
Now i have upgraded mysql master to 5.1.47
As far as i know we have to turn off the log bin ...
0
votes
0answers
34 views
How much RAM for a large database on a dedicated MySQL InnoDB server?
Hereunder my hardware config:
CPU: 1x Intel Xeon X3470 Quad core @ 2.93GHz
RAM: 4x 8GB DDR3
Disks: 2 x SATA 320GB for the system & 4 x SAS 300GB for the DB
I've upgraded from 12Gb to 32Gb and ...
3
votes
2answers
66 views
Load Testing Crash Course
Can someone point me at a good resource to get a crash course in load testing. I have a sql server machine that I need to load test but I havent been thruogh the process before. Also we do not have ...
1
vote
2answers
42 views
How to backup IBM DB2 Database online?
I tried to backup the IBM DB2 (LUW) Database using this command:
./db2 backup database DBEMP to /home/user1/db2bkup
But I got this message:
SQL1035N The database is currently in use. ...
0
votes
0answers
20 views
Commit count while using LOAD statements in MYSQL
I have a very big text delimited file, I am using Mysql LOAD statement but i want to put some commit count, for example if i put commit count 1000 then after inserting every 1000 rows it should commit ...
0
votes
1answer
188 views
Connecting to a SQL Server database from a Flash program
I currently have the ability to utilize Microsoft SQL Server 2012. I am developing a project with Adobe Flash Builder 4.7.
If I link my database with Adobe Flash Builder is there any additional ...
0
votes
1answer
20 views
InnoDB Failure of some kind
I have MySQL 5.5 installed. I tried to install Joolma but it failed. I went into their sql and replace EGNINE=InnoDB with MyISAM and the install worked.
InnoDB is listed under SHOW ENGINES;
Any idea ...
-1
votes
1answer
55 views
How to merge data from 2 databases [duplicate]
I have a SQL-Server database that crashed while I was away on vacation. All info from 5/2/13 is missing from our current database because my replacement implemented a back-up of the database from ...
1
vote
1answer
62 views
IBM DB2 Database name not found but I can connect using IBM Data Studio. What happened?
In IBM Data Studio, I can create a connection to a remote IBM DB2 LUW database named DBEMP and browse the schema and data.
Here is the steps to create the database connection:
From IBM Data Studio, ...
0
votes
0answers
392 views
1286 - Unknown storage engine 'InnoDB'
I am trying to use roundcube and it recently just broke. I don't know if this is due to a MySQL update that happened recently or not but in phpMyAdmin I get the following error if I try and view a ...
1
vote
1answer
285 views
Data dictionary best practices in SQL Server 2008 r2 [closed]
We are interested in sharing the meta data and data dictionary among the team. I know that we can use the Extended Properties for this purpose, but based on my experience I've seen it gets out of date ...
1
vote
1answer
376 views
unable to login oracle as sysdba
I just got 11gR2 running and was able to conn as sysdba. I shutdown and started up the database to mount a new pfile. Now, I cannot login as sysdba. My parameter for password file is:
...
0
votes
1answer
208 views
“connectivity libraries needed are not found” error in IBM Data Studio
UPDATE
I am getting the following error when I try to create a new database in IBM Data Studio v3.1.1.0.
The connectivity libraries that are needed for local or remote non-JDBC operations were not ...
1
vote
1answer
155 views
how to add attachment(text file) to database mail?
I have scenario
Daily i run a sql job to apply a new updates to one table - this job will create one text file daily - text file contains all new updates
I can send a mail to client that job is ...
1
vote
1answer
72 views
Database Designing for a Ecomerce website
I am new to database designing. I am designing a database for an eCommerce website, there is a lot of products to be updated, but while designing for product specification table I do not understand ...
0
votes
1answer
18 views
Syntax error when trying to import database from two PostgreSQL databases
Following on from this prior question, I'm trying to export a database from one server and put it on another using phpPgAdmin. My process is like this:
select the database in server 1 and hit the ...
2
votes
2answers
22 views
Oracle error : Shutdown immediate error
echo $ORACLE_SID
YBRD
conn sys/hello as sysdba
SQL>shutdown immediate
Then I was waiting for it to shutdown for a couple of minutes. It didn't, so I closed my window.
Then I again logged in and ...
1
vote
1answer
268 views
How to prevent high memory, CPU and time consumption by MySQL restore?
I have a local test machine with 2 GB RAM and a dual core processor.
I imported a dump on that using
mysql -uuser -psecret < script.sql
script.sql is a 700 MB file which contains a single ...
0
votes
1answer
48 views
Plugin 'FEDERATED' is disabled
Im trying to start Mysql using easyPHP : the response is an alert window to a log file. The main error is <-- Plugin 'FEDERATED' is disabled -->.
Through my research on internet i found that the ...
1
vote
1answer
31 views
How to run DB Admin Tool (GUI) in IBM DB2 Express-C?
I had installed IBM DB2 Express-C in Windows but I can't find any shortcut to launch the Administration Tools (GUI). When installing, I had selected "Administration Tool" option (I had checked twice ...
2
votes
2answers
58 views
Why doesn't DELETE + REORG free diskspace (DB2)?
In DB2 I have a table containing large binary data. Now i purged the whole table and ran runstats, reorg, runstats, but the amount of disk space taken does not change. What could be wrong here?
The ...
2
votes
1answer
34 views
SQL Server database schema (and likely, some data changes) - how to auto-distribute over many database instances
Our development involves a SQL Server database (also might be Oracle or Postgres later) and we would sometimes make database schema changes or some other interventions in database.
What solutions ...
3
votes
3answers
85 views
Issue after moving the ib_logfile1 and ib_logfile0 files
I wanted to increase the innodb_log_file_size for better performance. And I increased it from the default value to 256 MB. As usual I got the error saying InnoDB: Error: log file ./ib_logfile0 is of ...
0
votes
2answers
146 views
MySQL Table not repairing
Table info:
Database name: user_motiva
Table name: wp_options.frm wp_options.MYD wp_options.MYI wp_options.TMD
when I do a mysqlcheck -r --all-databases it gets hung on that table even if you ...
1
vote
1answer
82 views
NLS_TIMESTAMP_FORMAT changing automatically and randomlly
I am using Oracle 11gR2. My nls_timestamp_format is changing randomly from dd-mon-rr to yyyy/mm/dd.
Does anyone have any clue why this is happening?
0
votes
0answers
14 views
How to get Greenplum table defintion?
There are already tables created in the schema but I don't know how to get the detailed information of how it was created. Like the configuration used, the orientation, etc.
How do I get this ...
0
votes
1answer
181 views
Unable to change engine to MyISAM in MySQL
I have installed MySQL 5.6.10 on Mac OS X 10.6.5. My issue is that MySQL is using InnoDB as its default engine.
I have checked following engines are supported in MySQL:
show engines\G
...
2
votes
2answers
402 views
Take individual MySQL database offline
MySQL does not have any SQL commands or internal mechanisms for
making an individual database unavailable / offline
moving an individual database
Thtis being the case, how can you take an ...
2
votes
1answer
59 views
MySQL specific database configuration file
In MySQL's configuration file I've globally disabled autocommit as so.
[mysqld]
autocommit=0
I need to turn MySQL's autocommit on for a specific Ruby on Rails database though. It could be for the ...
-1
votes
1answer
323 views
Difference in between HAS MANY and BELONGS TO in Yii framework [closed]
I am new to the Yii Framework.
I discovered HAS MANY and BELONGS TO in the documentation, however I am confused about these features.
Can someone give some real life examples with a diagram that ...
0
votes
0answers
30 views
Database with history journaling [closed]
In the database I need to store a data about vehicles (about 240 objects), their locations, working job, etc. In my table this info stored in one table. User should not input everyday this info. It ...
1
vote
1answer
47 views
How to allow a user to create databases only with a certain prefix?
We're having a multi-user Linux server. I'd like to give each user the ability to create and manage databases at will, but to keep things sane, force them that each database name they create must ...
1
vote
2answers
19 views
DB2 db2fm proccess
Server is been up for 365 days, however i got some weird repeated procceses.
Are these normal?
ps -fea | grep db2fm
db2inst1 643284 229516 29 May 25 - 212564:06 ...
0
votes
1answer
41 views
Generic SQL Job Scheduler for multiple RDBMS's?
I have been searching for an answer to this, but can't seem to find anything. So my problem is this - we have an environment with MS SQL Server 2008, MySQL, and RedShift, and have some complex ...
3
votes
1answer
69 views
Tools and methodologies to keep to DBs aligned
2 DBs having schemas that represent the same semantic objects.
The first one is production DB (Non-RDBMS, in-house implemented in-memory DB with shitload of RAM). Other is Postgres.
Once in a while ...
1
vote
0answers
61 views
What is the future for system and database administration [closed]
Let me present myself for better understanding of my challenge. I love coding, it's been 5 years that I've been in a company as software developer. But for the past 3 years I've been quite pushed into ...
1
vote
0answers
84 views
Unable to recover database
How to resolve this issue, I am getting this error, when I'm trying to open my Oracle Database
ORA-16038: log 1 sequence# 59 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: ...
3
votes
2answers
87 views
Reducing Log Impact During Re-Indexing
We use Ola's maintenance solution and its great.
Regardless of method for re-indexing a major friction point with IT is the amount of log generated during the weekly re-indexing process. For a 1TB ...
0
votes
2answers
55 views
Oracle database uses wrong parameter file
When I try to startup my Oracle database I get the following error:
LRM-00109: could not open parameter file '/opt/app/oracle/product/11.2.0/db_1/dbs/initjicdbaex.ora'
The /dbs directory in my ...
1
vote
1answer
121 views
Upgrade production database during software development lifecycle
Background
Using Oracle, there are a number of tools that help with migrating and applying development changes into the production environment (such as Embarcadero Change Manager). These tools can be ...
4
votes
1answer
32 views
High amount of Read Misses and Pages To Be Flushed
I am running a mysql database backend for a Moodle installation, and after a few months performance really starts to suffer (Up to 30 seconds for some pages to load). Under investigation in the InnoDB ...
0
votes
0answers
42 views
Linked server performace issue?
I have created a linked server in sql server 2008 R2 Enterprise Edition for mysql i.e. MySQL database is accessible under sql server environment. I have a created a trigger in sql server such that ...
-3
votes
2answers
104 views
read multiple values from same column [closed]
how to read multiple values in same column and campare it with the same table id and other table to get its record..
i have a table with column name
pid ,authors ,citing papers
...
2
votes
4answers
69 views
What is the best permissions to set for only creating and managing own databases?
I want to create a login for a new user who could only create and manage their own databases. Other databases on the server should be read-only to that user. What would be a good set of ...
1
vote
1answer
67 views
Public Database for Mobile Application
What are the proper steps to hosting a public database. Currently I a building a mobile application with Adobe Flash Builder. I have used Microsoft SQL Server, My SQL as well as WAMP Server. All of ...
41
votes
9answers
8k 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 ...
4
votes
1answer
88 views
How to determine if there are [idle connections with] uncommitted transactions in PostgreSQL?
According to a comment on this question I asked about idle connections in PostgreSQL 9.2, some uncommitted transactions (possibly related to some of those idle connections) might cause
some ...
3
votes
1answer
73 views
Could too many idle connections affect PostgreSQL 9.2 performance?
Some queries on my database server seem to take a long time to respond, and I believe the CPU usage is high. When running ps aux, I see ~250 "idle" connections (which I believe to be too many). I ...
1
vote
0answers
38 views
Database Timeout Error from VB Application
Recently we are receiving so many database timeout error from different servers
we are using vb application -- which will use ODBC connection to connect database - here no problem
when we run the ...
1
vote
1answer
30 views
Adding users to a list and sort by category?
I'm using SQL-Server 2012 and I would like to know how to solve this program.
So:
I want to create a page that allows admins to manage a project, and part of it, would be to add members/employees to ...
