Questions tagged [database-administration]
The database-administration tag has no usage guidance.
297
questions
1
vote
1
answer
47
views
How to retrieve text of sql queries that were executed in specific transaction
In my production environment, rare undisposed transactions occur that hold lock on one tables. I want to fix it in my application code.
I can get the TransactionId and SessionId ad hoc, but
how do I ...
- 115
0
votes
2
answers
116
views
MySQL Client taking more than 14 sec to be connected
IN our on-prem server we have installed mysql 4 node cluster 2 for mgmt and 2 for datanode. All are physical server with 1TB ram and 64 core processor. When a user trying to connect to mysql server ...
- 21
0
votes
1
answer
414
views
restarting Oracle 23c within the docker container causes blocked listener
I am using the Free Oracle 23c Docker container (see here) to help provision a development environment.
As part of the configuration of the environment, I am putting scripts and SQL into /docker-...
1
vote
2
answers
184
views
How should databases be configured for different environments to not lose data
How to configure databases for development, staging and production environments so that there will be no any data loss. Many Applications such as Wordpress, Django, etc... use some database to store ...
- 11
0
votes
0
answers
27
views
How to handle scaling upto 3k concurrent connections [duplicate]
So here's our use case:
We have firmware that connects to server (simple php file - that takes post request) and add the data (350-500 bytes per request) to database.
Now here's a issue we have 3k ...
0
votes
0
answers
177
views
How to expose multiple databases in local network for other applications to connect with them
I am following up this question here, in which I made the incorrect assumption of being able to access a database using HTTP.
Because I seem to lack conceptual knowledge, I would like to ask a more ...
- 101
0
votes
1
answer
456
views
mysql, relocating individual databases vs entire data directory
I need to relocate mysql customer databases to another disk, for the purposes of:
1. Separation of user data from system files
2. Ease of backing up system and user data separately
3. Ease of ...
- 157
1
vote
1
answer
6k
views
MySql 8 crashing on loop without specific errors and with enough memory
I'm running Ubuntu 20.04.03 with Mysql 8.0.27.
I have reinstalled LAMP from scratch several times and at the moment I only have 3 WordPress sites but I have tested only 1 and only 2 sites as well. ...
- 11
1
vote
1
answer
3k
views
Why grant all privileges doesn't work in Phpmyadmin?
After command
GRANT ALL PRIVILEGES ON `dbname`.* TO 'userA'@'localhost' IDENTIFIED BY 'password';
MySql says ok. Then i log in user A, but when I try to grant some privileges to user B it gives error ...
0
votes
1
answer
7k
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 ...
- 103
0
votes
1
answer
70
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? ...
- 9
0
votes
1
answer
352
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 ...
- 101
1
vote
1
answer
2k
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 ...
- 13
0
votes
4
answers
635
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 ...
- 225
1
vote
1
answer
144
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 ...
0
votes
1
answer
97
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 ...
- 475
-1
votes
1
answer
68
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
1
answer
1k
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 ...
- 182
1
vote
2
answers
4k
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)...
- 232
0
votes
0
answers
1k
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
...
- 101
0
votes
1
answer
263
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 ...
- 353
0
votes
0
answers
115
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 ...
- 1
0
votes
0
answers
31
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 ...
- 1
0
votes
0
answers
55
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 ...
- 1
-1
votes
1
answer
118
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 ...
1
vote
1
answer
4k
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:\...
- 11
1
vote
1
answer
1k
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 ...
- 123
0
votes
1
answer
221
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 ...
- 137
5
votes
1
answer
28k
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) [...
- 4,850
0
votes
0
answers
44
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 ...
- 5,362
-2
votes
1
answer
340
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
1
answer
2k
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 ...
- 213
0
votes
3
answers
2k
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
1
answer
373
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 ...
google-cloud-platform
0
votes
1
answer
178
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
1
answer
65
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 ...
- 159
1
vote
0
answers
478
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
0
answers
128
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/...
user406214
7
votes
1
answer
10k
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,850
0
votes
1
answer
353
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 :
...
- 1
0
votes
1
answer
2k
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 ...
- 3
0
votes
1
answer
481
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 ...
- 13
1
vote
1
answer
393
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 ...
- 163
-1
votes
1
answer
43
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 ...
- 13
0
votes
1
answer
5k
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,297
1
vote
2
answers
2k
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....
- 149
0
votes
1
answer
62
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 ...
- 103
1
vote
0
answers
565
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 ...
- 141
3
votes
1
answer
5k
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 ...
- 171
0
votes
1
answer
178
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 ...
- 577