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 [centos]

CentOS is a Linux operating system. Questions with this tag should be about administering a database management platform on the CentOS operating system.

1
vote
1answer
13 views

Change mariadb's log directory

MariaDB was installed using yum on Centos7 using repository http://yum.mariadb.org/10.3/centos7-amd64. MariaDB's log files are sent to directory /var/lib/mysql. How can I change the location to ...
0
votes
1answer
48 views

How to remote connect with PostgreSQL 11 CentOS server?

My Server: CentOS 7 x64, PostgreSQL 11.2 My Client: Navicat, pgAdmin 4.5 . Error at client: FATAL: no pg_hba.conf entry for host "14.248.254.146", user "postgres", database "postgres", SSL off I ...
0
votes
0answers
29 views

Why the postgresql process killed by oom before using swap?

I got one huge query to run on postgresql 10.6. The server got 64GB ram. Work_mem:6GB effective_cache_size:32GB shared_buffers:16GB The pgadmin4 always show out of memory for this query. The ulimit ...
0
votes
0answers
109 views

Restoring MySQL database data from ibdata1 and ib_logfile

I am trying to restore a MySQL database. I have the following: ibdata1 ib_logfile0 ib_logfile1 .frm files restored as I have a backup of the structure. Is it possible to restore the data for the ...
0
votes
0answers
12 views

CentOS7 Virtual Machine postgres10 not initializing

I had postgres9.6 installed and working the other day but the version wasn't compatible. I used YUM REMOVE to remove that one and then followed the instructions here https://www.postgresql.org/...
0
votes
0answers
33 views

PostgreSQL 9.6 on linux server gives a different collation than windows installation

I am running into an issue with a script that makes a backup towards the SQL. What happens is that with our script we make a dump of SQL we can read out to restore the PostgreSQL database. Our client ...
0
votes
0answers
17 views

Learning Percona Monitoring - CPU Usage

I've just started using the Percona Monitoring. I am not necessarily a db admin but I ended up with the task. I am enjoying it but truth be told I am not sure what I am looking at. There is an ...
0
votes
1answer
52 views

Postgres 9.6 - Taking differenctial backup

I have a few CentOS boxes running Postgres 9.6. I am planning a central server which can make local copies of all DBs on the other servers. These servers are accessible via SSH on Internet. What is ...
0
votes
1answer
42 views

MariaDB replication from master to slave

After doing some research around this topic, I should be attempting this task soon. However, I have two questions going around my head - could do with an experienced professional answering them. I am ...
0
votes
1answer
33 views

OS killed some of databse demons

I have 2 HP servers with CntOS 6 as OS and DB2 10.5 as Database. there 2 servers are HADR. standby server suddenly rebooted and when i checked log it said that OS had killed 4 db2 demons. IBM....
2
votes
1answer
507 views

Postgres 10 replica service error on startup

I have migrated a database promoting the read-replica in a server with more capacity, this process worked smoothly. But I'm trying to create a read-replica now from this promoted server to have a ...
0
votes
1answer
633 views

Postgresql sql import Permission denied! [closed]

Can't import db from sql file [user@localhost ~]$ sudo -u postgres psql [sudo] password for user: could not change directory to "/home/user" Password: psql (9.2.24) Type "help" for help. postgres=#...
1
vote
0answers
168 views

Error on cassandra-3.11.3-1.noarch centos7

I've a cluster consisting of 5 cassandra nodes. The cassandra version used is cassandra-3.11.3-1.noarch The keyspace strategy and is defined as follows: CREATE KEYSPACE my_keyspace WITH ...
2
votes
1answer
64 views

Database Directory storage is full need to change link it to new Partition

My mysql Database Directory size is full. So I want to change it to another partition where there is large amount of space. The database version am using is MySQL 5.7.23 and OS is CentOS 7. After ...
0
votes
2answers
96 views

Mysql 5.6 general log file output not showing unix timestamp

Mysql 5.6 general log file output not showing unix timestamp, so i wonder if there an option that i can execute to enable unix timestamp while logging general queries ? UPDATE : Here is example for ...
1
vote
1answer
156 views

MySQL database uses too much CPU and run very slow, help configuration

i need really your help, for set up best config for my website. I have a MySQL database which uses and it use too much CPU. 30-40% and then go to 100% up and down. If are connected few users or more ...
1
vote
2answers
8k views

How do I uninstall the old version of Postgres on CentOS 7?

