MySQLTuner Installation and Execution

Installation Debian / Ubuntu: apt-get install mysqltuner Execution Run Application with Specific Username / Password; mysqltuner --host 127.0.0.1 --user (username) --pass ('password here') Note #1: Remove Parentheses Note #2: Remove '--host 127.0.0.1' if running 'skip-name-resolve' in my.cnf
Read More

MySQL Configuration and Optimization

Display Following Commands are Executed in MySQL View Running Engines; show engines; Find open_files_limit; SHOW GLOBAL VARIABLES LIKE 'open_files_limit'; Configuration Enable Query Cache; SET GLOBAL query_cache_type=1; Validate Query Cache is Enabled; show variables like 'query_cache_size'; Optimize Enable Query Cache Limits; (Add the following to my.cnf file) query_cache_type = 1 query_cache_size = 256M query_cache_limit = 2M…
Read More

Creating / Removing a Swap File

Create Swap File: sudo fallocate -l 2G /swapfile sudo chmod 600 /swapfile sudo mkswap /swapfile sudo swapon /swapfile Make Swap File Permanent: sudo nano /etc/fstab Add to the end: /swapfile none swap sw 0 0 Removing a Swap File: sudo vi /etc/fstab Remove from the end: /swapfile none swap sw 0 0 (line aforementioned may…
Read More

Google Technical Support – Account Issues

Google
Google-play developer-account issues google may be contacted here; https://support.google.com/googleplay/android-developer/answer/139626#contact=1 Merchant-account issues google may be contacted here; https://support.google.com/checkout/sell/answer/3098749?hl=en#contact=1
Read More

Force a GitHub Override on Local Files

If you’re trying to override your local files with the GitHub repository files then please follow the simple instruction below. Please run the following command; git fetch --all To default to the most recent branch, please run the following command; git reset --hard origin/master If you are on a different branch, please run the following…
Read More

Ubuntu Apt-Get Quick Reference Guide

Ubuntu
List installed packages (simple); sudo apt list --installed | less To install a pachage please run the following command; sudo apt-get install To search for a package please run the following command; apt-cache search keyword To update package repositories please run the following command; sudo apt-get update To upgrade all packages from the updated repositories…
Read More
Menu