New answers tagged

2

Such a tool would be almost completely worthless in practical use. max_connections has nothing to do with performance. It's a safety mechanism to prevent a runaway application from making so many connections that the server becomes overwhelmed. The value makes absolutely no difference unless you are using that many connections. It is also a value that ...


-2

I have been using mysqltuner.pl from mysqltuner.com for years. It's not automatic, it analyses and makes recommendations. Good for part time dba's like me.


0

Im not sure about a script but you can build your own based on MySQL recommendations and good practices shared by experts here: InnoDB Buffer Pool Hit Rate How much memory do I need for innodb buffer pool? Optimal Number of MySQL InnoDB Buffer Pool Instances Making sense of INNODB buffer pool stats How to clear/flush mysql innodb buffer pool? MySQL ...


0

Installs of MySQL for Windows is like drudgery but possible I usually use the no-install zip file. After installing it in an appropriate location, I go to the bin folder and run mysqld --install This creates the service called MySQL. Please make sure the my.ini is in the parent directory of the bin folder. Since you are installing different versions ...


1

You can install the latest version available at the time of purchase, but no newer versions after that. The "funny" part is, these versions (like 11.2.0.4) can be obtained from https://support.oracle.com/, but you can not download them, because you do not have a support contract. In this case, when you request the installation media, an Oracle ...


2

What files do I need to install SQL 2014 SP1 CU6? You would need SQL Server 2014 RTM setup SQL Server 2014 SP1 Setup. This can be downloaded from here You would need SQL Server 2014 Sp1 CU6 setup. This can be downloaded from here. Note: Quite a few times you would find SP1 embedded in SQL Server 2014 installation files in that case you dont need to ...


0

The following is the excerpt of runInstaller.sh file # Abort the install, if install/.oui file is not found in the stage area # if [ ! -f $CMDDIR/install/.oui ] then echo "Source location is incomplete. Make sure you have downloaded and extracted all the relevant archives." exit 1 fi # Which clearly states that if you have missed the .oui ...


3

UseMicrosoftUpdate - Setting it to TRUE - it will change the computer settings to include the latest updates when you scan for Windows Update. I would suggest to set it FALSE and you decide what updates you want for SQL Server in-terms of SPs/CUs. From BOL : UpdateEnabled - Specify whether SQL Server setup should discover and include product updates. ...


1

Not sure if you ever got this solved, but I was able to find it in the GAC: C:\Windows\assembly\GAC_MSIL\Microsoft.DataTransformationServices.Controls\...\Microsoft.DataTransformationServices.Controls.DLL Let me know if that did the trick for you


-2

Set the owner of Oracle services to be the domain admin account.


2

Rather than struggling with Evaluation Edition and the (limited) VMware Workstation Player, you could install Developer Edition instead. This is a supported configuration on the host OS (Windows 10 Home): Hardware and Software Requirements for Installing SQL Server 2014 Developer Edition is functionally the same as Enterprise/Evaluation Edition, but with ...



Top 50 recent answers are included