The choice of settings for hardware, firmware, software or other components of a database system.

learn more… | top users | synonyms (1)

3
votes
2answers
477 views

Setting shared_buffers in postgresql.conf does not seem to take effect

We're on CentOS release 6.6, PostgreSQL version 8.4.20. (Yes, this is not bleeding edge.) In postgresql.conf, we have: shared_buffers = 4096MB kernel shm values are set nice and high: [root@green ...
0
votes
1answer
261 views

Non-Replicating commands from (master) Mysql 5.5.40 to (slave) MariaDB 10.0.19

CRUD replicates just fine. But we noticed that DB structure altering commands such as ALTER TABLE and/or adding/updating columns to a table and even creating new ones do not replicate to the slave at ...
1
vote
2answers
416 views

TempDB default number of files in SQL Server 2016

Noticed the docs for SQL Server 2016 CTP2 state "by default, setup adds as many tempdb files as the CPU count or 8, whichever is lower." https://msdn.microsoft.com/en-us/library/bb510411(v=sql.130)....
0
votes
1answer
1k views

could not open log file “/var/log/postgresql-2015-05-24_181212.log”: Permission denied

I installed postgresql from source on Ubuntu 14.04 (I also installed from repositories too before, I just want to get a feel for both of them right now, as I will heavily rely on this database). So ...
2
votes
2answers
471 views

Mixed SQL Server instances with static and dynamic ports

Let's assume someone has 5 different SQL Server instances running on a server. Initially all are using dynamic ports. Is it safe to restrict one of those instances to use the static port 1433 while ...
1
vote
1answer
56 views

Increase memory limit when server is stopped

There was a local SQL Server 2012 instance. Once memory has decreased to critical 128 MB and then has stopped by me. I can not start it (idea: not enough memory). Is it possible to increase this ...
0
votes
2answers
202 views

Best configuration for MySQL? InnoDB and MyISAM

I read that InnoDB is supposed to be better at writing into MySQL than MyISAM, however, I'm trying it out, by running 3000 MySQL queries(Inserting rows, 8 Columns + id)... but results haven't turned ...
0
votes
1answer
1k views

how do I configure postgresql to find the pg_controldata command [closed]

I am trying to execute the pg_controldata command, I got the error command not found. Then I checked: ls -l /usr/lib/postgresql/9.4/bin/ | grep "control" -rwxr-xr-x 1 root root 25960 feb 5 18:24 ...
0
votes
1answer
25 views

Remote connection to DB instance from fresh formatted system?

I have 1 win7prof fresh system. Now I want to connect to a DB instance remotely via sqlcmd/any other way. My req is to connect and execute select query? is there any method/software needed to be ...
2
votes
1answer
6k views

Cannot connect to SQL Server from Management Studio (both 2012)

I installed SQL Server 2012 Express. It seems to be running fine. My SQL Server Configuration Manager looks like this: From what I understand it means that my instance is called MSSQLSERVER. ...
0
votes
0answers
41 views

SQL Server consuming large amount of RAM [duplicate]

I have Server 2012 with two 2.10 Ghz processors and 64GB of RAM. I have SQL server 2008 installed on this server. but this SQL server is consuming 70-80% of memory. I have limited SQL memory to 24GB ...
1
vote
1answer
53 views

Where do I set the I/O size for DB2 9.7 LUW driver (AIX 6.1)?

I am looking to change the I/O size returned from the DB2 server for query results. (As per below instruction from SAP BODS 4.X performance optimization guide) Increase the size of each I/O from ...
4
votes
1answer
746 views

Moving DB Log destination?

I currently have SQL DB and Log files going to the same drive. I would like to move the Log files to their own drive. Is there an easy way to achieve this and will it require downtime/reboot of the ...
0
votes
1answer
39 views

Restore of db's on local locks me out of accessing other sites

Running my local dev websites on my Mac locally and when I am restoring a database via terminal, which the restore is running I cannot access anything that uses mysql, I get a broken pipe notice. Is ...
5
votes
7answers
10k views

MongoDB doesn't start after changing the data directory

I have installed a mongodb instance using yum.. Now everything works fine. I started the service using service mongod start. It works well. Then I changed the data directory and log path in the ...
2
votes
1answer
2k views

When upgrading config servers to use WireTiger, the running config server with wiredtiger does not authenticate the existing pass and user?

In order to upgrade mongodb to 3.0.0, I am upgrading my config servers to use WireTiger. I followed the subsection of Change Config Server to Use WiredTiger. There are 18 steps. I run mongodump --port ...
2
votes
2answers
166 views

