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

learn more… | top users | synonyms

0
votes
1answer
66 views

How to call the unix Sendmail from oracle

I know that is possible to send mails using the oracle-db by UTL_SMTP, and there are several examples of such usage everywhere. My question is: Can I call the GNU/Unix/Linux Sendmail to perform a ...
0
votes
0answers
53 views

Mysql database recovery in linux

Is there anyway to get back database if I deleted database. Is mysql creates temp file which contain temporary data from database and whether I can recover from that Edited: cp my.cnf my.cnf41 mv ...
0
votes
0answers
65 views

MYSQL backup options using mysqldump and mysqlbackup

I'm currently using mysqldump to backup mysql database. I heard that mysqlbackup offers a much much better performance. Unfortunately it requires MySQL enterprise version which is pricy. A few ...
-1
votes
1answer
93 views

Mysql Queries cause high load in server

I have problem in the database ,here is phpmyadmin status queries --------------------+ ...
1
vote
1answer
739 views

MySQL Workbench Cannot start SSH tunnel manager

I don't know why this error is happening when I try to connect by MySQL Workbench. Cannot start SSH tunnel manager. I'm using slackware 14.1 and installed all dependencies. I already installed the ...
1
vote
0answers
211 views

PostgreSQL refuses to listen on IP [closed]

This was a case of PEBKAC. By default, the listen_addresses line in postgres.conf is commented out. I failed to notice this and remove the comment. I'm trying to get a PostgreSQL 9.3 server up and ...
0
votes
4answers
83 views

Move MySQL database to another server

I need to move 20 Gb MySQL database from on Debian server to another. The problem is that there is no way to create its backup since there are almost no free HDD space on the source server. What would ...
-1
votes
1answer
112 views

Lost connection to mysql?

We're receiving the following error on every 1 hour. Lost connection to MySQL server at 'reading initial communication packet', system error: 115 "Operation now in progress" Any clue ?
1
vote
3answers
154 views

MySQL: How to avoid case sensitivity in SQL queries when migrate from Windows to Linux?

I have migrated my Database from Windows to Linux server. In many places, query has been written without focusing their cases (uppercase / lowercase). So, these queries are not getting executed and ...
2
votes
1answer
259 views

high background flush avg mongodb

similar question: High Global Lock % on Mongodb Overview We have a production setup replica set in v2.4.8 mongodb running on five 4-core, 28gb RAM VMs with standard azure datadisk HDDs running on ...
1
vote
1answer
161 views

InnoDB engine is not loading after tuning parameters

After installing MySQL-5.1.73, I placed default my-huge.cnf into /etc/my.cnf and started the mysql service. It was running without any issue. Now, I tunned some parameters in /etc/my.cnf file. Below ...
0
votes
0answers
34 views

Switching from Windows to LINUX server with lower configuration

As of now, My application is running on dedicated windows DB server which configuration is below: RAM 8.00 GB Processor Intel(R) Xeon(R) CPU X5460 @3.16GHz, OS Windows Server ...
0
votes
1answer
142 views

Difference between [mysql] and [mysqld] in MySQL configuration file

There are multiple sections in MySQL configuration file: [mysql] [mysqld] [myisamchk] [mysqld_safe] [mysqlhotcopy] [mysqldump] [client] I found that same variables with different values have ...
0
votes
1answer
180 views

How to create and start a PDB for RCU in Oracle 12c

So I've made a fresh install on a virtual machine based on OEL 6.5 x64. All my installs are in /opt/apps I installed a Oracle Database 12c, with the Desktop Version selected (not server), UNICODE ...
1
vote
1answer
83 views

Mongodb replica sets: why does my master server occupy more disk space than my slave?

I have two servers on my replica set. Let's call it the master and the slave, for the purpose of this discussion. The master was the original one, and the slave was replicated from that master. At ...
1
vote
1answer
64 views

What does this mean - ~/.my.cnf

When I run $ mysqld --verbose --help | less I got information like Default options are read from the following files in the given order: /etc/mysql/my.cnf /etc/my.cnf ~/.my.cnf As per my ...
1
vote
1answer
20 views

Unable to start mysql

I am using Oracle LINUX5. I installed MySQL 5.1.73 community edition through RPM command and it was working. Now, I stop mysql by running below command: $ mysqladmin -u root -ptmpassword shutdown I ...
0
votes
1answer
238 views

Report Builder cannot publish to report server

