Tag Info

New answers tagged

2

This is a parameter that is processed by the OpenSSL library. The format and options are documented in the ciphers(5) man page. For the ones you mention: ALL all cipher suites except the eNULL ciphers which must be explicitly enabled; as of OpenSSL, the ALL cipher suites are reasonably ordered by default ADH anonymous DH cipher suites, ...


1

This is a good summary: http://fromdual.com/mysql-cluster-memory-sizing Most memory buffers are preallocated in memory to avoid latency issues when reserving huge chunks of memory.


2

Is there a way to permanently configure this setting, either in the .pgpass file or anywhere else Yes there is: it's ~/.psqlrc (or %APPDATA%\postgresql\psqlrc.conf in Windows) See the manual for details: http://www.postgresql.org/docs/current/static/app-psql.html#AEN88713


0

Oops, as often, the answer was in the question. Must've been pretty tired, because as I said : Anyway, the important part is : datadir=/var/lib/mysql chroot=/var/lib/mysql But, if I wanna be consistent with myself, chroot must be /var/chroot/mysql. So the correct setting is : datadir=/var/lib/mysql chroot=/var/chroot/mysql And indeed ...


1

Search for mysql-related packages that are now installed: rpm -qa | grep -i mysql Delete any packages like mysql, mysql-server, mysql-client, mysql-shared, mysql-shared-compat, mysql-libs. yum remove mysql-server You do not need to remove mysql library bindings like python-mysqldb, php-mysql, etc., unless they had a dependency with some of the previous ...


0

Try MySQL Tuner which will give industry standard recommendations. The link for getting started with mysqltuner is: http://www.faqforge.com/linux/optimize-mysql-performance-with-mysqltuner/ You can download mysql tuner from here http://mysqltuner.com/


0

You have a complex environment with SSIS and SSAS so you have to be cautious with max server memory setting for SQL Server in your scenario Jonathans blogs would not provide complete help. You should refer to below Microsoft link for determining memory requirement for SSIS http://technet.microsoft.com/library/Cc966529#EEAA You should leave enough memory for ...


1

You should always set your max memory away from default and leave some room for OS (see Jonathan's post of how much Memory to leave based on the amount of RAM installed). Jonathan Kehayias has blogged about : How much memory does my SQL Server actually need? reserve 1 GB of RAM for the OS, 1 GB for each 4 GB of RAM installed from 4–16 GB, and then 1 GB ...


1

Sounds like PhpPgAdmin is probably doing a session-level SET bytea_output = 'escape'. If you open a new psql session and SHOW bytea_output; it'll be hex there. PhpPgAdmin may offer a way to control this behaviour, or it might be hard-coded to work around compatibility issues (if it doesn't understand the hex format for bytea).



Top 50 recent answers are included