The configuration tag has no wiki summary.
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 ...
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 ...
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 ...
1
vote
3answers
3k views
I've got 16GB of ram, how should I configure MySQL Server?
I've got a dedicated production server with multiple cpus and 16GB of ram.
I would like to know how can I configure it better to take advantage of the server resources for better performance because ...
1
vote
1answer
1k views
How to set a specific directory location for individual MySQL database?
Is it possible to set each database in MySQL to use a separate datadir?
I'm running a userdir development (sandbox) server and would like to put the MySQL data files for the database(s) for that user ...
1
vote
2answers
142 views
Postgresql Cost-Based Vacuum Delay parameters
How to set the these parameters on postgresql.conf ?
What I should consider while setting them?
What should I monitor?
#vacuum_cost_delay = 0ms
#vacuum_cost_page_hit = 1 ...
1
vote
1answer
114 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 ...
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 ...
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 ...
1
vote
1answer
516 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
207 views
Installing Sphinx on Mac OS with XAMPP
We have:
Sphinx 2.0.3
Mac OS 10.6.8
XAMPP 1.7.3 (with MySQL 5.1.44)
Here is PATH:
user:sphinx-2.0.3-release user$ echo $PATH
...
1
vote
1answer
252 views
Oracle change initialization parameter with “deferred” keyword
The description of deferred and scope keyword is listed below (extracted from Oracle documentation). The meaning of them gives me an indication that deferred can just use the memory scope. Is my ...
1
vote
2answers
2k views
Can't connect to/from SQL Server 2008 from my Windows 2008 server
I have a server with:
Windows 2008 Server
SQL Server 2008 enterprise
From my server using SQL Server Management Studio, I can't logon to any SQL Server and vice verse, I can't connect to my SQL ...
1
vote
0answers
35 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
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 ...
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 ...
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 | ...
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 ...
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
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 ...
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 ...
0
votes
1answer
710 views
Centos 6.2 mysql configuration file help
I have a new centos 6.2 setup. Below is the configuration file. The machine is going to be fully innodb and it had 8Gb ram. What else must I include in the .cnf?
[mysqld]
datadir=/var/lib/mysql
...
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:
...
0
votes
1answer
403 views
Cannot Login after configure oracle-xe [closed]
I already success install oracle-xe on my ubuntu 10-04, tried to configure the port and password sudo /etc/init.d/oracle-xe configure, and then restart my computer and go to http://127.0.0.1:8080/apex ...
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 ...
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
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 ...
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', ...
-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 =
...
