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

learn more… | top users | synonyms

0
votes
1answer
229 views

exception: hosts cannot switch between localhost and hostname

I created a replication set. I added localhost in the set in the beginning, but when I try to edit the member with the actual hostname. I get error "exception: hosts cannot switch between localhost ...
0
votes
1answer
382 views

Oracle Enterprise Manager Installation

First I install oracle 11g database with this configuration Step 2 of 9 I selected Create and configure a database Step 3 of 9 I selected Desktop Class Step 4 of 8 Global database name: Blitz ...
0
votes
0answers
3 views

pgpool authentication failed when use syslog in log_destination

When I configure in pgpool.conf file: log_destination = 'stderr' pgpool run ok, but when I use this configuration: log_destination = 'syslog' I get this error: pgpool pgpool[21477]: pcp_child: ...
0
votes
1answer
163 views

SQL Server starts normally from Windows Services screen, but shows error through SQL Server Configuration Manager. Why?

I have a SQL Server 2005 instance that has worked fine for years. There have been no changes that I am aware of. Recently, I found that if I stop and then start the instance in SQL Server ...
0
votes
2answers
60 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
2answers
3k views

How to force higher values of open_files_limit or table_open_cache?

I'm having a frustrating problem where setting my.cnf to values higher than I currently have them does not 'take'. This is MySQL 5.6.14 on MacOS X 10.8.3 I'm trying to address dropped connections ...
15
votes
6answers
7k views

What is a good, repeatable way to calculate MAXDOP on SQL Server?