Current SQL Server services configuration

I know I can use SQL Server Configuration Manager to determine 1) Which services are currently running and 2) which services are set to auto start. However, I have several dozen servers I manage. I'd ...
3
votes
3answers
161 views

Is Policy-Based Management dead? Is it scalable?

Policy-Based Management was introduced in SQL Server 2008. I'm looking for software/tool I can use to enforce configuration standards across a SQL Server 2012 /2014 database environment. Instances ...
1
vote
1answer
188 views

How to transform Streaming Replication Master-Slave to Cascaded Master-Slave1-Slave2 setup?

I've setup streaming replication as part of HA solution on my production enviroment. I've two ubuntu servers PROD1 and PROD2. PROD1 is master and PROD2 is slave. In case of failover the slave database ...
1
vote
1answer
751 views

MySQL: SELECT GET_LOCK slow/timeout

I am using "Zebra Session" as a replacement for PHP's built-in session management. Zebra Session stores sessions in a MySQL database, and uses "session locking" in order to ensure that data is ...
2
votes
1answer
2k views

Can I reduce MySQL memory usage, or do I need to add more RAM?

I have a VPS with 2.25GB of RAM. MySQL is using 1.4GB with only four users on my site right now. It seems to use this amount even when no users are online. The available memory of my server regularly ...
1
vote
1answer
50 views

Recommendations for my.cnf on MySQL Replicant

I have replication environment running in a master-slave configuration. The replicant is doing all writes and doing selects only very rarely - and none in which high performance is a requirement. ...
1
vote
1answer
399 views

SQL Server Service's Log On As account

I just inherited a set of new servers and whoever set them up left the "Log On As" account as the default "NT Service\MSSQLSERVER". I'd like to change that over to an Active Directory service name. I ...
1
vote
2answers
3k views

Mariadb on Centos 7 not changing max connections based on my.cnf

The following configuration in my.cnf is not being followed. Max_connections go back to 151. please help as i have 16gb of dedicated ram that i would like to use properly. [mysqld] datadir=/var/...
0
votes
1answer
101 views

Help with MySQL my.cnf config

So I'm running MySQL on a high availability cluster with the MySQL data directory on a GlusterFS. I want to: - Disable the query cache (--query-cache-size=0) - Switch on external locking (--...
1
vote
2answers
422 views

Mariadb refusing to read values on the my.cnf file

today i was optimizing my mariadb since my website was running too slow My machine is a Centos 7 , 4 gbs ram 3 cpu i runned a script called mysql_tuner.pl and the results were: -- MYSQL ...
6
votes
1answer
20k views

SQL Server service account Windows privileges and rights

My question is, if you create a new domain user account for each of the SQL Server processes, what permissions should be set for each account? Or does the SQL configuration manager actually take care ...
1
vote
2answers
275 views

Query cache size in SQL Server 2014

Is there a way to define/set/increase the query cache size in SQL Server 2014 similar to what MySQL has http://dev.mysql.com/doc/refman/5.0/en/query-cache-configuration.html
0
votes
0answers
456 views

Why mongod said “note: noprealloc may hurt performance in many applications”?

I just start mongod with config file: mongod -f /etc/mongod.conf In /etc/mongod.conf, I set storage.preallocDataFiles=true This is a part of config: storage: dbPath: "/data/db" ...
2
votes
1answer
1k views

How to add setParameter in mongod config?

When I am using setParameter in mongod config, I start mongod with error: Unrecognized option: setParameter = enableLocalhostAuthBypass=1 How can I use setParameter from config file ? P/S: I am ...
4
votes
3answers
2k views

TNS-12541 Error

I have grid installed in my pc but the problem is LISTENER does not start automatically. I have to start listener manually and then only LISTENER get started. But before starting listener if you check ...
3
votes
1answer
223 views

Trace Flag 3688 not working on SQL Server 2014

We are using some third party tools that fill up the SQL Server logs with entries like: SQL Trace ID 1 was started by login "sa". SQL Trace ID 2 was started by login "XX\xxxxx". SQL Trace stopped. ...
1
vote
1answer
3k views

What are the optimal mysqldump settings?

After some search I ended up with the following settings: mysqldump\ --host=localhost\ --port=3306\ --databases ****\ --user=****\ --password=****\ --default-character-set=...
1
vote
1answer
126 views

SQL Server configuring both UCP and MDW on a single server

