kget Download tool

KGET is a a download manager similar to GetRight or Go!zilla. It keeps all your downloads in one dialog and you can add and remove transfers. Transfers can be paused, resumed, queued or scheduled. Dialogs display info about status of transfers - progress, size, speed and remaining time. Program supports drag & drop from KDE applications and Netscape.

 # sudo aptitude install kget

Dowinload using aria2 / Aria

Aria2 is a command line download client with resuming and segmented downloading. Supported protocols are HTTP/HTTPS/FTP/BitTorrent and it also supports Metalink.
 
# sudo aptitude install aria2

# sudo aptitude install aria

Downloading using prozilla - with GUI frontend

One of the drawback of axel is you can not specify ftp username and password. You can use prozilla program, which also makes multiple connections and downloads a file in multiple parts simultaneously thus enhancing the download speed and dwnloading the file faster than a download with a single connection.
 
 FTP passwords can be specified with the URL, or can be obtained automatically from ~/.netrc if it exists.

 # yum install prozilla

 $ sudo apt-get install prozilla

OR

# rpm -ivh prozilla-2.0.4-19.1.i386.rpm

# proz http://kernel.org/pub/linux/kernel/v2.6/linux-2.6.17.11.tar.bz2

Download using Axel from commandline

Axel is a command-line downloader for unix-like operating systems. Unlike wget, axel includes download acceleration, whicThis program tries to accelerate the downloading process by using multiple connections for one file.

# sudo apt-get install axel

# yum install axel

You can also specify a speed (bytes per sec) for axel so that it will not eat up all your bandwidth.

$ axel -s 5242880 http://download.com/my.iso

  Limit a number of connection
You can also specify number of connection you want to open. For example open 3 connections for downloading:

$ axel -n 3 -s 5242880 http://download.com/my.iso

# axel -n40 http://mirror.neu.edu.cn/centos/5.7/isos/i386/CentOS-5.7-i386-bin-1of8.iso

Packet Download using Aget

Aget is a multithreaded HTTP download accelerator which is very similar to the windows Flashget tool but only works over the HTTP protocol and does not works on FTP protocol. Tested proven that aget almost reduced the download time by 50% which comparing to the other standard tools like wget, ftp, lynx etc.

  #  wget http://www.enderunix.org/aget/aget-0.4.1.tar.gz
  # make  && make strip
  # make install
 
 $ aget -n10 http://www.enderunix.org/murat/barismanco-hibrahimsofrasi.mp3

OR

# rpm -ivh aget-0.4-sb1.i386.rpm

# aget -n10 http://mirrors.ispros.com.bd/downloadfile.iso

Downloading using gwget

Gwget offers a GNOME front-end to the popular wget application, with enhanced features, such as systray icon, multiple downloads and a powerful preferences manager.

$ sudo apt-get install gwget

# gwget -t -d /home/tech/Downloads/ http://205.196.120.227/zkewcba6n7ng/ew5rvyks171vax3/01+Appangalembadum+-+Usthad+Hotel.mp3

How to monitor active MySQL connections(ajaxmytop)

AjaxMyTop shows active MySQL connections. You get a data grid showing connections, each showing ID, user, duration, and so on. 

 AjaxMyTop currently requires PHP5 and it may not work properly with php 4.x versions. Get it to the exact web root directory which you want to run ajaxMyTop. In my case it is /var/www/html/

# cd /var/www/html

# wget http://downloads.sourceforge.net/project/ajaxmytop/ajaxmytop/ajaxMyTop-0.7.2/ajaxMyTop-0.7.2.tar.gz

 # tar zxvf ajaxMyTop-0.7.2.tar.gz

 # mv ajaxMyTop mytop# cd mytop

Configuring AjaxMyTop

You can configure ajaxMyTop by editing the config.php file. MySQL: It is highly recommended that you create a new user for ajaxMyTop with the SUPER and PROCESS privileges rather than configure ajaxMyTop with an admin user, or continue with the default details.

mysql> GRANT SUPER, PROCESS ON *.* to ‘ajaxmytop’@'localhost’ identified by ‘ajaxmytop’;

 mysql> GRANT SUPER, PROCESS ON *.* to ‘ajaxmytop’@'%’ identified by ‘ajaxmytop’;

Apparently you must also grant the SELECT privilege to the ajaxmytop user for all databases in which you may want to explain threads.

mysql> GRANT USAGE, SELECT ON test.* to ‘ajaxmytop’@'localhost’ identified by ‘ajaxmytop’;

mysql> GRANT USAGE, SELECT ON test.* to ‘ajaxmytop’@'%’ identified by ‘ajaxmytop’;

Edit the config.php and enter the user-name and password setting which you have setup. Access it via your server ip or domain based on your installation location.

http://192.168.1.67/mytop/
 

Make sure you have .htaccess folder permission enabled on the mytop folder or else everyone can access and view your mysql query usages etc.