When setting up a new SQL Server 2012, I use the following code to determine a good starting point for the MAXDOP setting: /* This will recommend a MAXDOP setting appropriate for your machine's ...
0
votes
2answers
275 views

Error changing mysql 5.6 default port

I've changed my.ini with port=3308 but after restart the service mysql 5.6 is working in the same default port 3306. I've tried in mysql 5.5 and it worked fine. C:\Archivos de programa\MySQL\MySQL ...
2
votes
1answer
3k views

PostgreSQL isn't listen on 5432 in Windows 7

I have a PostgreSQL 9.3.1 DB Server running in Windows 7 Ultimate. I have checked the file postgresql.conf and this lines are uncommented: listen_addresses="*" port=5432 And this is the ...
0
votes
0answers
23 views

MySQL Enterprise Monitor - Query Analyzer configuration problem

I'm using MySQL 5.1.69. protocol_version 10 version 5.1.69-log version_compile_os redhat-linux-gnu I have a problem with configuration/using MySQL ENTERPRISE MONITOR. I don't see data in ...
0
votes
1answer
23 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
0answers
30 views

Using Configuration Management for DBA tasks?

We have a couple of Postgres 9.3 database servers in our system, all of them with their respective config files, databases, roles, role groups, permissions on schema/tables, extensions etc. We use ...
0
votes
1answer
28 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 ...
1
vote
2answers
2k views

Create database fails with Microsoft SQL Server Error 5133, Operating syste, error 5 (Access is denied)

I just installed SQL server 2012 on Windows 2012 today. After the install, I changed the database settings to create database files in f:\mssql instead of the default. i verified the confired and ...
0
votes
0answers
11 views

Optimal config for a small vserver with ispconfig

I have a vserver with debian wheezy, 1GHz CPU single core, 512MB RAM and only 8GB HDD. Owncloud is running, but has its own database-engine How should I configure Mysql so it doesn't slow down the ...
2
votes
2answers
81 views

Tuning Postgres for Single connection use? Or is postgres wrong tool?

Any rules of thumb for work_mem, maintenance_work_mem, shared_buffer, etc. for a database that DOESN'T anticipate concurrent connections and that is doing lots of aggregate functions? I'm a social ...
7
votes
1answer
124 views

Lower performance on newest servers

We have several db servers on production, 4 of them with very similar hardware configuration. Dell PowerEdge R620, only difference is that 2 newest ones (bought and configured 3 months ago) have RAID ...
0
votes
0answers
35 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 ...
0
votes
0answers
43 views

SQL Server Data access does not connect unless we provide the port number

I have configured SQL Server 2008 R2 named instance on Windows Server 2008 R2 to listen to only one IP,1433. Some Office 2010 clients are trying to connect using the external data to SQL Server using ...
0
votes
1answer
50 views

MySQL configuration to connect to multiple local applications [closed]

I've installed FreeRADIUS, MySQL and FreeRADIUS management (a web-based app) on the same machine, with both FreeRADIUS and FreeRADIUS management using same user to connect MySQL. My problem is when I ...
2
votes
2answers
347 views

Cannot configure nor start MySQL

On a brand new Kubuntu 14.04 install, I ran sudo aptitude install mysql-server-core-5.6. The install could not complete due to dependencies of some KDE packages on mysql-server-core-5.5, which would ...
1
vote
2answers
30 views

Is there a policy or special server configuration to limit SQL Server query results?

I have been seeing developers using SELECT * FROM table when testing their queries. The issue is that many developers are executing such SELECT statements on huge tables, which slows down SQL Server ...
0
votes
0answers
21 views

SQL Server Configuration.ini File. SSIS Data Required?

I am planning a new SQL Server installation based of the settings from a previous installation on another server. I am using the Configuration.ini file. Since SSIS is not required can I exclude the ...
0
votes
0answers
74 views

Finding the right MariaDB configuration

I’ve read several articles about how to configure MySQL/MariaDB, but now I’m kind of confused how to find the right values. Some articles suggest not choosing to high values, others recommend adapting ...
4
votes
1answer
2k views

Make SqlClient default to ARITHABORT ON

First things first: I'm using MS SQL Server 2008 with a database at compatibility level 80, and connecting to it with .Net's System.Data.SqlClient.SqlConnection. For performance reasons I've created ...
0
votes
1answer
21 views

Query for which my.ini in use

Is it possible to query mysql server to know which configuration file is in use? Sometimes, my.cnf, my.ini. SHOW VARIABLES; -- does not have enough information here for my.ini path
0
votes
2answers
4k views

Can't backup a Postgres database: FATAL: Peer authentication failed for user “postgres”

I can connect to my database no problem remotely, either from PHP scripts on our webserver or using PGAdmin3. Unfortunately, when I try to run pg_dump backups locally on the server itself, I get: ...
2
votes
1answer
2k views

MariaDB and XtraDB/InnoDB plugins

In my vps, I thought of switching from MySQL to MariaDB (using Monty's repository for Debian Squeeze). Copying over my.cnf from MySQL to MariaDB, I saw that the new config file (the one from the ...
1
vote
1answer
63 views

Explain PostgreSql ssl_cipher values: ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH

In the postgresql.conf file, one can configure authorized values for ssl_cipher. Yet I could not find documentation explaining what the ALL, ADH, LOW, EXP, MD5 and STRENGTH values correspond to. MD5 ...
1
vote
1answer
45 views

MySQL Cluster MaxNoOfConcurrentOperations and RAM

Why increasing of MaxNoOfConcurrentOperations lead to higher consumption of RAM? I need high value for fast filling tables with some random data, but i noticed that my datanodes are swapping at ...
1
vote
1answer
198 views

Postgresql: set default psql client encoding

When I connect to a Postgresql DB using psql, I often get these messages: => SELECT * FROM question_view ; ERROR: character with byte sequence 0xd7 0x9e in encoding "UTF8" has no equivalent in ...
0
votes
1answer
191 views

Setup mySQL in a chroot in Debian Wheezy

Sounds like a simple question, but the documentation is rare about what mySQL needs to run inside a chroot. I think I'm almost there, but I'm running into a permission problem that I can't solve, and ...
0
votes
1answer
160 views

MySQL: How to clean MySQL from RHEL5?

I have installed MySQL 5.1.73 community edition through RPM. It was working fine. I uninstalled this version by using yum remove mysql-server command. I wanted to upgrade MySQL from 5.1.73 to 5.6.19 ...
0
votes
1answer
259 views

Good configuration for 2gb (my.cnf) [duplicate]

I'm little newbie in configuring mysql and i seek a good configuration for mysql i have one site in ajax with many query and very slowly with VPS Iam in kimsufi 2gb i run only mysql in vps not apache ...
0
votes
2answers
171 views

When should I NOT set the Maximum Server Memory option in SQL Server?

In SQL Server, I normally set the Maximum Server Memory setting to one of the popular best practices, such as leaving 10% or 4GB, whichever is higher. ...
0
votes
0answers
69 views

Unable to install mysql 5.6.17and configure mysql on Win 7 -64 bit Os

Already seen this post but not my type of question as iam stuck in the installation itself I am trying to install MySQL 5.6.17 on Windows 7 64-bit Operating System. Everytime I try I am stuck in ...
1
vote
1answer
223 views

How to set bytea_output to hex?

I cannot seem to change bytea_output to hex. I have tried this method: ALTER DATABASE dbname SET bytea_output TO 'hex'; I have tried to edit postgresql.conf bytea_output = 'hex' and restarted ...
0
votes
2answers
1k views

My.cnf with 64GB RAM

May the following my.cnf file be fine for a dedicated server with 64GB of RAM (on Debian)? I'm running just one website on the server and on high load data insert in some table takes centuries...it ...
4
votes
3answers
3k views

save/export PGAdmin server list configuration settings

I have a ton of configured connections listed in the Server Groups, is there a way I can save this? not just save the passwords but the Server Group Settings
0
votes
0answers
53 views

Unable to load innodb log file settings from my.cnf

I'm coming up against the error: InnoDB: ERROR: the age of the last checkpoint is 9449527, which exceeds the log group capacity 9433498. If you are using big BLOB or TEXT rows, you must set ...
0
votes
1answer
74 views

MongoDB - temporarily turn shard to standalone for local user creation

Following question Mongodb sharded cluster backup user issue I have a sharded mongodb cluster, with 4 shards, and I'm required to stop the mongod service on each shard, and start it not as a part of ...
2
votes
1answer
166 views

MySQL cluster DataMemory and DiskPageBufferMemory parameters

I want to setup a MySQL cluster. The amount of data is more than double the amount of RAM. I have 3 Data Nodes each with 8GB RAM. QUESTIONS What is a good rule for the DataMemory and ...
0
votes
2answers
110 views

PostgreSQL 9.3 - standard_confirming_strings option in postgresql.conf not affecting remote machine

I am updating a program at work that communicates with a postgreSQL 9.3 database. I need to turn off an option in the postgresql.conf file called standard_conforming_strings, so that I can store ...
5
votes
1answer
59 views

Is there a configuration setting for how many pages ANALYZE will scan?

Is there a setting that controls how many records/pages are scanned by the PostgreSQL ANALYZE command? It looks like by default it scans 30,000 pages and 30,000 records. The PostgreSQL Server ...
0
votes
1answer
176 views

Can you see other users' session variables in MySQL?

In MySQL, Using SHOW GLOBAL VARIABLES gives the ability to see global variables. SHOW SESSION VARIABLES are the variable settings for that session. Is there a way to see the SESSION variables of ...
1
vote
2answers
72 views

Changing the SQL Server service account - any additional considerations?

I have inherited a few instances that are running under LocalSystem. I need to change this to a domain account as we are changing our backup strategy to go to a network share and then to tape and I ...
0
votes
0answers
15 views

Windows mysql optimal configuration architecture (moca)?

is there a 'mysql optimal configuration architecture (moca)' layout for Windows? I need to set up a brand new dedicated MySQL server for MySQL and would like to follow as closely as possible this ...
0
votes
1answer
132 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
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 ...
-1
votes
1answer
459 views

the environment variables configuration for ORACLE EXPRESS 11g / windows7 32Bit

I can't connect in Oracle Express 11g (windows7 32-bit) and I think the problem comes from the environment variable ORACLE_SID & ORACLE_HOME , how can I get the database instance to do the right ...