Questions tagged [database-administration]

The tag has no usage guidance.

45 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
4 votes
2 answers
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 --...
  • 233
3 votes
2 answers
980 views

What are some reasons why a MySQL index would be 12X the size of the table?

So we have a table that has two indexes one on the primary key and one other index on another column on the table. The index size is currently 12X larger than the table itself. What are some reasons ...
  • 151
2 votes
0 answers
289 views

SQL Azure Automated Backups doesn't work

I configured automated export of my SQL azure db, but backups are not created. Also, I'am resieved this mail. Automated SQL Export failed for [servername]:[dbname] at 25.09.2013 23:06:45. The ...
  • 21
1 vote
1 answer
1k 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. ...
1 vote
0 answers
433 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 ...
1 vote
0 answers
477 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 ...
1 vote
0 answers
64 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 ...
  • 46
1 vote
0 answers
259 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 ...
  • 11
1 vote
0 answers
1k views

MongoDB Performance Troubleshooting

I have a small MongoDB replica set (2.4.6) and it seems about once a week, the primary gets bogged and the load average spikes up. This app doesn't see a huge amount of traffic. It resides in EC2 ...
  • 168
1 vote
0 answers
27 views

My transactional overnight batch has spiked in duration

I have an overnight batch run which is transactional...picking up data doing some small calculations and putting it somewhere else and it was finishing around 3am every day for the last 2 months. Now ...
  • 241
1 vote
0 answers
39 views

Move one site in Wordpress Multisite setup

I have a Multisite Wordpress setup with a dev box and a live. Whenever my developers change a theme on one of the sites or add a page/post/any other content on the deb box, I have to take the whole db ...
  • 1,221
1 vote
1 answer
801 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 ...
1 vote
1 answer
44 views

What are the contents of the Headers in Control,Redo log and data file in a typical Oracle DB?

Where can i find the contents contents of the Headers in Control,Redo log and data file in a typical Oracle DB.
user avatar
1 vote
1 answer
637 views

Load balancing issue with pgpool2 and postgresql-8.3

I'm using the latest release of pgpool2 on Ubuntu 8.04 with postgres 8.3.11. Replication is working great, but none of my SELECT queries are being load balanced to my secondary server. These are ...
1 vote
0 answers
638 views

SQL 2008 Database tuning advisor won’t start

For some reason I can't get DTA to connect to my development machine. It connects to a remote DB just fine but when I point it to my dev machine I get an error saying: Failed to initialize MSDB ...
1 vote
1 answer
3k views

ASP.NET Website Administration Tool: Unable to connect to SQL Server database

I am trying to get authentication and authorization working with my ASP MVC project. I've run the aspnet_regsql.exe tool without any problem and see the aspnetdb database on my server (using the ...
0 votes
0 answers
5 views

Finding pending cassandra pending compactions information

I am trying to understand the pending compaction statistics that are displayed by cassandra nodetool that can be seen two ways. I am on cassandra 3.11.3. Why would the compaction statistics be ...
0 votes
0 answers
44 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 ...
  • 99
0 votes
0 answers
105 views

How to set max. connections to an Aurora RDS instance

I set the DB cluster parameter group to a parameter group that has max connections = 60. I set the instance option group to an option group that has max connections = 55. I applied changes immediately....
0 votes
0 answers
7 views

View all records in Algolia dashboard

We have an Algolia project that has 2929 records. In the search field on the web dashboard, it only allows us to page through 235 records. Is there any way to page through all records in the dashboard?...
  • 135
0 votes
1 answer
76 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 ...
0 votes
1 answer
66 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 ...
  • 445
0 votes
0 answers
815 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
0 answers
80 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 ...
0 votes
0 answers
30 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
0 answers
50 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
0 votes
1 answer
126 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 ...
  • 115
0 votes
0 answers
40 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,324
0 votes
1 answer
265 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
1 answer
55 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 ...
0 votes
0 answers
79 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/...
user avatar
0 votes
2 answers
7k 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
1 answer
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 # ...
0 votes
1 answer
750 views

Setting Up Replication/master slave configuration to mariaDB

I'm starting my project using mariaDB I want to setup master slave configurations on windows 7 64Bit. I don't know how to setup this kind of configuration. I've searched on google, visited websites ...
0 votes
0 answers
156 views

MySQL response times spiking at regular intervals

I recently set up a windows Hyper-V VPS with a bitnami django stack. I am monitering the website with newrelic. I noticed that my MySQL database response times spike about every 30 min. My first ...
0 votes
1 answer
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 ...
  • 203
0 votes
1 answer
375 views

Replicate from slaves to master and viceversa

I've a great dilema here and didn't know how to solve it. I need to replicate a few tables from MySQL DB (slaves) to MySQL DB (master). Take as an example this: MySQL DB (master) table1 table2 ...
  • 700
0 votes
1 answer
272 views

All users can read SSAS all Cubes

I found that all my domainusers can read the cubes in my Microsoft Analasys Services. I have no roles specifying that. Neither the domain admins nor the local admins contain any group that would ...
  • 1,805
0 votes
1 answer
511 views

Can MySQL use roles without MySQL Wokbench?

I have only found documentation about roles in MySQL through the use of Workbench, is there an alternative way to set them?
0 votes
1 answer
50 views

Automatically drop FK's to re-create a table and then automatically put the FK's back

I have a number of incidents where SSMS tells me table recreation is required, even for something simple like making a column nullable. If this table is referenced by FK's, I would ideally like to ...
  • 483
0 votes
2 answers
1k views

Options to handle corrupt msdb ldf file

Specs: We're using SQL Server 2005 with transactional replication. Our MSDB .LDF file has recently become corrupted, causing the MSDB db to be marked as 'suspect'. We read a bunch of stuff online ...
user avatar
0 votes
1 answer
362 views

Maintenance Plan Reporting - Append To File - Clean Up?

Background: (SQL Server 2005, Standard Ed.) I have a maintenance plan running backups, taking a full backup 1/day, and t-log every 15 minutes. I have it set to create a text file report of each run, ...
0 votes
2 answers
468 views

DB2 users and groups

Just want to know everyone's experience and take on managing users/authentication on a multi-node db2 cluster with users groups. I have 17 apps in production (project based company, only 2 online apps)...
0 votes
2 answers
240 views

Curious about my database server setup

I'm a web developer by day but I haven't had as much server administration experience as I'd like. I'm working on some side projects which are hosted on a 512mb linode server. The main app that I'm ...
-1 votes
1 answer
40 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 ...