Matt Ray MattRay0295

## index-usage.sql
// Finds unused indexes in a mysql database

SELECT
  t.TABLE_SCHEMA,
  t.TABLE_NAME,
  s.INDEX_NAME,
  s.COLUMN_NAME,
  s.SEQ_IN_INDEX,
  ( SELECT MAX(SEQ_IN_INDEX)
    FROM INFORMATION_SCHEMA.STATISTICS s2

## FullCacheClear.ps1
#------------------------------------------------------------------#
#- Clear-WindowsUserCacheFiles                                     #
#------------------------------------------------------------------#
function Clear-WindowsUserCacheFiles {
  param([string]$user = $env:USERNAME)
  Remove-CacheFiles "C:\Users\$user\AppData\Local\Temp"
  Remove-CacheFiles "C:\Users\$user\AppData\Local\Microsoft\Windows\WER"
  Remove-CacheFiles "C:\Users\$user\AppData\Local\Microsoft\Windows\Temporary Internet Files"
}

## README.md

      
              3 files
            
          
              0 forks
            
          
              0 comments
            
          
              1 star
            
          
                MattRay0295
                / README.md
            
            
              Created
              April 13, 2021 01:26
                — forked from wesray/README.md
            
              
                Windows 10 Install - Chocolatey with Applications 
              
          
    TODO


WSL2 (ref below)
https://gist.github.com/leodutra/a6cebe11db5414cdaedc6e75ad194a00#file-install-wsl-devenv-md


## osx-for-hackers.sh
#!/bin/sh

###
# SOME COMMANDS WILL NOT WORK ON macOS (Sierra or newer)
# For Sierra or newer, see https://github.com/mathiasbynens/dotfiles/blob/master/.macos
###

# Alot of these configs have been taken from the various places
# on the web, most from here
# https://github.com/mathiasbynens/dotfiles/blob/5b3c8418ed42d93af2e647dc9d122f25cc034871/.osx

## setup_mac.sh
# Script to setup a new Mac

# Fix up the key repeat issues on MacOS Sierra. Need the key repeats for VIM!
defaults write NSGlobalDomain KeyRepeat -int 2
defaults write NSGlobalDomain InitialKeyRepeat -int 15
defaults write NSGlobalDomain ApplePressAndHoldEnabled -bool false

# Finder should show all .files
defaults write com.apple.finder AppleShowAllFiles YES
	// Finds unused indexes in a mysql database

	SELECT
	t.TABLE_SCHEMA,
	t.TABLE_NAME,
	s.INDEX_NAME,
	s.COLUMN_NAME,
	s.SEQ_IN_INDEX,
	( SELECT MAX(SEQ_IN_INDEX)
	FROM INFORMATION_SCHEMA.STATISTICS s2
	#------------------------------------------------------------------#
	#- Clear-WindowsUserCacheFiles #
	#------------------------------------------------------------------#
	function Clear-WindowsUserCacheFiles {
	param([string]$user = $env:USERNAME)
	Remove-CacheFiles "C:\Users\$user\AppData\Local\Temp"
	Remove-CacheFiles "C:\Users\$user\AppData\Local\Microsoft\Windows\WER"
	Remove-CacheFiles "C:\Users\$user\AppData\Local\Microsoft\Windows\Temporary Internet Files"
	}
	#!/bin/sh

	###
	# SOME COMMANDS WILL NOT WORK ON macOS (Sierra or newer)
	# For Sierra or newer, see https://github.com/mathiasbynens/dotfiles/blob/master/.macos
	###

	# Alot of these configs have been taken from the various places
	# on the web, most from here
	# https://github.com/mathiasbynens/dotfiles/blob/5b3c8418ed42d93af2e647dc9d122f25cc034871/.osx
	# Script to setup a new Mac

	# Fix up the key repeat issues on MacOS Sierra. Need the key repeats for VIM!
	defaults write NSGlobalDomain KeyRepeat -int 2
	defaults write NSGlobalDomain InitialKeyRepeat -int 15
	defaults write NSGlobalDomain ApplePressAndHoldEnabled -bool false

	# Finder should show all .files
	defaults write com.apple.finder AppleShowAllFiles YES