Tag Info

New answers tagged

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).


2

I ran into a similar issue where I was on OSX and now have a windows computer. I don't want to have to re-enter all of the connection entries. I found out that on OSX the PGADMIN III servers list is located in your home user directory inside the file "pgadmin3 Preferences". Now it doesn't seem like there is an easy way to import this into a non-OSX ...


2

If you comment out keyFile (assuming you have not specified auth explicitly) you will turn off authentication. Basically keyFile implies auth but not the other way around. When you comment out shardsvr, the port will change from 27018 to the default port number - 27017. That is actually a good thing. When you take a node out of a replica set or a sharded ...


0

you need to make sure the correct my.ini is edited, you can check it from windows services by opening MySQL properties and make sure it is related to MySQL 5.6. now you need to stop the service then open the ini file in the service description and edit the port. finally start the service and try to log in from CMD using: 1) cd C:\Archivos de ...


0

MySQL 5.6 my.ini file is in the path where the data is stored, in my case C:\Documents and Settings\All Users\Datos de programa\MySQL\MySQL Server 5.6 instead of the path where mysql is install C:\Archivos de programa\MySQL\MySQL Server 5.6 , like older versions. We have to change C:\Documents and Settings\All Users\Datos de programa\MySQL\MySQL ...



Top 50 recent answers are included