Questions tagged [database-administration]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
22 views

Postgres Role required to grant CONNECT on a specific database

I am trying to GRANT CONNECT on a DATABASE to a user as a schema owner in that database. The schema owner is not a superuser. Do I need to be the owner of a database to execute GRANT CONNECT ON ...
0
votes
1answer
1k views

CouchDB administrator password reset

I have an install of couchDB, and somewhere along the line, a malformed request via CURL has my admin accound with a password that I don't know. Short of setting up another Couch server, then ...
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 --...
44
votes
4answers
103k views

MySQL: creating a user that can connect from multiple hosts

I'm using MySQL and I need to create an account that can connect from either the localhost or from another server, i.e. 10.1.1.1. So I am doing: CREATE USER 'bob'@'localhost' IDENTIFIED BY '...
0
votes
1answer
2k 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 # ...
70
votes
6answers
178k views

Changing host permissions for MySQL users

I have the following grants for a user/database mysql> SHOW GRANTS FOR 'username'@'localhost'; +---------------------------------------------------------------------------+ | Grants for username@...
1
vote
1answer
330 views

"Access Denied" when trying to access AWS Lightsail database

I'm trying to connect to my AWS Lightsail database instance with Navicat Premium 15.0.21 (newest available version at the time of posting). My database is in public mode. I copied and pasted the ...
0
votes
2answers
6k 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 ...
0
votes
0answers
16 views

ORACLE Dropping CLOB Column from a very large table

We have a table with about 2 billion rows. ( Yes - billion with a B ). It also has a CLOB column which we want to DROP to reclaim space. Being a production database, we have to ensure : be able to ...
0
votes
0answers
66 views

Oracle : Effect of Stale Partition Statistics on Performance

Our production database tables are range partitioned based on date. Some of the tables and indexes have hundreds of partitions. And some of partitions which are old ( based upon partition key ) have ...
1
vote
2answers
2k views

Can't change the data-directory for MariaDB Centos7.6

I have a fresh install of Centos 7.6 which includes standard partition scheme for Centos 7.6 install. Which includes a "/" directory partition of 50GB. I would like to move the default nysql (mariadb)...
0
votes
1answer
41 views

Is there split brain possibility [closed]

If there are 10 cameras recognizing number plates, and sending the data to the server with a backup server synchronized, is there a possibility to have split-brain problems when some things go wrong? ...
0
votes
4answers
1k views

MySQL slow queries log

Is their any way to filter MySQL slow queries database specifically from /var/log/mysql/mysql-slow.log file. I have a mysql server with 5 live databases. I am trying to optimize this server. Also I ...
12
votes
2answers
7k views

With MySQL, how long does an "ALTER TABLE ... DISABLE KEYS;" statement last?

If you disable the keys (suspending indexing) on a mysql INNODB table, how long does that setting last? For a query like: ALTER TABLE users DISABLE KEYS; Do the keys get re-enabled at the end of ...
94
votes
11answers
142k views

How can I export the privileges from MySQL and then import to a new server?

I know how to export/import the databases using mysqldump & that's fine but how do I get the privileges into the new server. For extra points, there are a couple of existing databases on the new ...
1
vote
3answers
3k views

Throttle or limit resources used by a user in a database?

I would like to know how databases (like MySQL) are able to manage per user resources (like Oracle Database Resource Manager does) to be able to have users that may only get resources only when the ...
0
votes
1answer
102 views

Everyday the DBs are in Recovery pending state

I have an Azure Virtual Machine hosting a SQL Server 2016 named instance. On this instance I have several DBs. Now, everyday we shutdown the virtual machine at 11.59PM and restart it at 8.00AM. The ...
26
votes
5answers
35k views

What's the best way to automate backing-up of PostgreSQL databases?

I find it tedious to have to backup databases every week. And I also think weekly backups should be turned into daily backups. If I had to do that, I don't want to do it manually. What's the best way ...
2
votes
1answer
4k views

DB2 Integrity Checks and Exception Tables

I am working on planning a migration of a DB2 8.1 database from a horrible IBM encoding to UTF-8 to support further languages etc. I am encountering an issue that I am stuck on. A few notes on this ...
0
votes
4answers
283 views

Is there any major performance issue if you switch default-storage-engine setting from InnoDB to MyISAM?

