Skip to content

Instantly share code, notes, and snippets.

@aahan

aahan/MySQL & MariaDB Config.md

Last active December 12, 2015 09:49
Show Gist options
  • Save aahan/4754712 to your computer and use it in GitHub Desktop.
Save aahan/4754712 to your computer and use it in GitHub Desktop.
Download ZIP
Configuring MySQL/MariaDB - Explanation of important variables.
Raw
MySQL & MariaDB Config.md

MySQL Optimization Tools

Easy Security Tip for MySQL configuration: If you are only using mysql on a server for that one server and it’s not a dedicated server, you should turn off all TCP networking for mysql! Edit your my.cnf ASAP and add the line skip-networking (and restart mysql) Otherwise it’s listening for external connections instead of just local socket connections and it allows evil crackers to try to probe mysql. If you haven’t done this yet and see a high number of “Aborted Connects” you might be getting attacked over the network.

Install Percona Toolkit

$ sudo apt-get install percona-toolkit

You'll see an error, and the package won't install because it requires some dependencies. Simply issue the following command to fix the dependency issues and install Perconal Toolkit:

$ sudo apt-get -f install

Source(s):

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment