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

learn more… | top users | synonyms

0
votes
0answers
22 views

Recommended Database(s) for Selecting Random Rows

I'm familiar with selecting random rows from a table in PostgreSQL. It's really slow. I've looked into some other databases and they all seem to be bad at it. Mostly because it's not a normal use case ...
0
votes
1answer
9 views

MySQL / DRBD / Pacemaker on EC2

I am trying to setup DRBD/MySQL/Corosync/Pacemaker on AWS EC2 instances, though I am not sure if it will work since how to integrate VIP is a problem for me. Anyone have any thoughts on what to do ? ...
1
vote
0answers
14 views

grastate.dat with seqno -1 on a healthy cluster. Why?

We use those versions: # rpm -qa | egrep '(galera|maria)' mariadb-libs-5.5.41-2.el7_0.x86_64 mariadb-galera-common-5.5.40-6.el7ost.x86_64 mariadb-galera-server-5.5.40-6.el7ost.x86_64 ...
1
vote
1answer
16 views

How to determine if pg_dumpall is still running

Environment: Postgres 8.4 Debian Squeeze LTS Recently we switched from a backup solution around hot_backups to using pg_dumpall. This solution used a pid file as long as the hot_backup was ...
1
vote
1answer
20 views

Moved a MySQL Database to another server, but socket keeps pointing to localhost

I know I shouldn't bother with this, maybe I should disable the old mysql, but this is a Magento virtual appliance from Bitnami thats work as a whole (application and database on the same server). I ...
0
votes
1answer
26 views

Some tables not found after moving MySQL database from Linux to Windows

I had a MySQL database which I was working with from Linux. Some of the schema/table names were in mixed case. I then needed to work with the same database on Windows, but because of the enormous ...
2
votes
1answer
51 views