Recently we upgraded version of MySQL on the database server, Almost all of our tables are in MyISAM but in my.ini we have set --default-storage-engine=InnoDB But now we want to change this setting ...
0
votes
1answer
58 views

How to migrate postgresql data?

I have a on-premise postgresql database and have to migrate its data to aws aurora postgresql. However the back up is taken using pg_start_backup. Can I use pg_restore to restore it? Has anyone ...
1
vote
3answers
192 views

Are there measurable benefits to running XFS on EC2

I am looking at creating a PostgreSQL database image (to run on Amazon EC2) and I have heard good things about XFS. However, since ultimately you are running in a VM, the gain of XFS on EC2 might ...
1
vote
1answer
61 views

Why don't I need a certificate to connect to our AWS database?

I'm a developer more than a devops or sysadmin. person and I'm trying to work out what we have to do about SSL certificates and our AWS databases. It is well-known that the certificates issued in ...
-1
votes
1answer
42 views

How to manage many identical instances of a MySQL schema over many machines? [closed]

I'm working on a project that has a MySQL database schema that's used on three different servers (MySQL databases) into 20 copies of the schema for each server (which are all identical in form but ...
0
votes
1answer
598 views

Hostname wildcard % does not include localhost or 127.0.0.0

In MariaDB on windows I create a user and database with the following flush privileges; CREATE USER 'test-one'@'%' IDENTIFIED BY 'test-one'; GRANT USAGE ON *.* TO 'test-one'@'%' REQUIRE NONE WITH ...
3
votes
2answers
309 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
0answers
634 views

Why does SQL Server keep creating the folder “C:\Program Files\Microsoft SQL Server\” when installing on another driver?

I specified a different drive wherever applicable during the SQL Server 2017 install. However, the directory C:\Program Files\Microsoft SQL Server keeps getting created. I basically have the expected ...
0
votes
1answer
80 views

Cannot find my database when trying to import with mysql

When I connect to the mysql shell and do a SHOW DATABASES, i get this | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | rd7 ...
0
votes
0answers
60 views

Sum of bytes of database files of oracle database is showing more than the physical used size of the mount point

We are having oracle 11g2 database on Solaris 10. We have all data files under single mount point say /u001 and we make the sum of bytes of all data files which is more than the physical used size of ...
11
votes
5answers
28k views

Can't Login to phpPgAdmin

I'm trying to set up phpPgAdmin on my test machine so that I can interface with PostgreSQL without always having to use the psql CLI. I have PostgreSQL 9.1 installed via the RPM repository, while I ...
0
votes
0answers
27 views

OCSInventory handover table and form

I need to make some kind of handover table. Records would look like this: PC , user , action , date; X , Y , return , 10.07; X , Z , hire , 11.07; A , Y , hire , 16.07; etc. Each record would ...
0
votes
0answers
45 views

Why can some users connect to a DB and others can't?

I have a geospatial database that one of my users needs to connect to. Whenever he tries to connect from his workstation he gets an invalid connection/connection refused error. He is not able to ...
5
votes
4answers
9k views

Can you explain exporting and then importing PostgreSQL using phpPgAdmin? (And what's with permissions?)

Bounty Edit: I've left the original question but would like a good answer on the whole permissions debacle that Postgres seems to bath in. 'Importing & exporting clients db's: A field guide' I ...
-1
votes
1answer
34 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
532 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
1answer
3k 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 ...
7
votes
1answer
7k 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 ...
4
votes
1answer
214 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
vote
1answer
875 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
1answer
152 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 ...
0
votes
1answer
102 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 ...
5
votes
1answer
24k 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) [...
1
vote
1answer
776 views

Database maintenance plan fails to run every time

I set up a DBMP for SS2008 and explicitly set it to run under a user that has the the serveradmin role. The job (under sql server agent) generated from the plan is set to run under the same sql ...
0
votes
0answers
37 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 ...
-2
votes
1answer
283 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.
1
vote
2answers
9k views

Scheduled copy of production database into test database

My question is similar to this one. I've Two different severs (both SQL Server 2014 Std Edition). Production and Test. I want my test server to connect every night to the production server and copy/...
0
votes
1answer
1k 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
910 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
202 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
247 views

Optimizing MySQL Database for wordpress

I am maintaining a blog with self hosted wordpress. For the last 5 months, my blog isn't really active as I hit "Server Error 500". The error says "The FastCGI process exceeded configured activity ...

1
2 3 4 5 6