The settings tag has no wiki summary.
9
votes
3answers
7k views
MySQL table_cache and Opened_tables
I have seen people use the comparison of Open_tables and Opened_tables to assess whether the table_cache is too small in MySQL. However, I believe that Opened_tables is cumulative across uptime, so ...
6
votes
1answer
255 views
Application Settings in Database
In the past I have stored all generic settings and configuration items such as: custom application title, home address, version, debug, etc.. all in a "settings.php" file that I would include into all ...
5
votes
2answers
692 views
How to change SQL sever configuration manager settings using TSQL?
SQL server configuration manager is used to configure certain settings like connection protocols, service start up, etc...
Is it possible to make these changes that is done in SQL server ...
5
votes
2answers
132 views
ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT
Most of the forum and example online always suggest to have both ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT set to ON whenever someone is asking snapshot, row versioning or similar question. ...
3
votes
2answers
631 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 ...
3
votes
2answers
435 views
How to open queries into a selected database in SQL Server Management Studio 2005
My situation:
Using Microsoft SQL Server Management Studio 2005, I connect to a server -- I’ll call it Prod -- using Windows Authentication.
Within this Prod server there are multiple databases: ...
3
votes
2answers
1k views
Consequences of changing NLS_TIMESTAMP_FORMAT
I administer a 9.2.0.8 database where the NLS_TIMESTAMP_FORMAT is set to 'DD-MON-RR HH.MI.SSXFF AM';.
This leads to odd results when using the CAST TO TIMESTAMP function:
select CAST('14-SEP-2011' ...
3
votes
1answer
56 views
Storing application settings with different datatypes
I'm developing a web application and I plan to store application settings in the database in name,value fields (one row = one setting).
These settings range from directory paths to simple yes/no ...
3
votes
1answer
77 views
Is it possible to find the values of MySQL variables if I do not have SELECT privileges on mysql.user?
I am getting a 'msyql server has gone away' error sometimes when doing a large binary insert, so I wanted to check the settings on mysql, things like wait_timeout and max_allowed_packet. However
show ...
3
votes
2answers
48 views
disallow SET command in a postgresql server
Im planning to publish my postgresql server to a few untrusted clients.
I dont want them to modify any runtime setting, like work_mem or something risky to my server. In general I assume the ...
2
votes
2answers
564 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 ...
2
votes
2answers
865 views
SET LOCK_TIMEOUT, is it session or statement based?
For what period does the LOCK_TIMEOUT LAST?
I do a "SET LOCK_TIMEOUT 10" and a "SELECT @@LOCK_TIMEOUT" in one command after a login and get 10 returned. Immediately after this I do a "SELECT ...
2
votes
1answer
54 views
How do I turn off ALTER DATABASE script output in VS 2012?
I am using SQL Server 2005 in conjunction with Visual Studio 2012 and a SSDT database project.
When I publish my VS project and generate the script to run against my database, VS includes the ...
1
vote
1answer
25 views
How to get user-specific settings in PostgreSQL?
I have to collect some information of PostgreSQL roles. One piece of information is whether the role has different settings than 'usual', usual meaning here default values for only a few parameters ...
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 ...