I just installed Postgres 9.6 on CentOS 7. However when I run [root@server tmp]# /usr/bin/psql --version psql (PostgreSQL) 9.2.23 It still seems to be pointing to my old version. How do I ...
0
votes
2answers
182 views

Failed Starting mysqld on centOS 6

I'm a newbie in Linux. I try to install and run MySQL but when I start it it's got failed and this is my logs : 180426 18:01:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql ...
1
vote
0answers
426 views

Deleting old large global_log files CSV, CMS & FRM without SUPER privilege

I have an 12GB old log file /var/lib/mysql/mysql/general_log.CSV which I'd like to delete. I checked my.conf and general_log = 0 now but it was enabled for most of 2016. TRUNCATE table mysql....
1
vote
0answers
188 views

mySQL task with high cpu usage

Hi i had 2 servers with the same hardware and software configuration, booth servers had the same my.cnf flags. Centos 7.4 Cpanel Mysql 5.6 Multi PHP I execute a task on both servers, and on one of ...
0
votes
0answers
162 views

Managing multiple postgres versions on CentOS

I have the following packages installed with yum: Installed Packages postgresql92.x86_64 9.2.24-1.65....
3
votes
2answers
45 views

SQL Server on CentOS using CAL licensing

I have been running a PoC for a large data science workload with SQL Server on CentOS. I recently discovered that SQL is using only 20 cores of a 56-core server. I understand that this is because it ...
2
votes
2answers
7k views

Changing data directory for postgres on CentOS

I've got a postgres 9.2.18 installation on CentOS which used the standard installation path. Now I realised that on this particular partition, there isn't sufficient hard-disk space for some bigger ...
0
votes
1answer
311 views

Version not changed after updating PostgreSQL on CentOS

Actual OS and PostgreSQL versions: CentOS 7.3, PostgreSQL 10.1 to be updated to 10.2. STEPS: Stopping the service: /bin/systemctl stop postgresql-10.service Checking available package updates: ...
0
votes
1answer
794 views

MongoDB 3.4 Server not starting with bind error following a CentOS 7.4 security update

MongoDB 3.4 server is failing to start following a CentOS security update and reboot. No configuration changes made. The previous update and reboot a couple of days earlier did not cause any ...
1
vote
1answer
779 views

The server's DateStyle parameter was changed to ISO. The JDBC driver requires DateStyle to begin with ISO for correct operation

I use PostgreSQL 9.6.6 on CentOS Linux 7.4 and after upgrading the postgresql-jdbc package - # sudo yum update Failed to set locale, defaulting to C Loaded plugins: fastestmirror Loading mirror ...
1
vote
2answers
1k views

postgres user is not superuser

Im having some problems with my postgresql server. In particular, some databases cannot be dropped. On further inspection, I see that the postgres user is not a SuperUser. There are two other users ...
0
votes
1answer
48 views

When the number of users increases, the site is slowed down

I have a database with 25 M record in 42 tables(all tables is Myisam). When the number of users increases, the site is slowed down . pleas help me . Server Config: Linux , Centos Ram : 30 GB CPU : 20 ...
1
vote
1answer
5k views

Determine cause of failed MariaDB start on CentOS 7

We are a free/open source project. We are having problems determining why MariaDB 5.5.58 on CentOS 7 is not starting. The start problems happened after we enabled CentOS Software Collections (SCL) and ...
1
vote
0answers
1k views

FATAL ERROR: Upgrade failed when running mysql_upgrade on CentOS with SCL

We are a free/open source project. We have a CentOS 7 VM and it needed some software updated because the base CentOS 7 is stuck at PHP 5.4 and MediaWiki 1.26. We enabled Software Collections (SCL), ...
0
votes
1answer
361 views

Before Insert Trigger not firing

