The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
82 views

Mongodb ubuntu - config server and shard together

I have the following services on a single shard server: sudo mongod --dbpath /data/db/ --port 31001 sudo mongod --configsvr --dbpath /data/configdb/ --port 21001 The same server is using for shard ...
10
votes
4answers
4k 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 ...
18
votes
3answers
13k views

How do you calculate mysql max_connections variable?

How do you calculate mysql max_connections ? What do you take into consideration ?
0
votes
1answer
27 views

Line Comment in MongoDB config file

How to mark a line comment in mongodb configuration file? cpu=true #temporary for dev env Is this the right way? There is no clue about it in their website page about setting the configuration ...
0
votes
2answers
114 views

bind-address how does it work in mysql

I have a mysql running with bind-address "10.4.0.211". From the documentation, I understand it like, the server accepts connections only from the IP - 10.4.0.211. But I could able to connect to ...
0
votes
2answers
5k views

How to set Innodb Buffer Pool Size [duplicate]

I have a database using innodb completely. Its now having a innodb_buffer_pool_size at 128MB. Which I know is very less for my user. But no matter what I do it won't change. I have added a value of ...
0
votes
0answers
22 views

What does “Remove fully qualified host names from /etc/hosts and use these in config.ini for all clusters hosts” means?

Caution You cannot mix localhost and other host names or IP addresses in config.ini. For these reasons, the solution in such cases (other than to use IP addresses for all config.ini HostName ...
0
votes
2answers
192 views

Mysql slow.log user specific

I use a slow.log logging on my MySQL server, to catch bottlenecks in my script, but at the same time, i use phpmyadmin on this server. My script and pma has different MySQL user accounts and now, when ...
0
votes
1answer
187 views

MySql - set my.cnf location at server start

I want to have two MySql servers running on the same system (for master-slave replication tests purposes). To be able to do this I need both servers read different my.cnf files. As I see at startup ...
2
votes
0answers
56 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 ...
10
votes
3answers
2k 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 ...
1
vote
0answers
42 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
541 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
4answers
13k 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) ...
10
votes
6answers
2k 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 ...
6
votes
1answer
357 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 ...