A widely-used open-source operating system that is particularly popular on servers.

learn more… | top users | synonyms

1
vote
1answer
18 views

XML database for linux

I want to be able to store multiple xml objects in a database. But I don't want to just serialize the object and dump it out. Rather I would like to be able to access the database representation of ...
0
votes
1answer
34 views

How do I get mysql to start for the first time?

I want to get mysql to start for the first time. I installed it on RHEL version 6. All of the commands posted were executed as root. As a test, I ran this: # yum install mysql This is the output:...
1
vote
1answer
23 views

Will a mysql db import be interrupted if my ssh session times out?

I have a large-ish (several GB) mysql DB that I'm planning to import via mysql -u root -p mydb < mydb.sql in a SSH session. What would happen if my SSH connection drops? Is it safer to run ...
0
votes
1answer
44 views

DB schema for storing the process tree of linux

I search a db schema to store the process tree of linux every half hour. Platform: PostgreSQL on Linux. I am unsure where to split all the data into columns or to use a json column. Which one is ...
2
votes
1answer
68 views

CRON and RMAN Backups

We run RMAN backups via CRON jobs, but find the out-of-the-box emails with CRON to almost do what we want. I know we can channel the RMAN output to /dev/null so no email is sent, which for any ...
2
votes
3answers
91 views

using tnsnames.ora and sqlplus client without installing oracle 11g server on linux client [closed]

I want to create a connection to remote Oracle server using SQLplus client and tnsnames.ora without installing Oracle 11g server on the Linux client. I used debian and bash script to generate reports ...
0
votes
0answers
20 views

network Adapter could not establish the connection in netbeans with oracle11g in linux

I am using fedora 23 64 bit. My system is up to date. I have installed oracle 11g xe. I have downloaded the jdbc driver 'ojdbc6" , now i am trying to connect netbeans with the oracle database but it ...
0
votes
1answer
47 views

Upgrading to MySQL 5.5 from 5.0 looks broken

I was using SLES SP3, and had earlier MySQL 5.0.67. I upgraded it to 5.5.48 (available with the CD) after upgrading my OS to SP4. I edited the /etc/my.cnf file, and replaced skip-locking to skip-...
0
votes
0answers
8 views

Is it advisable to configure huge pages on SLES for MySQL

What is a general opinion on using huge pages with MySQL server? As described in here: https://dev.mysql.com/doc/refman/5.7/en/large-page-support.html Or is it best to leave things as is and not ...
1
vote
3answers
44 views

Any script to auto test tune and benchmark mysql config?

I'm looking or willing to do a script to benchmark mysql config variations for a specific system. A script that would change certain mysql config values and do a sysbench, save results, change ...
0
votes
2answers
85 views

Error during Oracle database 12c Release 1 installation

I am trying to install Oracle database 12c on Oracle Linux 7 version. But it is keep on failing with the below error. [INS-30131] Initial setup required for the execution of installer validations ...
0
votes
0answers
83 views

mysqldbcompare SELECT command denied to user

I am trying to run mysqldbcompare to see the difference between two tables: mysqldbcompare --server1=server1:2016@localhost --server2=server2:2016@localhost user:user --difftype=sql --run-all-tests ...
0
votes
0answers
49 views

connecting to MySQL Database on local network

I'm trying to connect to my SQL database on my beagle bone black (Debian 3.8.13 MySQL version: 5.5.47) from my raspberry pi (Debian Jessie 4.1.13 MySQL version: 5.5.44). Both are on the same local ...
1
vote
1answer
31 views

Is there anyway that I can manually create a PID for the MySQL instance?

I am running MySQL on a linux server. I have taken a copy-back mysql enterprise backup from another linux full backup. Ever sense then I have had problems getting MySQL to start. The problem is ...
0
votes
0answers
31 views

myisamchk: Why is there a huge time difference running myisamchk in real and user time?

We have some MySQL MyISAM databases, whose backups are taken using mysqlhotcopy Thought to check the backups integrity, and errors (if any) and hence run myisamchk. I was tracking the possible ...
1
vote
2answers
320 views

missing files, installing Oracle DB 12c on Oracle Linux 7.2

when I try to Install the Database I get this error message: Source location is incomplete. Make sure you have downloaded and extracted all the relevant archives. I did try this twice with the same ...
1
vote
2answers
56 views