I'm trying to configure both UCP and MDW on a SQL Server. I have already setup UCP and it created [sysutility_mdw] database. Now when i try to setup MDW it is trying to use sysutility_mdw database ...
2
votes
1answer
292 views

SQL Hard Drive Config?

I am setting up new server and am a little confused in my research of HD configuration. My main question is : Is it recommended to have the Trans Logs and DB logs (ldf) on separate spindles or can ...
5
votes
1answer
476 views

Restarting database server or just the database

I am an application programmer. We have a SQL Server 2012 instance that hosts many related databases (around 12 databases). The vendors did some changes to one of the database and the application and ...
0
votes
1answer
69 views

Error on mongos server

Firstly,I am new to mongodb. when we executed the below command on mongos server. /usr/bin/mongos --configdb X.X.X.1:20001,X.X.X.2:20002,X.X.X.3:20003 --port 27017 --chunkSize 1 we are getting the ...
0
votes
2answers
590 views

my.ini configuration for a huge server

I have developed a web based app in PHP MySQL and Flash Builder. It was running fine until a few days ago when the client began to connect a lot of users. Then the app started to freeze and sent ...
3
votes
4answers
9k views

SQL Server 2008: how much RAM memory should SQL Server use in a 8GB RAM server?

We have SQL Server 2008 and 8GB RAM in a customer, hosted in a Windows 2008 R2 SP1, and consider the following amount of free memory: and consider the following running programs: Scenario: ...
1
vote
2answers
3k views

Mysql Server 5.6 Mysqld high memory consumption

I have MySQL Server 5.6 installed in a development machine with these specs: RAM: 4 GB Windows 7 Professional 64 bits Intel Pentium CPU G630 @ 2.70 GHZ Since I installed the MySQL Server, the ...
1
vote
2answers
14k views

Oracle Database 12c on Oracle Linux 7 - autostart, enabling connection as sysdba

I've installed 12c on Oracle Linux 7 for my development work, as per document Oracle Database Installation Guide 12c Release 1 for Linux (E41491-10). My previous experience with administering Oracle ...
1
vote
1answer
52 views

Mathematical or Computing Alternatives for MySQL Combination Queries operating toward their Performance Limit

We regularly run a contest that is becoming quite popular. In the contest, we need to select the combinations of contestants from 8 groups whose cost is under a threshold, and who combined have the ...
6
votes
2answers
2k views

Transaction speed benchmarks for mySQL v5.6 replication - seems very slow

I'm trying to select the best configuration for our new infrastructure but got a bit confused about the results. I used sysbench v0.5 for the tests: prepare data sysbench --test=/usr/share/doc/...
1
vote
1answer
4k views

MySQL wait_timeout setting ignored

I have a MySQL 5.5 instance running on a RedHat distro. I have edited my.cnf with the following setting: wait_timeout=30 However, client connections are sleeping and never getting killed. The ...
6
votes
2answers
11k views

Setting a SQL Server instance back to multi user mode

I had to restore a database, but some of the users were still connected, and had left for the day. Previously, I had set the database to single user, now I do not see that option. So, I made a change ...
1
vote
2answers
913 views

Very high load avg for MySQL database [closed]

I have a backend server which response to my clients app, it has more than 20k~25k hit per second and this make my server load average very high, I believe that my MySQL config is not appropriate. In ...
0
votes
1answer
277 views

Clarification on MySQL Workbench Options File Configuring

When in the MySQL Workbench tool, configuring the "Options File," I see a drop-down in the lower right corner with the options: client mysql mysqld By default, 'mysqld' is selected and I see my ...
0
votes
1answer
67 views

Moved database (percona mysql) to larger disk, now everything is missing (though the files exist)

I dont know anything about databases or MySQL beyond the absolute basics so lets start with that. I moved the /var/lib/mysql from the / to a mounted volume which I remounted as /var/lib/mysql after ...
2
votes
2answers
357 views

Should we enable innodb_file_per_table for single tenant SaaS app (thousands of databases)

We have a mySQL backed SaaS application where each customer has their own mySQL database. So think of it like a wordpress/magento etc. database for each client. Each database has ~200 table, and we ...
0
votes
0answers
65 views

VM SQL Data and Log drives have one Block Size, SAN another. Issues?

Setting up a new SQL VM. What happens if VM data and log drives have 64K (recommended) block size but SAN (IBM DS3500 Express) was configured with a different block size? I want to avoid IO issues ...