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

learn more… | top users | synonyms (1)

2
votes
1answer
3k views

MySQL InnoDB page_cleaner settings might not be optimal

Seeing this note in mysqld.log: [Note] InnoDB: page_cleaner: 1000ms intended loop took 15888ms. The settings might not be optimal. (flushed=200 and evicted=0, during the time.) There seems to be ...
2
votes
1answer
49 views

Putting SQL Server databases into individual folders

We have a Dev server where we are trying out some automated partitioning scripts. The folder is getting quite large in terms of number of files. Is it possible to automatically have SQL Server use ...
1
vote
1answer
275 views

PostgreSQL on Windows fails to start - 'could not create shared memory segment'

PostgreSQL 9.4 & 9.5 (beta) on my Windows 7 laptop fails to start. In the Windows event log I see the following error: 2015-11-10 13:53:49 IST FATAL: could not create shared memory segment "...
1
vote
0answers
227 views

PostgreSQL FATAL canceling authentication due to timeout

I have a PostgreSQL 9.4 Database running on my CentOS 7 Server. This database has only ever been available to users on the LAN, however recently I needed to make it available to users outside the LAN ...
1
vote
1answer
499 views

psql “invalid client_encoding” error on OS X, PostgreSQL 9.4.5

I'm currently running a OS X Lion Server system which ships with a built-in and not-upgradable PostgreSQL version. After years of usage I've finnaly decided to leave the built-in version and install ...
0
votes
0answers
81 views

Memory usage still growing

I have problem with my production mysql server. The memory usage is still growing and I don't know why. Trouble started when we changed the server. My mysql version: 5.5.44-0+deb8u1-log - (Debian). [...
1
vote
0answers
75 views

Proper database configuration

I'm running MySQL 5.5 on Debian 7.8. My entire DB is 2200 MB large (all tables are InnoDB), the mysql process is taking up to 6G RAM but still I think that not evrything is loaded in RAM I have large ...
1
vote
1answer
250 views

Azure TempDB and Log files

I'm setting up an Azure D11 SQL Server to be used for a data warehouse. I can only attach 4 data disks and have done so, now I need to determine how to configure them and split the DB files. I'm ...
-2
votes
1answer
328 views

SQL Server 2014 is not showing

I have installed SQL Server 2014 in my machine (OS Windows 10). I already have SQL Server 2008 R2. Now I have 2 server instances and I also have 2 Management Studios. My problem is that I can not ...
3
votes
2answers
98 views

Why is server configuration 'min server memory' configured at 0, but running at 16 (sometimes 8)?