DELIMITER $$ CREATE TRIGGER `merchant_insert` BEFORE INSERT ON `merchant_table` FOR EACH ROW BEGIN INSERT INTO merchant_seq VALUES (NULL); SET NEW.merchant_id = CONCAT('MC', LPAD(LAST_INSERT_ID(),...
0
votes
1answer
192 views

Issue with MongoDB Replication Set

I have 3 "CentOs 7" VM's in AWS environment in which I have setup MongoDB Repication Set using below command. mongod --fork --logpath "/var/rs1/1.log" --replSet yogi --dbpath "/var/rs1/" --port 27017 ...
1
vote
1answer
200 views

MySQL queries stacking up and crashing

We have an application with around 300k active users. We have a dedicated database server which has the following configurations. The problem we are facing is that randomly we get alot of load on our ...
1
vote
0answers
77 views

mariaDB tables create_options clear

I have MariaDB 10.2.9 on Centos7 with ~60 tables. I listed the table's create_options from information_schema.tables: SELECT TABLE_NAME, TABLE_TYPE, CREATE_OPTIONS FROM information_schema.tables ...
0
votes
0answers
13 views

No effect on mysql memory consumption after reducing buffer [duplicate]

I have a server with 64 GB RAM. For the past few days the memory usage went to 51G for mysql (which crossed the threshold set). The configuration file is stated below [mysqld] federated ...
4
votes
3answers
6k views

Improving RAM and CPU utilization by PostgreSQL 9.6

I've been running a function on the database that is going into each table, ALTER COLUMN on all columns of a certain data type, and CAST to remove trailing zeros. About 115 tables varying from a few ...
1
vote
3answers
2k views

MySQL using 100% of CPU with 1500 active connections

I'm having a problem with MySQL. I have a system that runs some cron jobs and these create lots of database connections. When it reaches about 1500 active connections the cpu usage goes to 100% but ...
1
vote
1answer
296 views

Create extension hstore

I want to use hstore in my postgresql server running on CentOS 7 but hstore.control is not in my postgresql extension folder. I searched for that and came up with the solution to install postgresql93-...
4
votes
2answers
11k views

PostgreSQL service start failed on CentOS 7

Installed PostgreSQL using: sudo yum install postgresql-server postgresql-contrib PostgreSQL version: 9.2.18 When start service: sudo service postgresql start Got error: Redirecting to /bin/...
0
votes
1answer
64 views

How to roll back mysql 5.6 to sql 5.1

I recently updated mysql from 5.1 to 5.6 however it's causing too many issues with the websites hosted on my machine. Does anyone know how to remove mysql 5.6 and reinstall version 5.1.
0
votes
1answer
459 views

Slave Connection 1130

So I have a CentOS server that I have started to configure replication on my local machine. When I take a look at the master server with show master status;, I get the following: +------------------+...
0
votes
1answer
259 views

MySQL replication stops everyday for no (obvious) reasons

i've got a problem with my MySQL master-slave replication. It works just fine after i start it up but around 2:30am the next day it stops. Monitoring shows that the slave starts continously reading ...
3
votes
0answers
591 views

Problem: Remote connection with pgAdmin4

I just installed the Java and PostgreSQL environment on a server (for remote testing) CentOS 7 From the command line using ssh would seem that there are no problems in the sense that I can access the ...
0
votes
1answer
61 views

Restoring encrypted DB to SQL vNext

I wondered if anyone else may have tried restoring a copy of an encrypted database to an instance of SQL vNext. The instance I'm running has been installed on a CentOS box, but I'm not having any luck ...
0
votes
0answers
82 views

Installing MS SQL Server on Centos

Has anyone been able to install SQL Server on Centos 6? I am running Centos 6.8, and I can only find information on Centos 7. I know that SQL Server on Linux is still in its early stages. I’m curious ...
1
vote
1answer
3k views

MariaDB: Disable the GSSAPI plugin

How can i disable the GSSAPI plugin? I do not need authentication via Kerberos on my server. This is my environment: Centos 7.3 with SELinux mode enforcing MariaDB Server: 10.1.19 In my log file /...
0
votes
1answer
60 views

Importing a mysql database after drop filling up limited / in /tmp deleted file - A problem?

I'm importing a fairly large set of databases into a system which has a / partition only 10GB large. After a previous failed import, I dropped the database, but noticed /var/lib/mysql didn't exactly ...
1
vote
0answers
58 views

Centos 6 / Postgres 9.3 periodic “pauses”

Multiple times a day we experience "pauses" on our Postgres server of about 10-20 seconds where kernel CPU usage is high and everything else grinds to a halt. At the Postgres level this results in ...
0
votes
1answer
567 views

Cannot connect to database hosted at CentOS VM through SQL Developer on Windows

I've installed Oracle 12c smoothly today and was able to start lsnrctl and database. SQL*Plus connection is okay inside VM. I've set the IP address to be static @ 192.168.0.20 (CentOS VM). I am able ...
0
votes
3answers
2k views

Unable to change innodb_buffer_pool_size MySQL 5.6 in CentOS 6.7

I have searched all over but couldn't find where service mysqld restart picks up the configuration file from: sudo find / -name "*.cnf" | grep my /usr/share/doc/mysql-community-server-5.6.33/my-...