From gnuru.org If you want to use proper database features in mysql – the sort that Postgresql has as standard – you need to use the InnoDB storage engine rather than the default MyISAM. To see what sort of storage engine your tables are currently using do this in the mysql shell: SELECT TABLE_NAME, ENGINE…

From xrado.hopto.org Just as mysql has a slow log which is enable through the /etc/my.cnf, php slow logging can be enabled via the following info… A few days ago a friend called me, asking me how could he find the slowest PHP scripts on its server? ..and didn’t think of anything. Of course there are…

From linux-mag.com Quick and Dirty MySQL Performance Troubleshooting – What are the first things you should look at after learning of a sudden change in MySQL server performance? Sooner or later, you’re going to get that phone call (or email, SMS, instant message, tweet, or whatever): The database is slow! Fix ASAP! And you’ll be…

From petur.eu Howto download ISO files directly to a CD/DVD/BLU-RAY It is possible to download .iso files directly onto a cd\dvd\blu-ray disk. /dev/shm is a directory found on Debian & RedHat based distributions. (Please let me know if you find it on dists as well) /dev/shm is a dynamic RAM disk, meaning it’s size will…

What is the best way to generate a htpasswd? htpasswd is used to generate, store and update the file used for basic http authentication. To create a new password file from the command line; # htpasswd -c /home/user/.htpasswd username The previous command will generate a new file called .htpasswd in the users /home/user directory and…

Plesk Quick Reference… for those of us who hate Plesk. Update Plesk Version: /usr/local/psa/bin/autoinstaller Plesk user: (also the name of the init script) psa. Plesk Daemon: Is actually “sw-cp-server” and logs to /var/log/sw-cp-server/error_log There is an issue with it on 9.0 and the CentOS openssl package. http://kb.parallels.com/8338 Mail: qmail. Maildirs are in /var/qmail/mailnames/ config is…

From linuxers.org How to allow users in a group to run all commands in Fedora / CentOS using sudo This tutorial will guide you on how to allow a group of users to run all the commands without sharing your system root password in Fedora / Redhat / CentOS based Distros. This is similar to…

From ubuntugeek.com Gitso is a frontend to reverse VNC connections. It is meant to be a simple two-step process that connects one person to another’s screen. First, the support person offers to give support. Second, the person who needs help connects and has their screen remotely visible. Because Gitso is cross-platform (Linux, OS X and…

From linuxpoison.blogspot.com Before you remove an account from a system, is a good idea lock it for one week to make sure that no one use it. To lock, you can use the follow command: # passwd -l username (where username is the login id). This option is used to lock the specified account and…

From blackonsole.org error export database in phpmyadmin export.php: Missing parameter: what (FAQ 2.8) export.php: Missing parameter: export_type (FAQ 2.8) how to fix error export database on phpmyadmin login to whm and go to Tweak Settings, setup these settings: (11.25.1) PHP Max Post Size for cPanel PHP… = 55M PHP Max Upload Size for cPanel PHP……