The configuration tag has no wiki summary.
3
votes
3answers
1k views
MySQL slow log configuration
Is there a way of making MySQL slow logs to start new log file every day ?
At the moment its just a single large file, and have to grep lines for every day. It would be much more convenient to have ...
3
votes
1answer
338 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 ...
3
votes
4answers
894 views
Is raid 5 suitable for a mysql installation?
Is raid 5 suitable for a mysql installation?
Let me explain my application further. My application is a socket programming which will connect with gps device to receive gps string and there after do ...
7
votes
1answer
889 views
Is it possible to have passwords configured per database or per host in .my.cnf
I have the following in my ~/.my.cnf
[client]
password="somepass"
but this is not the password I use for every user@host/database I connect to. Is there some way to specify in the config different ...
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 ...
4
votes
2answers
2k views
Microsoft SQL Server 2008 Memory
I am running MSSQL 2008 Enterprise and in the configuration of the server the Max memory amount is set to 2147483647 MB.
My Question is, the server has 192 GB of ram,the number in the config can't be ...
6
votes
3answers
390 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 ...
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 ...
2
votes
2answers
117 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 ...
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 ...
0
votes
0answers
64 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 ...
