Tag Info

Hot answers tagged

1

There is no reasonable way how to do that. For example till 11gR1 SELinux was not certified to be used with Oracle database. Since 11gR2 this is at least not recommended. Let's assume that you and Oracle DBA are adult, where is the problem then? Oracle is not running with root privs. On the other hand Oracle requires many kernel tunables(sysctl) to be set ...


1

TNS Ping does not care about service or SID, all it checks is the availability of the listener, so this does not mean your connection string is correct. Connecting through SQL*Plus successfully however confirms it. Your tnsnames.ora uses SERVICE_NAME in CONNECT_DATA, but your JDBC URL uses the SID syntax. SID and service name are different concepts, and ...


1

First of all, the GUC max_connections - a setting in postgresql.conf. Heroku obviously limits this to 20 for the "Starter Tier" and 500 for the "Production Tier". The maximum number is not limited by Postgres itself, but by available system resources. Typically, performance degrades with too many concurrent connections, so even if you can set ...


1

No, external locking is (was) only needed for MyISAM when you tried to execute several processes on the same data directory, such as two server instances, or an instance and a file repair. Sincerely, I would be surprised if that page manual was accurate and was still fully supported. In any case, it is mostly impossible to do that now, as InnoDB (default ...


1

You can verify that no migrations are running by checking the balance with sh.isBalancerRunning() which is true if chunks are being migrated and false if not. Using BalancerState only shows you if it is enabled or disabled, not its current run state. While it depends on what the specific documentation says, I'd probably feel safer setting the balancer ...


1

Caching to Disk should be your biggest concern. Windows is notorious for caching writes to the operating through the operating system. What this means is that any transaction you write in logs, in .ibd tablespace files, in the system tablespace (ibdata1), would be at the mercy of Windows to get writes to disk. One particular option I am thinking of is ...


1

This is caused by Nagle's algorithm. CouchDB sends the HTTP headers and the response body in separate calls, causing the kernel to not deliver the response body for 40ms. As a workaround, you can use this LD_PRELOAD shim to completely turn off Nagle's algorithm for the database process.


1

MySQL 5.7 (still in development as of this post, but soon to be released) is the first version to include memory profiling. You have to enable memory profiling on the setup instruments (it is disabled by default) ans then you can check it with this sys view: You can get results such as: mysql> select * from sys.memory_by_thread_by_current_bytes limit ...



Only top voted, non community-wiki answers of a minimum length are eligible