This is currently in a cloud lab environment. We're not allowed to join any AD domains. We have a linux server (RHEL 6) running MySQL 5.3 and a Windows SQL Server 2012 on Win 2k8 R2. Our laptop is ...
0
votes
0answers
429 views

MySQL - Out of memory: Kill process 3046 (mysqld)

We run a MySQL (v5.6.17) dump backup every 4 hours, and today noticed: Apr 19 20:09:30 mysql1 kernel: Out of memory: Kill process 3046 (mysqld) score 970 or sacrifice child Apr 19 20:09:30 mysql1 ...
1
vote
1answer
356 views

MongoDB on Raspberry Pi --dbpath not setting

I installed MongoDB using this tutorial. I have tried to set --dbpath in /etc/mongodb.conf like this: dbpath=/path/that/iwant #where to log logpath=/var/log/mongodb/mongodb.log logappend=true ...
-2
votes
1answer
88 views

MySQL ran out of space, now won't start

So the partition MySQL was mounted on ran out of space. As a quick fix, I decided to move mysql's data directory to /home/minecraft/mysql/. I then changed the datadir in the config to the correcy ...
0
votes
4answers
1k views

PostgreSQL 9.3 on Ubuntu Server 12.04 v.s. MS SQL Server 2008 R2 on Windows 7 Ultima

I have searched many articles in Google about the performance of PostgreSQL vs MS SQL 2008 R2 and found that many of those articles say the performance of PostgreSQL is better than that of MSSQL 2008 ...
0
votes
1answer
504 views

Unable to Start PostgreSQL. kernel's SHMMAX parameter exceeded you limit

When I am trying to start my PostgreSQL I get the following error in the Postgresql.log file: FATAL: could not create shared memory segment: Invalid argument DETAIL: Failed system call was ...
1
vote
1answer
43 views

Which version of linux OS has support for MongoDB installation?

I would like to learn how to install MongoDB in my Windows machine. Currently I have a Windows 8 64 bit OS laptop and I installed MongoDB 64 version for Windows. My question is: which version of ...
0
votes
2answers
117 views

Make Oracle backup files available for duplicate

I have a Red Hat Enterprise Linux server with Oracle 10.2.0.5 and a database on it (SID is TNATEST). I have a remote CentOS server with Oracle 10.2.0.5 on it that I want to duplicate TNATEST to. The ...
0
votes
2answers
85 views

MySQL - prevent OS cache for query

On high load production server I have many sql selects which are unique or re-use will be in hours. I use SQL_NO_CACHE but this queries are still cached with OS cache. Server have 64G ram and used ram ...
0
votes
0answers
74 views

Can I set a lower_case_table_names value for a specific database?

I'm running a MySQL 5.5 on Linux (Debian 7) with several databases. I need to import a database originally maintained in Windows MySQL using sqldump. My issue is that this database is used by a ...
1
vote
2answers
271 views

Why Can't I find my databases from Mysql on linux?

I'm new to linux. I cannot get a list of my databases by typing SHOW DATABASES on the MySQL shell. Though this MySQL program is aware of the MySQL datadir because it is listed when I type SHOW ...
0
votes
1answer
311 views

Postgres memory usage too low

I have a 400GB Postgres 9.3.4 DB running on Fedora20, and a few indices per table. I have upped shared buffers to 4GB (the system has 16GB available), set shm in the kernel and set the ...
0
votes
1answer
315 views

Using environment variables in data pump query

I have been trying to use data pump (expdp and impdp) in order to retrieve some data from a database to import it into another. I am using the expdp using the table and the query parameters in order ...
0
votes
0answers
40 views

MySQL/MariaDB CLI limits max password?

I've got strange problem - my MariaDB instance CLI (Linux) does enforce limit on how long password can be. For example, setting password like this UPDATE mysql.user SET ...
0
votes
0answers
53 views

mysqlcheck -o --all-databases does not finish

I have a problem with my MySQL Databaseserver. I have many tables and there is quite some traffic going on there (around 4 connections per second). Since the phpMyAdmin advised me to do a OPTIMIZE ...
3
votes
2answers
658 views

Does a MyISAM table locks if I copy it while MySQL is running? (READ DISCLAIMER)

DISCLAIMER: I'm very aware this is not supposed to be done, but time consistency between tables aren't a concert here and Im trying whatever pops in my mind right now to have alternatives for ...
0
votes
2answers
121 views

Can CPU cores be separated for MySQL?