We started to monitor sql server instance non-active server configurations and find something interesting. Why is server configuration 'min server memory' configured at 0, but running at 16 (sometimes ...
0
votes
1answer
249 views

can't install citext extension: could not access file “$libdir/citext”: No such file or directory

I'm trying to get citext available as a type in a specific database. The Postgres database server is 9.4. I see it on the server in the pg_catalog's pg_available_extensions view. From the psql ...
2
votes
1answer
589 views

SQL Server service automatically stops after starting

I have a problem with my SQL Server 2014 Express instance. It worked fine until now. I can't get it working because SQL Server service automatically stops immediately after I start it. I'm trying to ...
5
votes
2answers
184 views

Always On Availability Group, Always redirect user to read only instance

We have an Always On availability group with a primary and a read-enabled secondary. We have a user for the implementation team who uses the database to check the correctness of the data that they are ...
0
votes
0answers
105 views

Mysql server does not start if binary logging is disabled

I have been trying to disable binary logging on a slave server, since I do not use it as a master for another one, I have no use for the logs and I am trying to reduce lag so cut out everything that ...
3
votes
1answer
545 views

Checkpoints are occurring too frequently during pg_restore

Under PostgreSQL 9.2.2 (Windows 32 bits), I have a pg_restore command that systematically results in log warnings about the checkpoint frequency, for example: LOG: checkpoints are occurring too ...
2
votes
3answers
138 views

Is there a setting in MySQL that will allow you to see the columns of a table on a query, even if the table is empty?

When I am writing code to go with a certain MySQL query, I like to do a basic select statement to see the columns, and to perhaps see what data is available as a sample. Sometimes, the table I would ...
0
votes
0answers
23 views

How to stop MySQL Workbench screens from staying on top

I have MySQL Workbench. I am doing multiple things at the same time - when one app is processing or doing something, I am working with another application. Workbench however when it's doing ...
10
votes
2answers
1k views

SQL Server max memory, page file, max degree parallelism

Three questions hope you DBA masters of the universe can answer: I know it is best practice to set SQL Server's max memory. So if a server with 44 GB RAM has SQL Server installed we should set the ...
4
votes
1answer
100 views

Why is a max degree of parallelism 1 recommended and used for Sharepoint in SQL Server?

I am new to Sharepoint, but I used to work with SQL Server a lot. I realized that Sharepoint changes some of the SQL Server settings to non default values. One is the max degree of parallelism, why ...
1
vote
2answers
137 views

Postgres takes a lot of RAM (cached)

I have a small database PostgreSQL (v9.3) on Centos 6 x64 ( RAM: 8 GB ). postgresql.conf max_connections = 512 shared_buffers = 3000MB temp_buffers = 8MB work_mem = 2MB ...
0
votes
0answers
109 views

Can't read config files from pgAdminIII on local Kubuntu machine

My database starts fine, I can connect to it from pgAdmin and run queries. However when I go to Tools->Server Configuration->postgresql.conf I get an error. The error states could not stat file "...
0
votes
2answers
160 views

Setting max server memory in SQL Server 2014 [closed]

I have a SQL Server 2014 Standard Edition server running Windows 2012 R2, with 128GB memory. I'm attempting to configure SQL Server to use max memory of 96GB, but it appears to not be working. It is ...
1
vote
0answers
74 views

changing mysql configuration . Getting errors like Table is marked as crashed and should be repaired

On Our server I have done following configuration for Database: [server has 2 core, 2 GB ram and windows 2008 operating system] query_cache_size= 32M [Old] query_cache_size= 50M ...
1
vote
0answers
30 views

SSAS - what could I monitor in SSAS to fine tune its memory settings?

This question is a follow up from the SSAS - what could be a good starting point for memory settings? What and how can I monitor the server resources in order to best identify the settings that I ...
5
votes
1answer
131 views

SSAS - what could be a good starting point for memory settings?

I have received the following alert regarding memory settings of SSAS: Alert: SSAS 2014: Invalid TotalMemoryLimit Configuration Source: MSSQLSERVER Path: SASBI01Alert time: 9/15/2015 5:38:50 PM ...
6
votes
1answer
196 views

Performance problem after migration from SQL Server 2005 to 2012 [closed]

Last Friday, I migrated a SQL Server instance from 2005 Enterprise Edition to a brand new Windows Server 2012 server with SQL Server 2012 Enterprise Edition installed. Since then, users have started ...
1
vote
1answer
46 views

optimise my.ini for key query

I have a database system with a fairly complex dashboard query. First of all the details. Data model: DROP TABLE IF EXISTS `contract`; CREATE TABLE IF NOT EXISTS `contract` ( `id` int(11) NOT ...
5
votes
2answers
2k views

Listing SQL Server instance startup parameters

I have a server I have just restarted and verified which trace flag are active using DBCC TRACESTATUS: Trace Flag : 3688 Function: Removes messages to errorlog about traces started and stopped ...
1
vote
0answers
42 views

SQL Server on big machine falls over inexplicably

We've been doing some throughput testing with our web application. The production application resides on a couple of machines in the amazon cloud, consisting of a web server and a database server. ...
2
votes
1answer
547 views

RAID 10 array configuration for SQL Server

I have a question regarding RAID 10 and SQL Server. My plan is to purchase an HP DL380 G9 with the 24 drive config. The question is how to break up the array. The drives will be divided between the 3 ...
0
votes
0answers
42 views

What are the built-in default configuration values of redis.conf?

If I omit a configuration option in redis.conf, what value will be used upon running redis? The self-documented redis.conf states that just rarely. I have found (but didn't try yet) this command: ...
6
votes
3answers
376 views

Slow query performance due to temporary file?

Here is the query: SELECT "products".* FROM "products" WHERE (status > 100) AND "products"."above_revenue_average" = 't' AND ("products"."category_id" NOT IN (5)) ORDER BY "products"."...
1
vote
0answers
47 views

Design of hard drive RAIDs

My task is to reconfigure a main server that houses the company's applications and data. The server is capable of handling everything. I wanted to find out if anyone has a suggestion on the best ...
4
votes
1answer
658 views

Oracle Database 12c: Unable to resize system tablespace

Problem: My java application is returning ORA-01691: unable to extend lob segment errors for every insert Cause: After running: SELECT * FROM dba_tablespace_usage_metrics ORDER BY used_percent ...
5
votes
3answers
278 views

Virtualize SQL High CPU

This is a client environment which needs significant overhaul so all I am trying to do is slow the bleeding. Situation CPU is getting crushed, often 80% or higher utilization VMWARE 5.5, Windows ...
0
votes
1answer
148 views

Oracle 11g PGA advice view is empty when it shouldn't

I have the following situation in an Oracle 11g server (it's part of a RAC). PGA_AGGREGATE_TARGET is set, STATISTICS_LEVEL is TYPICAL, and yet V$PGA_TARGET_ADVICE shows up empty. Why does this happen? ...
5
votes
1answer
119 views

To minimize Cache misses in PostgreSQL?

You can calculate cache misses as described here. However, I am interested in how to minimize the phenomenon in PostgreSQL 9.4.3 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, ...
2
votes
2answers
62 views

How do I define the frequency of my mongo backup

I want to know if there is a way to define in Mongo the frequency of backups have to be executed. There is any config file for that? An example will be excellent!! UPDATE I want to create a ...
1
vote
2answers
1k views

How do I create a Mongo config file to allow access to http on port 28017

Well I want to configure the mongo server to allows access for http. I put this on my mongo config file: port = 28017 rest = true And when I restart my mongod service and try to access I got this ...
2
votes
2answers
1k views

Secondary and Arbiter stuck in Startup

I'm using MongoDB version 3.0.0. I'm trying to setup mongodb replication on our machine. Replication was initially setup but due to some changes on the VM the entire thing crashed. When I tried to set ...
1
vote
1answer
41 views

MySQL connectivity error

I have a MySQL database on a Linux server that I am able to access through putty logging into servers terminal. When I try to connect to the MySQL database remotely, I get the error: Lost ...
0
votes
1answer
55 views

Setting shared_buffers over 320 MB prevents Postgres from restarting

I'm running Postgres 8.1 on a CentOS 5 system with 4 GB of RAM. Whenever I set shared_buffers above 320 MB, it won't run. I've checked SHMMAX and it's at 4294967295 which is the max allowed for a 32-...
2
votes
0answers
22 views

Should mongodb be run in a service, or a worker cluster?

I'm trying to implement an architecture that's similar to the coreos's production architecture (shown below) Should I run the database as a central service or one or more of the workers? I figured ...
2
votes
1answer
217 views

Mysql high cpu usage - cpanel

After an update from whm, I see a high CPU usage from MySQL (5.6). my.cfg: [mysqld] slow_query_log=1 slow_query_log_file="/var/lib/mysql/slow-query.log" long_query_time=1 skip_name_resolve ...
1
vote
1answer
46 views

What does Oracle XE perform during installation?

I have oracle11g2 installed on my noteobook. I then installed the Oracle Database 11g XE. Now a .dll which uses the oracle11g2 client does not work anymore. First I recogniced that I had now two ...
2
votes
2answers
1k views

How do I limit Oracle's memory use?

I would like to use Oracle's automatic memory management, with a limit of around 4GB. (Past experience has shown this to be plenty for my dev PC and that it is easier to get an idea about any ...
11
votes
2answers
248 views

Is it ever ok to not test a feature?

Is there any point at which you become so familiar with your language/database/system that there is no need to test a new feature/configuration/query/etc. by contained/simulated testing before ...
6
votes
2answers
770 views

Should I use ReFS for a new SQL Server?

We are in the process of building a new production Windows Server 2012 R2 server to run SQL Server 2014 Enterprise Edition. There is a bit of advice on the internet that suggests for Windows Server ...
0
votes
1answer
1k views

Mysql - unknown variable 'table_cache=64'

I use Mamp Pro 3. I upgraded Mamp's MySql to 5.6.24 using this script https://gist.github.com/tobi-pb/b9426db51f262d88515c. After that I ran the Mamp Pro and MySql cannot be started. So I looked the ...
3
votes
2answers
496 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 ...