Questions tagged [database]
System that handles large amounts of data in an organised fashion
1,704 questions
1 vote
0 answers
86 views
Is mariadb-secure-installation still relevant?
I just installed MariaDB on a brand new Ubuntu 24.04 LTS server, and most online configuration tutorials suggest I run mariadb-secure-installation right after installation, otherwise my database ...
- 56
0 votes
1 answer
81 views
How can I connect a remote database server on SlickStack?
By default, SlickStack installs MySQL locally and connects WordPress to a localhost database. I want to skip that, and connect to a remote (managed) database server instead... What is the proper way ...
- 388
0 votes
0 answers
31 views
REMAP_DATAFILE not working during Data Pump import on Oracle 19c
I'm trying to import a full database dump using impdp into a different Oracle 19c (Standard Edition 2) environment, but the REMAP_DATAFILE parameter doesn't seem to be working. My goal is to import a ...
- 111
0 votes
0 answers
43 views
SQL Server on Docker: unable to create db snapshots
I run SQL Server instance on Docker, using the command: docker run -d --rm -e "TZ=Europe/Rome" -e MSSQL_COLLATION=Latin1_General_CI_AS --name sql_server -e 'encrypt=disable' -e 'ACCEPT_EULA=...
- 143
0 votes
1 answer
2k views
Where can I download Oracle Database 12c?
I need to install Oracle Database 12c on my local machine, but I’m unable to find a working download link. The official Oracle website seems to have removed or restricted access to older versions. I’...
- 3
0 votes
0 answers
87 views
Restore MySQL DB with only .frm and .ibd files
I had a WordPress site built in xampp and my machine crashed. I was able to recover the htdocs and database folder for the website. The DB folder has all the .frm/.ibd files along, with a .opt file. ...
0 votes
0 answers
70 views
Xampp Dtata Base 1932 error
So this is the situation. I had xampp on my work computer. I was building a new website and the machine crashed. We were able to recover the main DB which has both the .frm and .ibd files. We also ...
0 votes
0 answers
94 views
pgpool II does not cleanup idle connection
We are running pgpool II with three PostgreSQL DBs - one main and two replicas. The env is running in k8s deployed with bitnami postgresql-ha helm chart. The pgpool II configuration is as follows: We ...
- 101
0 votes
0 answers
104 views
MariaDB is not using index
MariaDB 10.3 I am investigating a Wordpress / Woocommerce installation, which is quite slow. I threw the slow log into ChatGPT, which suggested adding indexes to the status column of the ...
- 115
0 votes
1 answer
366 views
always needing innodb_force_recovery = 6
After many attempts I was able to restart a badly corrupted db by adding innodb_force_recovery = 6 to my.ini However now, I am unable to start the server at all unless that line is permanently in the ...
- 209
0 votes
0 answers
215 views
SQL ODBC connection fails after activating wireguard tunnel
I have a problem with connecting to my DB while Wireguard VPN is activated. The problem appears both when the DB is on my machine (localhost) and when it's a machine on the same network (using the ...
- 1
0 votes
0 answers
41 views
Google Ads to Google BigQuery Data Transfer failed
Dear Google Community Support Team, I hope this message finds you well. We have encountered an issue related to our billing account. It was inactive during the period from October 7, 2024, to November ...
google-cloud-platform
0 votes
0 answers
250 views
ERROR 2002 (HY000): Can't connect to local server through socket '/var/run/mysqld/mysqld.sock' (2). Using mariadb on Debian trixie
I'm aware this is a common issue, but none of the other posts helped me solve our issue (1, 2, 3, 4, 5, 6 ). I installed mariadb using an ansible as part of an openstack installation, and it crashed ...
0 votes
1 answer
68 views
AWS RDS - SQLSTATE[HY000] [1130] Host 'ec2-ip' is not allowed to connect to this MySQL server
My Laravel(hosted on EC2) app database(Mysql) is hosted in AWS RDS it was working fine but now it gives the error "SQLSTATE[HY000] [1130] Host '172...***' is not allowed to connect to this MySQL ...
- 1
0 votes
0 answers
223 views
Unable to perform unattended installation of Oracle Database 19.3.0 on Windows 10
During an unattended installation of Oracle Database 19.3.0 on Windows 10, the following error occurs: "SEVERE: PRCZ-1082 : Failed to add Windows user or Windows group "REG-XSPY-NUM12$" ...
1 vote
0 answers
203 views
High CPU Usage by php-cgi in WordPress Admin Panel
I’m running a WordPress site on a server with AlmaLinux 9 and cPanel. The site itself is fast, but the admin panel is very slow. When I check the server using htop, I see php-cgi processes consuming ...
- 65
0 votes
0 answers
114 views
Should I stop using text files as data storage in production?
My question is about system design (and not solving a technical hurdle), but it's nonetheless quite specific. I currently have an application storing big chunks of data in text files. The context of ...
- 139
1 vote
1 answer
103 views
Database appears as garbled characters in phpMyAdmin
I have a website in Arabic, and the website was displaying unreadable characters like رسائل. I managed to fix the issue by changing the settings in MariaDB 10.6.19. character_set_client ...
- 65
1 vote
1 answer
609 views
MariaDB won't free disk space after drop database
I have Test MariaDb 10.6 database installed in our DEV server. I set a test analytics database on it, just to TEST how an application's built-in monitoring would work (and it worked). But, due to the ...
- 121
0 votes
1 answer
119 views
ERROR INSTALLING ZABBIX PROXY 4.4
I am trying to install a zabbix proxy 4.4 using the installation manual: commands used for installation: #wget https://repo.zabbix.com/zabbix/4.4/ubuntu/pool/main/z/zabbix-release/zabbix-release_4.4-1+...
0 votes
2 answers
526 views
Can't launch PostgreSQL Database (Data lost??)
macOS Sonoma 14.2.1 (23C71), just updated to 14.5 (23F79) Story I had a python script (norgis ALKIS-Import) importing a lot of Data into my Postgres Database over the weekend. When I came back today ...
- 1
1 vote
1 answer
57 views
How to Secure Database Credentials in a Windows Desktop App Without a Service Layer: Preventing Unauthorized Access to DBMS?
Given is a Windows desktop application (written in Java) that communicates directly with a DBMS (SQL). There is no service layer between the desktop application and the DBMS. How can one secure the ...
- 11
1 vote
1 answer
118 views
MSSQL Restore command taking over the terminal for 10 minutes
I run MSSQL as a statefulset on Kubernetes (I use the official docker image) I wrote a startup script that should restore $n backups on $n databases. my problem is: first database gets restored ...
- 11
0 votes
1 answer
1k views
MySQL upgrade from 80034 to 80035 "Still pending", so MySQL 80037 won't start
My "MySQL" instance on a dedicated server decided to update by itself. Automatic updates should be beneficial for security reasons, but in this case the Database collapsed. A few months ago ...
- 1
2 votes
2 answers
449 views
Rook Ceph storage and MySQL space very big difference
Can someone please advise me what could be the cause of this condition? I have a Rook Ceph cluster on which MySQL database with 3x replication is stored. This database is used by me for development ...
- 133
0 votes
0 answers
146 views
MongoDB Storage Setup for 200TB Data
I have 200TBs of PDF files(~800K), 100MB each on average, to be stored in MongoDB(GRIDFS). It is the cloud provider's policy to store PDFs in MongoDB Database only. I need guidance regarding MongoDB ...
- 101
1 vote
1 answer
204 views
sql server max memory change event viewer log
In the Windows Event Viewer application, I see a record that the maximum memory value of SQL Server is reduced by 99%. After this process, we could not access the database from anywhere. How can we ...
- 11
1 vote
1 answer
669 views
Why did our AWS Aurora RDS spike and lock up?
This morning our aurora mysql serverless 2 spiked and basically locked up. We have a writer/reader and a reader associated with the cluster. On the reader we had an intense select query. This is the ...
- 65
1 vote
0 answers
339 views
How to enable SQL trace for AWS Oracle RDS
To enable sql trace under Oracle you would typically run the following via sqlplus after login: ALTER SESSION SET SQL_TRACE=TRUE On Oracle 19 RDS this results in the following: Error report - ORA-...
- 11
0 votes
1 answer
70 views
Unable to install Nectari's BILicense Server software on Windows Server
Trying to install the BILicense Service for Sage X3 SEI (Sage Enterprise Intelligence) on a Windows 2019 server. This is a prerequisite before installing SEI for Sage X3. Straight out of the gate it ...
- 21
1 vote
1 answer
482 views
Large WordPress E-Com Site - Very slow performance (High volume of Post Meta data and Order Data)
I have an e-com store running on WordPress (Together with using WooCommerce) - We've operated the site for around 4 years now, and in that time, our website has grown heavily in sales and customer ...
- 11
0 votes
1 answer
533 views
Connecting to Oracle Autonomous Database with PHP and OCI8
I'm using Oracle Cloud Infrastructure. I have a VM instance with Ubuntu-22.04-Minimal. Apache, PHP, and OCI8 are all installed and working. When I try to connect to the database I get: Warning: ...
- 111
0 votes
2 answers
301 views
Issues with VPS provider limiting CPU usage with data processing Spring Boot application
I developed a Java Spring Boot application with a PostgreSQL database. Since the data being processed is quite a lot, the processing can take time and it uses a lot of CPU (e.g. up to 100% obviously). ...
- 101
0 votes
1 answer
734 views
MySQL Update Statement taking long time to update small table with 4 rows
I've got a ridiculously small table in MySQL that consists of four rows of data. Updating this table is taking a long time, often upwards of 50 seconds. CREATE TABLE log_CacheQueueEntity ( ID int(11)...
- 237
1 vote
1 answer
200 views
Logged in users cannot store visualizations within their OpenSearch tenant space
We have recently switched 1 of our 3 clusters from Elasticsearch to OpenSearch. The cluster is receiving data into 30+ data streams and the data is searchable in Dashboards using index patterns etc. ...
- 111
0 votes
1 answer
1k views
Azure SQL Elastic Pool max size lower than max size of database included in pool
I am trying to save some money by utilizing Azure SQL Elastic Pools. I have a bunch of databases which only peak in usage once a while, so having them in a pool would be optimal. The problem now is ...
- 1
0 votes
0 answers
99 views
Configuring database alarms for and AWS RDS datbase
I'm using an AWS RDS MySQL 8.0db.t3.micro 100GB DB for an app and am trying to determine the best alarms to set (the Laravel application is served through Vapor and through their UI, you can receive ...
- 113
0 votes
1 answer
139 views
Proxy or gateway between application and database server
We are going through implementing ISO 27001 processes we have a requirement of having a proxy server between the application and database server, can someone suggest an architecture and tools to use?
- 123
0 votes
0 answers
113 views
How to configure Azure Data Factory to handle larger files?
I have an azure data factory pipeline that reads a 100 mb CSV from blob storage and inserts it into an Azure SQL DB that has tons of space (200 GB). I also have a 1 MB version of the same files, just ...
- 1
0 votes
0 answers
381 views
What is the efficient way to copy large database from one server to another?
I have a SQL server's full database backup job that runs daily at night. Currently, I need to stay up late every night to copy that backup file (around 300GB in size) to 5 servers in different ...
0 votes
1 answer
1k views
Mysql server eating all RAM (100GB) when load is running
I am using Mysql - Server version: 8.0.29 MySQL Community Server - GPL My server has 100GB RAM. Of it I allocated innodb_buffer_pool_size as 90 GB SET GLOBAL innodb_buffer_pool_size = 96636764160; I ...
- 113
0 votes
1 answer
625 views
How to add a new database on replication?
I have a mysql replication with two servers. There are actually 3 databases on it. On master : server-id = 1 log_bin = /var/log/mysql/mysql-bin.log expire_logs_days ...
0 votes
0 answers
83 views
Openstack DB issues
Had a power issue and my openstack will not fully come up. It is showing that I have VM's but from 5 years ago and not recent ones. I need help bringing it up. I am running an OLD version of the ...
- 1
0 votes
1 answer
237 views
Mariadb creates a subprocess after crash
We recently had a crash on our Mariadb server (10.6.5) on a Debian 9 VM. The process was restarted without error but now there's a second mariadb process like so : mysql 26718 5.1 42.4 15062644 ...
- 383
0 votes
1 answer
321 views
Apache Ignite - Automatic Cluster Snapshot Create / Restore Procedure
When trying the Apache Ignite cluster snapshot procedure (snapshot create, restore), the restore operation is not successful. Before the restore procedure, we have destroyed the cache which we want to ...
0 votes
1 answer
2k views
Postfixadmin can't connect to mysql database (MariaDB)
I am trying to make my own mail service using Postfix, but I run into an issue in the setup phase, and it's that postfix can't connect to the database. Here's what the error log says: ⛔Database ...
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
847 views
Undestanding how to connect remotely to a Mysql database
Even if I found many old questions around this topic, I'm still unable to connect to a mysql database remotely. Beside my own specific issue I'd like to point out what are my doubts, in hope to serve ...
- 1
1 vote
0 answers
131 views
Haproxy 2 domain ssl crt conflit
Haproxy load balancer - I configured 2 different domain SSL certificates and get a conflict. For example I have two domains api.xxx.com and api.yyy.com. If try to get api.xxx.com its showing yyy cert ...
- 11
3 votes
1 answer
6k views
How do I give a postgres user all privileges to a specific database?
I'm setting up a new database server which I intend to use as a backend for many services. Each of these services generally only care about a single database in the system, so I'd like to isolate the ...
- 173