The configuration tag has no wiki summary.
1
vote
0answers
30 views
Troubleshooting a SQL Server instance that won't start
I've had a problem with one instance of SQL Server 2008 (the free version) not starting automatically. I always have to right click on the icon in the task bar and start it manually. It is set to ...
-1
votes
0answers
28 views
Oracle Connection Manager cman.ora startup
I can't startup the cman.ora file
Here is the file cman.ora contents
CMAN_Saf1-PC =
(CONFIGURATION=
(ADDRESS=
(PROTOCOL=tcp)(HOST=192.168.0.206)(PORT=1821)
)
(parameter_list =
...
0
votes
2answers
68 views
Multiple database servers for performance vs failover
If I have two database servers, and I am looking for maximum performance vs high-availability, what configuration would be best?
Assuming the architecture is two load-balanced web/app servers in ...
0
votes
0answers
65 views
Oracle Connection Manager Configuration [closed]
I've a problem with Oracle Connection Manager and I've read the Oracle topic about it at
OCM
but it doesn't work well
An image Inside Diagram describes the diagram I want to configure
The IP for ...
2
votes
2answers
131 views
MySQL replication: most important config parameters for performance on slave server?
I'm setting up a mysql master-slave configuration, where slave is located on a much weaker sever.
Since, if I understand correctly, slave only works on updates/inserts, what are the most critical ...
2
votes
1answer
60 views
MySQL specific database configuration file
In MySQL's configuration file I've globally disabled autocommit as so.
[mysqld]
autocommit=0
I need to turn MySQL's autocommit on for a specific Ruby on Rails database though. It could be for the ...
0
votes
2answers
58 views
Oracle database uses wrong parameter file
When I try to startup my Oracle database I get the following error:
LRM-00109: could not open parameter file '/opt/app/oracle/product/11.2.0/db_1/dbs/initjicdbaex.ora'
The /dbs directory in my ...
0
votes
0answers
27 views
Recommended hardware for dedicate sever using MySQL for POS (point of sale) [closed]
I'm having some doubts about this point in my project (it's social service).
The POS have developed on VB.NET using Visual Studio 2010.
The MAXIMUM number of POS that is thinking to attend this server ...
1
vote
1answer
230 views
Where is the MySQL variable - innodb_flush_method?
I would like to tweak the value of innodb_flush_method to find out its performance impact on a database server. That variable is listed when I run the command SHOW VARIABLES.
But I could not find it ...
2
votes
3answers
166 views
Moving SQL Server to different domain
What are best practices/important steps when the Windows Server machine hosting SQL Server 2008 R2 is moved to another domain? What steps definitely/might need to be done for SQL Server before and ...
0
votes
1answer
36 views
New Database vs New Table for User Registrations
Here's an example, there is this application that completes a task (mostly data-enrty stuff). Users can sign-up on a website to begin using the application straight away.
At the moment, I was looking ...
6
votes
3answers
422 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 ...
2
votes
1answer
49 views
What fillfactor for caching table?
I have heavily updated / accessed table where I store serialized java objects. They are in the table for 2-3 hours (also are being updated during that period) and then removed. Size of table is around ...
3
votes
2answers
630 views
How to compare two SQL Server 2008 configurations
I have a problem with my application that works on my dev SQL Server 2008 (Developer Edition), but not on a production SQL Server 2008. Is there an easy way to export the settings from the production ...
0
votes
2answers
51 views
Can I configure MySQL's typecasting to consider 0 != 'foo'?
This article points out the following security problem with MySQL:
USERS
id | email | password_reset_token
1 | one@example.com | QTlXww)uV!Hdg3U6aGwKV2FPvAqzVgPx
2 | two@example.com | ...
1
vote
1answer
113 views
SQL Server Database Mail - Why can't I run an execute against xp_sysmail_activate?
SQL Server 2008 R2 Standard x64
I can't send e-mail from this SQL Server (out of MANY that are configured pretty much identically AFAIK). I have created the mail profile and account. However, any ...
2
votes
3answers
7k views
How to initiate MySQL on Mac OS X 10.6.8?
I followed this tutorial to install MySQL on Mac OS X 10.6.8. Now I get he following errors:
$ mysqladmin version
/usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed
error: ...
3
votes
1answer
127 views
SQL Server Report Manager 404 using HTTPS
OK. I have scoured the Internet for information on trying to fix this and found nothing that deals with my situation.
I started here, that lead me to here, that lead me to looking at netsh commands ...
1
vote
1answer
57 views
DB2 DBM paramter NUMDB has value 8. Should I change it to 1 because I have only one database?
Hello I am using IBM Maximo application which is using DB2 database and I have created only one database. I heard that when paramtere NUMDB has value 8 it will divide all values in DB CONFIGURATION ...
3
votes
1answer
80 views
Can't understand results of pg_stat_statements view
I configured my postgresql.conf (my version is 9.1) with the normal persistent configuration:
shared_preload_libraries = 'pg_stat_statements,plperl'
custom_variable_classes = ...
2
votes
1answer
492 views
innodb_flush settings on Amazon RDS
Setting innodb_flush_log_at_trx_commit = 2 improves my application performance considerably on my local development environment. The response time and number of requests per second on a 40 concurrent ...
1
vote
0answers
33 views
Is there a canonical list of MySQL defaults which should be changed
I'm setting up a new mysql server as we're building a new app at work.
Most of the developers/operations guys are familiar with mysql.
Many of mysql's settings (eg strict mode) are set badly by ...
2
votes
1answer
120 views
Optimal PostgreSQL setup for Windows 2008 R2
I have PostgreSQL 9.2 setup on Windows 2008 R2 64bit with 96 gigs of RAM and 8 cores. What would the optimal settings be for shared_buffers, effective_cache_size, work_mem, etc.? I realize that these ...
1
vote
1answer
61 views
Something wrong in pg_hba.conf
this my configuration:
#postgres.conf:
listen_addresses = 'localhost'
#pg_hba.conf:
local all postgres md5
local all appuser trust
local all devuser trust
local all all peer
i'm connecting in ...
3
votes
1answer
85 views
Make sure MySQL is not accepting remote connections
I am currently doing development for a LAMP-based website. I do not know what configuration changes have been made to MySQL since it was installed on our server. The way that we use MySQL, there is no ...
1
vote
1answer
515 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 ...
2
votes
1answer
213 views
SQL Server 2012 Availability Group configuration & licencing
I am about to setup a 3 node AV group for SQL Server 2012 my configuration will be -
London-Srv1 - PRIMARY
Core Database (OLTP)
set to READ_WRITE
London-Srv2 - SECONDARY PASSIVE synchronous
Core ...
3
votes
1answer
345 views
Proper tuning for 30GB InnoDB table on server with 48GB RAM
I have a 30GB 15M rows InnoDB MySQL 5.5.15 table. It is running on a server with many other MyISAM tables (300GB db). The system has 48GB RAM. Besides the default configurations, I've changed the ...
4
votes
1answer
141 views
PostgreSQL: Recommendation size for shared_buffers
I am rather new to PostgreSQL. I started migrating some MySQL databases to PostgreSQL one month ago.
I am looking for help about the proper memory values for the configuration file.
Currently, I ...
3
votes
1answer
369 views
How to set datadir to different values based on the hostname in my.cnf?
How to set datadir to different values based on the hostname in my.cnf? I want to use the same my.cnf file on a Linux machine and a Mac OS X machine where the datadir should have different values.
0
votes
1answer
115 views
Why doesn't more memory necessarily make Postgres more performant?
The Postgres resource consumption docs state, under the shared_buffers:
...it is unlikely that an allocation of more than 40% of RAM to shared_buffers will work better than a smaller amount.
Why ...
6
votes
2answers
202 views
Risks of changing to ARITHABORT ON
I'm working with a vendor with the arrangement that they provide the core application, and I can build my own extensions as long as I don't modify the core application. It's built in ColdFusion ...
2
votes
2answers
561 views
Dynamic change to innodb_flush_log_at_trx_commit
This is related to this question. It does help to get better performance for InnoDB tables.
According to MySQL manual, innodb_flush_log_at_trx_commit is a global dynamic variable. Thus, I can change ...
3
votes
1answer
115 views
What's the most unsafe MySQL configuration?
I have MySQL 5.5.27-29.0-log instance running specifically for Jenkins. Since tests data is always recreated during setup, ACID is unnecessary and I'm hoping to sacrifice it to gain more performance.
...
0
votes
0answers
81 views
Please help configure my Mysql for 12GB 4cores server
I use a dedicated server with 12GB memory and 4 core CPU with Ubuntu 12.04 LTS (x64). This not just a database server. MySQL appears to be restarting frequently, I think I can tune the config to ...
2
votes
1answer
282 views
Oracle: Long delay opening connections
I am getting a very long delay (about 2 minutes) opening initial connections on my 11g2 development server. Sometimes I get ORA-28547: connection to server failed, probable Oracle Net admin error and ...
1
vote
1answer
258 views
Can't start postgres server, SHMMAX too small
When I try to start the postgres server with sudo /etc/init.d/postgresql start I get this error:
Starting PostgreSQL 8.4 database server: mainThe PostgreSQL server
failed to start. Please check ...
0
votes
2answers
1k views
sqlnet.ora or tnsnames.ora changes require reboot?
Anytime you change Oracle's sqlnet.ora or tnsnames.ora files, does the system require a reboot? In my instance, I only have the Oracle client installed on the machine I'm referring to, but out of ...
2
votes
2answers
1k views
The best MySQL configuration for my server
I'm little newbie in configuring mysql and I need some advices.
Few days ago I made little home server on Ubuntu Server 12.04 with samba, mysql 5.5, apache 2.2, PHP 5.4.6 etc.
I'm using it to ...
2
votes
2answers
96 views
MySQL Server Config, Small Timeframe, Extreme Usage-Scenario
I want to configure a MySQL server for the following scenario.
A large amount of users will need to sign up for a university course selecting individual "timeslots". The signup page will open at a ...
0
votes
1answer
147 views
Length of LOB data (%1) to be replicated exceeds configured maximum %2
We recently hit this error shortly after enabling replication on a table.
Length of LOB data (%1) to be replicated exceeds configured maximum %2
I've found solutions to this problem already:
...
1
vote
0answers
263 views
How to customize Place Order Functionality In Magento? [closed]
In Magento, when any customer buys product from front-end, then at last customer goes through order placing.
According to my need, I have created one CUSTOM TABLE in Magento database. So my ...
2
votes
1answer
253 views
Remove an IP address from server config
What is the safe way to remove an old IP address from SQL Server configuration?
The scenario is, I have a server with 2 NIC's that should have been configured for teaming but weren't at the time SQL ...
2
votes
1answer
321 views
Postgres: Server does not listen even listen_addresses is set to '*' in postgresql.conf
I've set listen_addresses to '*' in postgresql.conf and stopped/started Postgres to "reload" configs.
Even then, psql SHOW listen_addresses; is showing localhost.
I'm sure I've edited and saved the ...
0
votes
0answers
368 views
Plesk 11 MySQL connection problem when specifying database
I am having some connection problems with MySQL users when trying to connect directly to a database. This came up when trying to use mysqli_connect in PHP.
$dbc=mysqli_connect('127.0.0.1', ...
3
votes
1answer
874 views
What should I set max_connections to for MySQL?
I have MySQL 5.1.35 on Linux Centos. The Linux server has 2GB RAM with 14GB of disk space.
I have created some web services using the Restlet framework in Java that has 1,000+ users.
What should I ...
2
votes
1answer
187 views
MySQL table locks solution -> InnoDb / Partitions
I'm experiencing many table locks in a MyISAM MySQL table that is pretty big (Constx10xGB and 15M rows).
It's mainly caused due many heavy inserts. My current thoughts to optimize:
Changing to ...
2
votes
2answers
161 views
Why restoring a large sql file via SSH seems to quit partially through the process
I have a large (~5GB) .sql file I am attempting to restore via SSH, it seems to quit in the middle of the restore process.
When I come back hours later after issuing the command (the file has 7 ...
1
vote
1answer
3k views
Oracle DBCA utility: “Listener is not up or database service is not registered with it”
I'm a software engineer with some experience on SQL Server but a newbie on Oracle.
I'm attempting to run dbca on a remote linux machine to reconfigure a database that was initially configured to idle ...
13
votes
5answers
2k views
Why are periodic restarts required to keep my instance performing well?
We've got a production DB server on SQL 2005. Everything runs normally for a while, but after a couple weeks we see a notable performance drop. Only restarting SQL Server brings performance back to ...