MySQL (MariaDB - 10.0.16-MariaDB-1 (Debian) strange performance issues

I am running version 10.0.16-MariaDB-1 (Debian GNU/Linux 8.1 (jessie)) on Dual Xeon CPU, total 32 cores with 128 GB of RAM. This is a dedicated DB server and has been recently migrated over from ...
1
vote
2answers
37 views

MySQL : How to restore mysql dump (.sql) ignoring DROP TABLE statement?

I am trying to restore multiple mysql dump (.sql) files. Data in each dump file are from the same table, but with different ID (primary key) range. For example, > 1.sql (0 < ID && ID ...
0
votes
0answers
53 views

Oracle Performance on 2 servers

I have the same database on two different servers(production and test) with major differences in query time as follows: Query1: SELECT distinct dms_get_FAST_serverpath(d.id) full_name FROM ...
0
votes
1answer
37 views

Cannot Start mySQL Daemon with Error “mysqld from pid file … ended”

I cannot get MySQL to run. It was working just fine hours ago, but upon starting, repeatedly ends without telling me very much. Here are my logs [myusername@location ~/mysql]$ ./bin/mysqld_safe ...
1
vote
1answer
36 views

Can't create file /var/lib/mysql/user.lower-test

MySQL database has been problem free for a few months. Today when I checked for upgradeable packages using the Synaptic Package Manager it came up with the various MySQL components (-common, -client, ...
1
vote
1answer
18 views

Package Check Failed: Oracle DB 11g on RHEL 7

Trying to install Oracle DB 11g EE on RHEL 7. Installed the necessary packages as mentioned in the below link (Section 6.1). But I am stuck at the package check step, which fails because it couldn't ...
2
votes
1answer
46 views

How to download Oracle Database 11g release 2 for Mac OS

I have been trying to download Oracle Database 11g release 2 for mac os but in the given link by oracle I can only see Linux x86 and Linux x86-64. Is this ok to use this Linux file for installing ...
2
votes
2answers
85 views

sqlplus (Oracle XE) doesn't start on CentOS 7

I followed the steps of this document: https://docs.oracle.com/cd/E17781_01/install.112/e18802/toc.htm#XEINL121, but sqlplus doesn't start. Even if I used the command: "sqlplus /nolog". The other ...
0
votes
1answer
42 views

New Master-Master replication has stopped working

We're building a new MySQL server pair for high availability, and of course it's not like managing a single server. We're working with Ubuntu 14.04 LTS and MySQL 5.5.43 I had master-master ...
0
votes
1answer
35 views

Unable to create replica set for MongoDB in Linux

When I run the following command: rs.initiate(), I get the following error: "info2" : "no configuration explicitly specified -- making one", "me" : "ip-10-0-2-113:27017", "ok" : 0, ...
0
votes
0answers
32 views

Oracle 11g installation on fedora 20 - stuck at step6 - Oracle-base.com installation procedure

I am trying to install Oracle Database 11g Release 2 (11.2.0.1) On Fedora 20 (F20)Oracle 11g in my laptop and I am following the steps provided in this Link But it is getting stuck after step 6. Can ...
1
vote
0answers
122 views

Failed to create voting files on disk group DATA

I has install Oracle RAC 11.2.0.3 on Oracle Linux 6.6 for 2 node. When install clusterware to step excute root.sh had got error below. Can you help me check how to fix that and what wrong while ...
1
vote
1answer
32 views

Moving postresql 9.1 database - live

This question has probably been asked and answered before, and if so, I would appreciate if that could be pointed out to me. I have googled this point quite a bit, but I want to be very sure as to ...
1
vote
1answer
19 views

How to reinitialise /var/lib/mysql files?

Due to a mishap I deleted the entire /var/lib/mysql directory. Since the database did not contain anything important, I do not want to go through the hassle of restoring it from an old backup, but ...
1
vote
2answers
54 views

MonetDB auto-backup mechanic problem

I'm trying to set up mechanism that will automatically create database backup. The idea is to create a script that will be executed by crontab. Seems easy but I'm struggling with the following ...
0
votes
2answers
109 views

MySQL Monitoring Script in Shell or Perl for Linux

I need a MySQL Monitoring Script in Bash or Perl for Linux. I found some but they are quite big with a lots of checks that are not useful at all for me and in this case I should customise the ...
0
votes
1answer
50 views

I want to start the Postgres database

I run this: $ postgres -D foobar It just hangs. There is no error message. I newly created this database with the initdb command. What should I do?
0
votes
1answer
48 views

Intermittent “access denied” (1045) message from MySQL

I'm importing a fairly large (100GB+) database from MySQL to PostgreSQL using pgloader. After a seemingly random amount of time the process dies with the following error: An unhandled error condition ...
0
votes
0answers
30 views

Memory consumption of production MySQL

The MySQL database on one of my production servers consumes a lot of memory. The problem is that I cannot trace what causes that kind of high memory usage. Following values illustrate the problem. ...
0
votes
1answer
41 views

How to create oracle user for more than one version

I have server under RHEL 6.3 installed on that server Oracle 11gr2 and 12c, I want to create user lets say Ahmad but I want this user to be sysdba on both servers, for single server I edit ...
0
votes
0answers
16 views

how to install lib_mysqludf_xql?

Can any one provide me a steps how to install lib_mysqludf_xql? OS version is REHL 6.5(64 bit) and MySQL version is 5.5.27 we installed MySQL with the source code.
0
votes
0answers
37 views

How do I dump my DB without creating temporary files?

My system is showing disk problems, and linux turned my root folder to read-only. Before I reboot, I wanted to backup my mysql DB, just in case I can never access it again after rebooting/checking ...
1
vote
0answers
72 views

postgresql + pgbouncer, idle server and high cl_waiting

I have such a setup: OpenSUSE 13.1 64-bit Linux kernel 3.11.10 PostgreSQL 9.0 + PgBouncer 1.5.4 (libevent-2.0) 16 core AMD, 128 GB RAM PostgreSQL config: max_connections = 1500 shared_buffers = ...
3
votes
1answer
161 views

Sharing PostgreSQL database on one dual-boot machine without duplication (cross-platform)

I have PostgreSQL 9.4 installed on a dual-boot machine (both on Win 7 and Ubuntu 14.10). The two systems share a drive (NTFS-formated) which includes a PSQL database directory which was created under ...
0
votes
0answers
67 views

Can't auto-start db2 with db2iauto

Followed guide Auto-starting instances . [root@oktest-stage-db-1 ~]# db2greg -getinstrec instancename=db2inst1 | grep -i startatboot StartAtBoot = 1 [root@oktest-stage-db-1 ~]# ...
0
votes
1answer
51 views

Ubuntu broken need to recover mysql db

With a recent Ubuntu upgrade it has broken my system. I now only have access to the filesystem through a live CD. I had a MySQL database on the system with many objects and views I would hate to lose. ...
-1
votes
2answers
23 views

How can I create Data Base on phpMyAdmin?

I have a serious problem here. I am not able to create data bases as the option is not to be found on my phpMyAdmin, but it only shows 'No Privilege' in red font. I even tried to create data base ...
0
votes
1answer
115 views

MySQL table doesn't exist

What I did before the disaster was: vi /etc/my.cfg I added innodb_buffer_pool_size=4G innodb_buffer_pool_instance=2 innodb_read_io_threads=12 innodb_write_io_threads=12 innodb_io_capacity=300 ...
0
votes
3answers
210 views

MySQL Exporting a query to text file via Cron Job

I'm in the beginning stages of hacking together code that syncs two completely different pieces of software/webware. I'm looking for a way to run a SQL query and output the results to a text file. I'd ...
0
votes
1answer
86 views

Unable to get any type of connection using mysql on LAN

My question is rather simple, I have a Windows 7 machine that is hosting an Apache server and a MySQL server using the XAMPP control panel. Both of these have been installed as a service on the ...
2
votes
1answer
204 views

MongoDB installation Ubuntu 12.04 LTS errors

I need some help with my MongoDB installation on a clean, fresh Ubuntu 12.04 LTS server with no nonsense installed. I thought it would be a piece of cake, but I got some errors and the Ubuntu-forums ...
1
vote
1answer
186 views

How to restore database from /var/lib/mysql

I have a database folder from a crashed server called gain_wordpress. I'm trying to put that database on a new server but I'm not able to do it successfully. I don't have a .sql dump, all I have is ...
0
votes
1answer
44 views

How do i prevent executing os command in oracle 11g

I have Oracle 11g installed on a linux serveur and i'm looking for a way to prevent sysdba from executing system command through oracle(Using java for example).
0
votes
1answer
1k views

How to fix “TNS:listener does not currently know of SID given in connect descriptor” with DBVisualizer on Linux?

I am trying to connect with Oracle database from a server having Oracle client installed (RHEL Linux Environment). I installed DB Visualizer on client machine. But getting listner error on hitting ...
0
votes
1answer
32 views

Will 'sleeping' connections open files other than the socket in MySQL?

Recently, in our MySQL replication setup, the replication slave crashed due to 'too many open files' error. We brought it backup, but trying to figure out what caused the unexpected hike in the number ...
3
votes
1answer
228 views

Problems restoring backup from base backup + WAL with WAL-E

I'm trying to do nightly restores of the main database on a separate node. I want to do weekly full restores and nightly restores by consuming the latest WAL files. On the master I have wal_level = ...
0
votes
1answer
96 views

Setting MySQLDump to keep running in the background after session times out

I'm tryng to set up a new Slave DB by copying another Slave DB. Normally I would simply use MySQLDump to dump the Slave and create a .sql file, then import that into the new database. However, as our ...
0
votes
1answer
59 views

MySQL does not generating PID file

I upgraded my OS from redhat 2.6.3 to 2.6.5 after that when I restarted my MySQL server but it not started, error message is "150320 11:53:17 [ERROR] Error message file ...
0
votes
1answer
53 views

What limits the number of connections?

As per https://devcenter.heroku.com/articles/heroku-postgres-legacy-plans the connection limit is 500 As per https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server "Generally, PostgreSQL on ...
-1
votes
1answer
45 views

Server has antivirus. Do I need to enable external locking on MySQL?

From MySQL docs: If you only read tables with other programs, external locking is not required Assuming the bytes of MySQL files does not match viruses, the antivirus will not change the ...
0
votes
2answers
86 views

In mongodb, is “sh.getBalancerState() is false” the same as “sh.isBanlancerRunning is false”?

During upgrading config servers to use WiredTIger, I stopped balancer using sh.setBalancerState(false), and then I run sh.getBalancerState(). The output is false. Does this mean the balancer is not ...
1
vote
2answers
109 views

MongoDb Upgrade from 2.6 to 3.0 Issue [closed]

For some reasons I cannot install MongoDb 3.0 version. What am I missing?
-2
votes
1answer
75 views

any advantage or disadvantage to have mysql 5.6 on a linux server over on a window server [closed]

i am planning to decide to use mysql5.6 on a window server 2012 or a linux server. Can someone gives me some general advises between the two?
0
votes
0answers
17 views

Index creation issue with MySql and Linux

MySQL Server database is installed on RHEL5.5 and db version is 5.6.20 Community Server. In MySQL database we have a table and it has 11,144 records. I am altering the table and adding index to it. ...