Always backup your data along with the my.ini or my.cnf file
To add to the performance of a MySQL database, there are many tweaks for the my.ini or my.cnf file. Two things that you can do is first add a SSD as a secondary drive and then move your temp file to the SSD by adding the following line just below the [mysqld] section -
You must change the letter H to the drive letter of your new SSD drive. If you have a linux based computer, set the appropriate permissions.
Restart mysql or restart the computer.
After being asked ‘Why?’ are these devices are on the web, we have sent a series of questions to industry leading experts…coming soon
SCADA devices are systems that control manufacturing or infrastructure devices. We are always calling for the need to protect these devices with appropriate security measures. Here’s a look at how easily they can be found and seen by anyone on the internet.
Steps to protect SCADA (Supervisory control and data acquisition networks)
While disabling LLMNR can speed up your SQL connection sometimes, ironically you may be slowed down by MS14-066 (KB2992611).
See this article -
“Microsoft does it again, botches KB 2992611 SChannel patch” – Infoworld
What do you do? The article above gives some advice and more advice comes from the link at the bottom of this blog posting.
Here’s a couple of fixes if you installed KB2992611 and your SQL server came to a crawl
Possible fixes if you’re already affected:
Go to computer configuration > administrative templates > Network > SSL Configuration Settings > SSL Cipher Suite Order
Set it to enabled
Reboot or gpupdate /refresh at an elevated command prompt
The policy populates the Windows registry with the legacy cipher suites less the 4 new cipher suites added by MS14-066 /2992611.
Source/Credit : http://blogs.msmvps.com/spywaresucks/2014/11/16/hold-off-installing-ms14-066-kb-2992611/
Note: ALWAYS backup your data before your try reversing a patch or modifying policies or the registry.
Microsoft should fix this soon…
Here’s how to improve performance – LLMNR -
One of the most talented people I know is Jared Ledlow. A former student, Jared was remarkable at diagnosing computers, learning new technology and absolutely loved playing and writing music. His personality is contagious and his unselfishness in learning and teaching others is above reproach.
After graduation, Jared started as a government contractor resolving help desk tickets.
He went on to become a Technical Assistance Associate in one of the largest data centers.
Jared now monitors the critical infrastructure behind the day to day operations in his company’s data center.
Some of his responsibilities include monitoring UPSs, CRAC units and a ton more.
In IT you need motivation, initiative, worker ethics, a desire to learn and more. Jared Ledlow has these qualities and more.
If you cannot change accounts in Windows 8, 8.1 or Windows 8.1 Update there are several things you can try -
First try editing the registry
In the search box, type regedit
Navigate to the following:
Modify the registry value of HideFastUserSwitching from 1 to 0
Log off and restart the machine
Did it work? If not, try editing the group policy
In the search box, type gpedit.msc
Navigate to -
Local Computer Policy/Computer Configuration/AdministrativeTemplates/System/Logon
Double click Hide Entry Points for Fast User Switching to bring up a dialog box to change Fast User Switching policy setting.
Close the group policy editor
Open a command prompt and type gpupdate /force
If the above did not work, try a refresh pc
Go to a “Command Prompt” as an Administrator
shutdown.exe /r /o /f /t 00
The computer will restart
Select Refresh PC