The config tag has no wiki summary.
2
votes
0answers
29 views
How can service pack rollback file end up on non-system volume?
I'm attempting to upgrade a SQL 2005 SP3 clustered instance to SP4. During installation, a rollback event took place with the error indicating there was insufficient space on the the disk. The system ...
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
3answers
307 views
Tuning Question
Every so often our box is HAMMERED to a crawl %Wait goes to 40 or 50% and connections grows to 300 or so. i think its due to a query running, but i wanted to see if any of the settigns on the mysql ...
7
votes
6answers
771 views
Reasons for disabling statistics auto update?
I just learned that a client company I work for has decided to keep the auto update statistics options off for some of their SQL Servers, and the DBAs manually troubleshooting performance issues when ...
9
votes
3answers
783 views
Why don't my .my.cnf settings work?
I have a .my.cnf file in my home directory on my desktop that includes:
[dbid]
user = myusername
password = mypassword
database = dbname
host = server.location.com
If I recall correctly, before ...
5
votes
4answers
7k views
Why does MySQL say I'm out of memory?
I was trying to execute a fairly large INSERT...SELECT in MySQL with JDBC, and I got the following exception:
Exception in thread "main" java.sql.SQLException: Out of memory (Needed 1073741824 bytes)
...
14
votes
3answers
8k views
How do you calculate mysql max_connections variable?
How do you calculate mysql max_connections ?
What do you take into consideration ?
4
votes
1answer
180 views
Can PostgreSQL tell me what configuration files it's using?
I am having trouble with some changes I'm making to a configuration file. I think PostgreSQL is not using the ones I'm modifying. Is there any way to get postgres (maybe some environment variable) to ...
8
votes
4answers
3k views
Are there any MySQL Benchmarking tools?
I've heard a long time ago that there is this tool that helps you tweek mysql settings for better performance but i can't seam to find it. I am aware that I can use ab for apache to simulate high ...
