mysql tuning

for high load mysql servers you most probably will need suggestion what parameter you should change to improve performance

First of all I recommend to run mysqltuner script
usage:

wget http://mysqltuner.com/mysqltuner.pl
chmod +x mysqltuner.pl
./mysqltuner.pl

You will be prompted to enter valid mysql credentials and after that you will see recommendation what should you tune on your mysql server

mysql optimize tables

and there I found nice perl script which can be run on your server and you can optimize tables in DB
you can download it from there

dotnetpanel become opensource

DotNetPanel become OpenSource  and change its name to WebSitePanel

 

http://www.websitepanel.net/

connection count

nice command for counting connection:

netstat -anp |grep 'tcp\|udp' | awk '{print $5}' | cut -d: -f1 | sort | uniq -c | sort -n

Mount remote FS using SSH

for different purposes you may need to copy a lot of files from your machine to remote. You can use SFTP or SCP but more beautiful solution  is mounting remote catalogs in your system using ssh. As my favorite Linux is Debian, so all examples are for this distr.

 

1. installation SSHFS support

apt-get install sshfs

2. MODULE LOAD

modprobe fuse

 

3. setup permissions

adduser username fuse

chown root:fuse /dev/fuse

 

4. mount remote catalogs

mkdir ~/remoteserver
sshfs username@host:/path ~/remoteserver

 

and for unmounting you can use this command

 

umount ~/remoteserver

Cacti templates

http://www.debianhelp.co.uk/cactitemplates.htm nice collection of Cacti templates