Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [database-administration]

The tag has no usage guidance.

-1
votes
1answer
29 views

MySQL restart on the server the memory used by mySQL has increased from 1.8 GB to 9.2 GB This resulted in 97% of the Server memory being in used

MySQL restart on the server the memory used by mySQL has increased from 1.8 GB to 9.2 GB This resulted in 97% of the Server memory being in used Any tuning need to be set on my.cnf file. Every week ...
0
votes
1answer
25 views

SQL SSMS on development - clear ldf files

Working on building a big SQL Server database, I noticed my C drive is running out of space when running heavy SQL queries. The following folder size is over 150GB, log.ldf files reach over 50GB. C:\...
0
votes
0answers
27 views

Recovering from a DB2 Failure

My system had a full hardware failure last night, I spent all day bring it back up. Long story short after a lot of "Why isn't XDB starting?" I ended up reviewing the logs and finding that the ...
0
votes
1answer
201 views

Should SQL Server min and max memory settings be fixed to the same value

Hello, If the server has the resources to dedicate to the SQL server should you keep the min and max server memory settings fixed at the same value? Will setting the values the same produce any ...
0
votes
0answers
61 views

Locked out of MySQL; how to sign in from specific IP Address?

When I was managing the users and privileges for a SQL server, I accidentally locked myself out. To explain there were previously multiple combinations of users and hosts that had access to the DB (...
0
votes
1answer
35 views

selinux context for multiple databases

I have a directory /media/databases under which I want to hold 3 different databases : mariadb, postgresql and neo4j. My issue is that I already have configured postgresql selinux context and the ...
1
vote
1answer
6k views

What does “GC (Allocation Failure)” mean in my ElasticSearch 5.6 logs?

I see these constantly in my Elasticsearch 5.6.3 logs. Is this a signal that I should scale up and add more RAM? Or is this just normal operations for ElasticSearch? [GC (Allocation Failure) [...
0
votes
0answers
53 views

Oracle using DBMS_REDEFINITION for CREATE TABLE AS SELECT

We have to frequently delete about 40% - 50% rows from a large table. We know that CTAS ( create table as select ) is much faster because we can simply do the following 1. Create table new_tab as ...
0
votes
0answers
17 views

Mysql server down on big file upload

I am currently uploading .csv files to my DB using LOAD DATA INFILE query. It does a lot faster than usual INSERT INTO, but it fails when I'm trying to upload >5million rows. I tried uploading ...
0
votes
0answers
27 views

Is PostgreSQL Continuous Archiving and PITR what we need?

We have a billing database that uses a PostgreSQL backend, and our billing manager has insisted that we do backups hourly, because of how much work we'd lose from daily backups. My inexperience at ...
-4
votes
1answer
103 views

how to initiate and maintain mongo shard replica set from mongos server? [closed]

I am trying to initiate a mongo shards replica set from mongos server, I want my mongos to maintain replica set and able to add new server to replication if needed.
0
votes
1answer
394 views

Oracle 12c schema restore using impdp from a different server

I have created 2 EC2 instances in AWS. One acts as DB Server and one acts as client. Oracle 12c DB instance is installed on DB server and Oracle 12c instant client on client server. I have ...
0
votes
3answers
209 views

Giving permission 777 to folders/files Cons? [duplicate]

I am trying to understand how giving 777 permission to folders or files works. I did some research and understand that 777 permission is not the best when it comes for security. Referring to Web ...
0
votes
1answer
89 views

Transfer PostgreSQL database to Google Cloud Platform (GCP) when directory structure is different

I have an on-prem SUSE 12 sp3 VM with PostgreSQL 10 database that is about 45GB. I also have a Google Cloud Platform (GCP) image/instance of a SUSE 12 sp3 server with PostgreSQL 10 database, with no ...
0
votes
1answer
41 views

How to debug a SQL script containing INSERT statements with failing subqueries?

I have three tables in my database: tbl_object, tbl_tag adn tbl_object_tag_xref. tbl_object and tbl_tag only have the two columns id and name. tbl_object_tag_xref matches objects to tags and vice ...
-1
votes
1answer
50 views

How do you stop a hacker from changing passwords in your DB directly, if they're already in a position to steal the DB? [closed]

I've been researching the methods of securely storing user passwords in a database (by only storing the hashed password, with a strong algorithm, along with a salt, and deriving the key after so many ...
1
vote
0answers
268 views

Registering oracle 10g db with 12c grid

Hi I have oracle grid infrastructure 12c installed for stand alone server and I'm trying to register oracle database 10g with CRS, but I suspect there was syntax change because srvctl fails when ...
0
votes
0answers
41 views

Migrating MariaDB cannot find files anymore

I had to reset my dedicated server, so i backuped the whole /var/lib/mysql directory (stored in OVH Backup Storage). Today on my clean dedicated, i reinstalled mariadb and so putted the whole /var/...
6
votes
1answer
3k views

Understanding IXSCAN and COLLSCAN in MongoDB logs

I'm attempting to grep through some Mongo logs in an attempt to find slow operations that I need to optimize. Slow query logging is at the default and is logging operations over 100ms. I think ...
0
votes
1answer
70 views

connections to postgresql at particular time frame

How can i find the connections made/utilized to my PostgreSQL at a particular given time frame ? In the PostgreSQL logs i am getting JSTERROR: canceling statement due to user request Sar logs : ...
0
votes
1answer
385 views

Staging & Production Sharing the Same Database server?

I am currently trying to setup a staging environment for our live website. (Magento e-com site Here is our current setup: One droplet for Prod Web Server (Apache, PHP, etc.) One droplet for Prod ...
0
votes
1answer
263 views

corosync + pacemaker + percona agent in production

We are planning on implementing HA using pacemaker Corosync and Percona agent on mysql 5.7.1 with GTID. I googled for quiet a while and realized there isn't enough information. I was wondering if any ...
1
vote
1answer
141 views

Can oracle handle SERVER = POOLED (DRCP) and SERVER = DEDICATED clients simultaneously?

I run a PHP application that uses an Oracle 11g instance as it's backend. We currently connect with DEDICATED as our type but we're having trouble scaling. As such, I suggested to the DBA we ...
-1
votes
1answer
39 views

Active Directory CSV QUERIES NOT ADMIN

My situation: I work at a help desk and have access to the server active directory is on. I do not have edit privileges. I am in control of inventory and need to have a way to get employee ...
0
votes
1answer
2k views

Database server vs NAS for data files

Regarding costs and maintenance speed/simplicity in case of hardwar failures, does it make any sense to keep SQL data files on a NAS server, separate from the SQL Server instance? Our app stores large ...
1
vote
2answers
1k views

cassandra nodetool drain running for days

We are having performance problems with our cluster regarding to timeouts when repairs are running or massive deletes. One of the advice I received was update our casssandra version from 2.0.17 to 2.2....
0
votes
1answer
34 views

Opening ports on a remote DB server

I'm running a RHEL7 box, running MySQL-5.7.11 and I'm simply trying to allow remote connections... I followed the documentation here on opening a port and have done so successfully. When I run ...
1
vote
0answers
237 views

MariaDB query cache not being used with prepared statements

We are seeing a problem with our MariaDB setup where our queries executed as prepared statements are not being cached, however, queries executed locally through mysql command (i.e. text protocol) do ...
2
votes
1answer
2k views

Upgrading PostgreSQL on EC2 with minimum impact to existing configuration

I have PostgreSQL 9.2 installed on an EC2 instance, with yum install. I now need to upgrade to PostgreSQL 9.4. I've noticed that yum list lists 9.2, 9.3 and 9.4 as completely separate packages, so I ...
0
votes
1answer
114 views

What carries out SQL Server Mirroring?

I'd like to know what service(s)/process(s) carries out Mirroring in SQL Server. For example, we have various Agents carrying out the different steps for SQL Database Replication. Similarly, what is ...
-1
votes
2answers
961 views

How to move PostgreSQL data directory?

My PostgreSQL installation by default uses /var/lib/pgsql directory to store data, backups and configuration files. As my disk space is running out, I have installed new hardware and mounted it in the ...
10
votes
3answers
1k views

Importance of location of installation of Microsoft SQL Server

I have a server with cheap slow disk and an expensive fast disk. I want to use the expensive disk for all the things where it's important that it's fast, such as my databases. To save money, I want ...
1
vote
2answers
1k views

How to free up disk space on a drive which has BiztalkMsgBoxDB_log file in it

I have been asked to analyze a issue regarding one of the biztalk servers. I was asked to free up space on a particular drive, where I found the only file BiztalkMsgBoxDB_log.bak is taking up close 90%...
-4
votes
1answer
170 views

mysql remote server connection fails [closed]

I'm working on this for 4 days and I know it is all over google, but I did all the required stuff but still no connection. I created to 2 vagrant boxes, one for web server and one for mysql. web: ...
0
votes
2answers
3k views

User with grant permissions cannot grant permissions for new user with and new database

I am using: mysql 5.5.43-0 on ubuntu 14.04.1 I try to create a new admin-user (admin) who is allowed to do the following things: a creating new users (dbuser1) with password - (permission "create ...
4
votes
2answers
1k views

PostgreSQL limiting connections to fewer than max_connections?

I have a PostgreSQL 9.4 server that seems to be limiting connections to fewer than what I have defined in max_connections. I have max_connections set to 300. SHOW max_connections; max_connections --...
4
votes
1answer
128 views

Reclaiming free space in filegroup with single chronological partition

-moved here from SO (no coments there) Question: what is a proper way of reclaiming space in big (hundreds of GBs) filegroup with single partition of table that is chronologically ordered and has no ...
-1
votes
1answer
93 views

What happens if I exceed the initial database size of RDS from Amazon AWS?

When creating an Amazon RDS, I get asked for the size I want the database to be. If I set this to 5 GB, then what happens when the database size hits the 5 GB and exceeds it?
1
vote
1answer
83 views

How to implement table security without SUPER privilege?

A MAJOR provider of cloud-based MySQL does not grant the SUPER privilege to the master user. The provider is Amazon RDS, but my question isn't about Amazon RDS specifically, it's for the general case ...
0
votes
1answer
1k views

Setting up Multi server environment in Sql Server 2012 - Enlist Failed Error

I am trying to Configure the Master target server / Multi server environment in Sql Server 2012. I changed : MSXENCryptChannnelOptions # Changed from 2 to 0 AllowDownloadedJobsToMatchProxyName # ...
-3
votes
1answer
58 views

How should my company bring its product, a line-of-business MVC application, into the cloud? [closed]

I am a recently-hired junior software engineer at a small company that develops and sells a normal client/server MVC application to small and mid-level enterprise clients in a particular line of ...
0
votes
1answer
487 views

I set up a web application server, and a separate server for postgres on the same network. How should I secure the connection?

I'm trying to determine the best, modern practice for using your own separate database server for a web-app. I have an app server, appserver1, (running php, nginx, etc, not that that matters much), ...
1
vote
1answer
6k views

Importing Data Dump Using pgAdmin

I looked around and found the following code on how to import a data dump using pgadmin: CREATE OR REPLACE FUNCTION db_to_csv(path TEXT) RETURNS void AS $$ tables RECORD; gmdeclare statement TEXT;...
4
votes
3answers
2k views

How can I drop a MySQL user whose username contains unprintable characters?

I have a user in MySQL 5.6 that was somehow created with a non-printable character in the username. How can I drop this user? mysql> select user,host from mysql.user where user like 'wiki%'; +-----...
1
vote
0answers
62 views

Axis DMsuite RESTful API

I'm looking at Axis DMsuite for masking Oracle databases. I was told by their staff that they exposed some simple REST endpoints for triggering masking jobs, but I have done a fair bit of searching ...
1
vote
0answers
248 views

MSSQL Server 2008R2 Replication stall, no latency, no errors, missing data on subscriber

This morning after performing a routine database deployment of two new tables I noticed that transactional replication had stopped for more than 3 hours. When replication resumed it picked up 3+ hours ...
3
votes
1answer
3k views

Most reliable MariaDB to Postgres dump method

I am in the process of migrating an app to another server, and will need to migrate the database contents from MariaDB to Postgresql. Most documentation indicates that the following format should ...
0
votes
1answer
2k views

OsTicket + IIS + mySQL + Extremely slow queries

Background: I am a .net developer, limited php coding knowledge Asking this question because I think it is a php/mysql/version/implementation issue, and not getting real information from the OSticket ...
1
vote
1answer
776 views

What maintenance tasks should I run on my MS-SQL 2008/2012 servers?

The servers are using database mirroring for high-availability running SQL server standard on newer hardware. The existing plans were setup by a DBA many years ago and are using the built in ...
-1
votes
1answer
37 views

Moving MYSQL database Cache issue?

I moved a mysql (myisam) database using rsync to aother server, I realized after doing this that I forgot to run 'flush tables' before moving the files so not all changes were written to disk I guess. ...