Performance Tuning

Primary tabs

mysql

Various tips and suggestions for optimizing MySQL performance.

MySQLTuner
http://blog.mysqltuner.com
Tuning MySQL Performance with MySQLTuner
Download the MySQLTuner script:

cd /extra/src
wget http://mysqltuner.pl/ -O mysqltuner.pl

Running it is very simple:

perl mysqltuner.pl

After entering your MySQL root username and password, the script will output a variety of stats on your MySQL server and suggestions to improve the performance.

Optimize tables
mysqlcheck -u root -p --auto-repair --optimize

Recent Updates

Apache

2 years 2 days ago
Apache

2 years 2 days ago
lighttpd

2 years 5 days ago

php 8.x
MariaDB

2 years 6 days ago

10.6.7
CentOS

2 years 1 week ago

Drop Centos 5/6 stuff

Recent Links

SquidGuard

SquidGuard is a URL redirector used to use blacklists with the proxysoftware Squid. There are two big advantages to squidguard: it is fast and it is free.
NCurses Disk Usage

A disk usage analyzer with an ncurses interface, aimed to be run on a remote server where you don't have an entire gaphical setup, but have to do with a simple SSH connection. ncdu aims to be fast, simple and easy to use, and should be able to run in any minimal POSIX-like environment with ncurses installed.
WPKG

WPKG is an automated software deployment, upgrade and removal program for Windows.

It can be used to push/pull software packages, such as Service Packs, hotfixes, or program installations from a central server (for example, Samba or Active Directory) to a number of workstations.

It can run as a service to install software in the background (silent install), without user interaction.

It can install MSI, InstallShield, PackagefortheWeb, Inno Setup, Nullsoft, other software installers or .exe packages, .bat and .cmd scripts and similar: no more repackaging to perform software installation.

WPKG is open source software.
opsi

opsi (Open PC Server Integration) the Open Source client management system
Vagrant

Vagrant is a tool for building complete development environments. With an easy-to-use workflow and focus on automation, Vagrant lowers development environment setup time, increases development/production parity, and makes the "works on my machine" excuse a relic of the past.

Main menu

You are here

Performance Tuning

Primary tabs

Recent Updates

Recent Links