scaling options for mysql on linux vm (ubuntu) : how to scale when the RAID 0 is out of space

I was asked to give a scaling road map for our mysql database. Currently, I have a single mysql instance v5.6.28 running on an ubuntu VM on azure. It has a (software) RAID 0 disk made with two 1TBs. ...
0
votes
0answers
20 views

MongoDB job on CentOS 7 has file permission errors

I have a CentOS 7 server and I've been trying to start using MongoDB. At some point, I changed group & file permissions for the following: /var/lib/mongo /var/run/mongodb /var/log/mongodb What ...
0
votes
2answers
68 views

How to get when MySQL instance went down last

Is it possible to determine when a MySQL instance went down last? Is there a log file or literally anything at all that logs the server status in MySQL? I have trolled through countless articles ...
3
votes
1answer
31 views

how to “revoke” a “GRANT OPTION” from an mysql user/database?

i have a mysql installation with lots of users and grants. But one grant is unique, since its supposed to be a simple DB user and usually does not need GRANT privileges. However someone added it when ...
1
vote
2answers
48 views

How to log MySQL downtime

If I wanted to see the date, time and length of downtime on a MySQL instance/database, how would I go about doing that? For example, if I wanted to see if the MySQL database went down at all last ...
1
vote
1answer
16 views

Is there a limit to the number of database connections from a single machine in PostgreSQL?

We are planning on setting up multiple front ends behind a load balancer. I think our database can handle the load because I'm currently measuring a database TPS of about 450 for approximately ...
0
votes
0answers
107 views

MySQL Too Many Connections (Max Connections Limit Not Reached)

Running a PHP 5.6 application that connects via MySQLi to a MySQL database (5.5) that intermittently errors with the "Too many connections error" however this seems to be a red herring to another ...
1
vote
2answers
393 views

How to run Mongodb as a non root user in Linux?

I can start MongoDB as $sudo service mongod start. When I start without sudo it gives me this error: /etc/init.d/mongod: line 58: ulimit: open files: cannot modify limit: Operation not permitted /etc/...
0
votes
0answers
28 views

Resetting deadlock count statistics

It seems that just restarting the PostgreSQL service doesn't clear / reset the detected deadlock count. How can it be restarted to zero? select version(); PostgreSQL 9.4.5 on x86_64-unknown-linux-gnu,...
1
vote
0answers
110 views

Windows to DB2 Connection: Connection authorization failure occurred. Reason: Local security service non-retryable error

Error creating SQL Model Connection connection to TSMDB1. (Error: [jcc][t4][2010][11246][3.68.61] Connection authorization failure occurred. Reason: Local security service non-retryable error. ...
1
vote
1answer
67 views

Is there any trick to Resize LVM online that raw by UDEV rule without filesystem?

Here is the Logic Volume for example: lvcreate -L2G -n Lv_OraD1 vg_db lvcreate -L180G -n Lv_OraD2 vg_db lvdisplay /dev/mapper/Lv_OraD* UDEV rule to raw the LV: vi /etc/udev/rules....
1
vote
2answers
21 views

MySQL server feature gap on Windows and Linux

Is there any gap or difference in features of MySQL Server on Windows and Linux? Feature refers to below aspects: common DBMS functionalities such as Stored Procedures, Updateable Views, ...
0
votes
2answers
152 views

mysql too many connections in linux/nginx/php-fpm/php server

One of my mysql client reports "too many connections" of the mysql server. With the processlist of the mysql server, I find many connections come from a client with LNMP(linux nginx mysql php). The ...
1
vote
1answer
44 views

lat, long based search with $near shutdown my mongodb on Linux server

Hey guys i am stuck on critical problem & unable to resolve it. I have a project where there is a collection of UK postcodes having 18,00,000 sample postcode records. I have a search query where i ...
0
votes
1answer
32 views

Possible aproach for MySQL replication

This might be a duplicate questions asked before. But I need to understand a possible approach for my ENV running innodb engine. Is it possible to upgrade a Master MySQL Server to 5.5 to 5.6 and ...
0
votes
0answers
104 views

From RAC to Standby RAC With Active Dataguard

I have oracle database 11.2.0.3 with RAC feature , with 2 node on oracle linux 6.4 : ol6-112-rac1 and ol6-112-rac2 I want to create active data guard with RAC feature from this database , these ...
-1
votes
1answer
134 views

mongodb not working after install

I followed these steps at http://www.liquidweb.com/kb/how-to-install-mongodb-on-ubuntu-14-04/ as I usually do, since everyone on ubuntu knows the mongo docs don't work. I'm actually on kubuntu 15 I ...
0
votes
1answer
53 views

Reject Specific Database PostgreSQL User Authentication [closed]

Lets say I have two databases: Sales and Inventory And two users: A and B I want user A to be able to do: psql sales B But user A must not be able to do: psql inventory B Right now user A can ...
0
votes
0answers
54 views

oracle update statement is too slow

I have oracle database 11.2.0.4 on oracle linux 6.4 I have configure huge page on this OS . After 5 months of my projects , when i want to update any tables their have over 20,000,000 records , this ...
0
votes
2answers
74 views

ulimit 'open files' and MySQL max_connection

When running mysql on SSD, does max_connections, if set more than the kernel's ulimit open files, be limited to the kernel's limit? My understanding is that if the kernel's ulimit open files is 1024 ...
0
votes
0answers
53 views

Replication Error_code: 1032

I an unable to fix this as I don't know what cause this error. Replication was stoped for maintenance activity and after completing the maintenance we started it and then after some point the ...
0
votes
1answer
387 views

Slave not getting replicated SERVER_UUID error

Unable to start replication Master-Slave, I have searched a lot for this but unable to get the Server-UUID of both the server. Do we have any solution for this. Scenario: I have created new slave ...
0
votes
3answers
236 views

Error while installing MySQL on RedHat Linux

I am new to RedHat Linux and am referring to this link for the installation :https://dev.mysql.com/doc/mysql-repo-excerpt/5.6/en/linux-installation-yum-repo.html I finished the first two steps and ...
0
votes
0answers
55 views

Mysql Replication break Error_code: 1032

Created new slave replication, it was working fine but suddenly after 2 days its giving me this error and the replication stopped. Both on Centos 6.7 Master Version MySQL-server-5.5.41-1.el6....
0
votes
1answer
106 views

MySQL Tuning and optimization

How to Tune and Optimize MySQL Database, as a reference we are using mysqltuner.pl and we got the below output of slave host which we created recently. our future plan is the perform this same action ...
2
votes
1answer
29 views

Search and Replace in multiple MySQL databases

I have multiple MySQL databases(50+) and I want to replace a string in all of them, is there anyway to search and replace in all the databases? Server is CentOS and I have SSH root access.
0
votes
2answers
1k views

Setting root password in fresh mysql 5.7 installation

I am trying to install mysql in a serving having CentOS Linux release 7.2.1511. Take a look to the process installation: # sudo yum install mysql-server Output: Dependencies Resolved =============...
1
vote
1answer
298 views

Slave Waiting to reconnect

I have added new slave host to master for replication, but missing some of the parameters. mysql> show slave status\G *************************** 1. row *************************** ...
0
votes
0answers
42 views

MySQL replication Got fatal error 1236

I am getting this error when starting a new slave replication from master. Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'log event entry exceeded ...
0
votes
1answer
24 views

Mysql Replication backup and restoration failed multipal time

I tried restoring MySQL backup several time but unfortunately it gets failed by some or the new reason. I have 2 host Master & Slave with below details. Server1_Master os-centos6.7 mysql- ...
0
votes
2answers
98 views

unable to connect to oracle in linux terminal in oracle VM ,TNS listner not connected

i installed oracle VM , new to oracle vm. Can some help me in connecting to oracle in Linux termial and TNS listner is not responding with IO failure on sql developer when pressing test button ....
0
votes
1answer
100 views

Restoring MySQL dump ERROR 1449

I took hot backup (dump) from my Master MySQL DB with below command mysqldump -uroot -p --skip-lock-tables --single-transaction --flush-logs --hex-blob --master-data=2 -A > ~/dump.sql ...
0
votes
0answers
60 views

MySQL performance issue after migration

I have a MySQL performance issue with a brand new server, and am somewhat of a beginner as a database administrator (I'm mostly a general-purpose Linux sysadmin). I'm looking for pointers where to ...
3
votes
0answers
33 views

Bandwidth-efficient, fail-safe database resync with long backlogs

I'm looking for a DB system that allows slaves to resync even if there exists a long backlog. In addition these resyncs must be as bandwidth-efficent as possible as the nodes are connected over GSM/...