Is it possible to separate CPU cores in Mysql? I understand it is possible for Memory as we can tune it in innodb_buffer_pool_size or innodb_additional_mem_pool_size. How about CPU cores in ...
1
vote
2answers
312 views

Linux command to kill all MySQL sessions from a specific User?

How can i kill all sessions from a user in mysql using a linux command line command? I have a user that is using all on my database connections and insted of killing one by one i want to make a ...
2
votes
3answers
281 views

Move Complete ORACLE from one system to another

I have 2 identical server with exact disk partitions (OS CENTOS 6.4 both ) [My college central oracle server]. Entire ORACLE HOME ( bin , control files, data files everything on oracle) is on 2nd ...
0
votes
0answers
74 views

MariaDB : Larger innodb_buffer_pool_size causing SQL updates to be slower

Has anyone here encountered such scenario before where and update statement took longer time to run when innodb_buffer_pool_size is bigger. I've run a few tests using the same statements on around ...
0
votes
3answers
164 views

How to use Oracle Installation Prerequisites on Redhat Linux 6.5?

Today I get error below when install Oracle 11gR2 on Redhat Linux 6.5. I follow instruction in this link: http://public-yum.oracle.com/ After I call this command: # yum install ...
1
vote
1answer
228 views

Trouble with installing additional modules on Postgresql 9.1 on ALT-Linux

I'm trying to create extension under postgresql 9.1 (Linux): CREATE EXTENSION pg_trgm; but got error: ERROR: could not open extension control file "/usr/share/pgsql/extension/pg_trgm.control": No ...
0
votes
1answer
172 views

I'm trying to run an oracle database in virtual box under oracle linux

I'm trying to run a oracle DB in VirtualBox and access it from my host mac OSX , i am using port forwarding to access my guest, I can telnet my guest on the port, however when i try to connect from ...
0
votes
2answers
70 views

MySQL: Moving Database from Windows to Linux

I have a Windows based dedicated server have below configuration: Windows edition: Windows Server 2008 R2 Standard Service Pack 1 Processor: Intel(R) Xeon(R) CPU X5460 @3.16GHZ 3.16 GHZ (2 ...
0
votes
0answers
105 views

Postgresql on Slackware 14.1 (64-bit) Cluster Error

I am attempting to install Postgresql Database on Slackware 14.1. However i am getting an error: Problem running post-install step. Installation may not complete correctly The database cluster ...
1
vote
1answer
119 views

Heartbeat Options with MySQL and Possibilities

I would like to understand if the following scenarios are possible in Heartbeat in Linux. Setup: Two Database Servers running Mysql in Active/Passive mode in replication mode having Heartbeat setup ...
0
votes
2answers
66 views

ORACLE Shifting from from one version to another

I have RHEL5 server with Oracle Home actual location is SAN, which is mounted on this server. Now for few Reasons I have one more Server with RHEL 6 64Bit. I will map those storage LUNS there. What ...
0
votes
0answers
45 views

MySQL import low use of resources

I'm importing a largish DB into MySQL (20tables of ~25mill records). As expected this is taking a long time, but I'm curious as to why the process is running using only 0.000 to 0.700 %CPU and 0.87 ...
1
vote
1answer
26 views

How can I create DB2 objects with Linux SUDOer authority?

All, I am relatively new to Red hat linux and I have SUDOer authority but unable to create DB2 database or other objects. How can I accomplish this task? Please give examples. Also, is there any ...
0
votes
1answer
40 views

Couldn't connect to databasee

I have a dedicated webserver and a dedicated database server Often , i got errors connecting to database server couldn't connect to database Here is my current /etc/my.cnf configuration file ...
0
votes
3answers
2k views

how make mysql table name case insensitive in ubuntu

I am using Ubuntu 13.10 and Mysql 5.6 and I know Database Name and Table Name are case sensitive in Ubuntu(some *nix) environment. Now i want mysql should work for as case insensitive. Is it possible. ...
0
votes
0answers
38 views

Probable database replication issue in LAMP setup with Master/Master MySQL replication

I have been facing issues in my high availability failover (on WAN links) LAMP setup hosting a Drupal CMS based site, approximately after every 2 months both servers suddenly stop responding to http ...
0
votes
0answers
36 views

What is the “Other” Memory Pool in DB2 LUW?

I have a Memory Pool consuming the better part of my server's memory, but I can't seem to find any proper documentation on what this Memory Pool actually is for. What is the "Other" Memory Pool in ...