How to install Mytop in Plesk servers
Mytop is a Perl program which allows to monitor MySQL servers by viewing active threads, queries and overall server performance numbers.
mytop is a `top’ clone for MySQL
mytop is a console-based (non-gui) tool for monitoring the threads and overall performance of MySQL 3.22.x, 3.23.x, and 4.x servers. It runs on most Unix systems which have Perl, DBI, and Term::ReadKey installed. And with Term::ANSIColor installed you even get color. As of version 0.7, it even runs on Windows (somewhat).
INSTALLATION
tar -zxvf mytop-.tar.gz
cd mytop-
perl Makefile.PL
make
make test
make install
Now installation is over. If you run mytop command, it won’t work in Plesk servers. You need to make some configurations in “~/.mytop” file. Create a file called ~/.mytop and add the below entries in “~/.mytop” file.
$ touch ~/.mytop
$ vi ~/.mytop
user=admin
pass=your mysql password
host=localhost
db=psa
delay=5
port=3306
socket=
batchmode=0
header=1
color=1
idle=1
Run the mytop command
$ mytop -u admin -p(Your Mysql password)
Now you can see the overall performance of your MySQL server.
Installing Parallels Plesk Panel on Linux and FreeBSD
To install Parallels Plesk Panel software on a server
1. Download the Parallels Products Installer utility that suits your operating system from http://www.parallels.com/en/download/plesk9/ and save it on your server’s hard drive.
2. Change your working directory to the directory where the Parallels Products Installer utility resides, for example:
3. Set the execution permission for Parallels Products Installer:
# chmod +x parallels_products_installer_file_name
4. Run the Parallels Products Installer:
# ./parallels_products_installer_file_name
5. Read installation notes displayed on the screen and type ‘n’ to proceed to the next screen. Press ENTER.
Log in to the Parallels Plesk Panel running on your host at https://machine.domain.name:8443/ or https://IP-address:8443/. Use the username ‘admin’ and password ’setup’ (both are case sensitive). For security reasons, change the password upon initial login.
Plesk Directories that usually take much disk space
/var/www/vhosts (/srv/vhosts on SuSE) - domains.
/var/qmail - mail.
/var/lib/mysql - Mysql databases.
/var/lib/psa/dumps - Plesk clients’/domains’ backups.
/var/lib/pgsql/data - Postgres databases.
/var/tomcat* - Tomcat applications.
/var/lib/mailman - Mailman lists.
Please check file /etc/psa/psa.conf for all other directories used by Plesk control panel.
Plesk Contorl Panel under FreeBSD uses the /usr/local partition for storing large quantity of data and /var/db partition for databases.
So the /usr and /var partitions have to be larger in this case.
On Debian and Ubuntu, Plesk itself is located in /opt/psa.
The release of Parallels Plesk Control Panel 8.6 continues Parallels initiative of enabling integration
of all types of web hosting software. This new version of the software further integrates the Parallels
Plesk Control Panel with Parallels Virtuozzo Containers, 3rd party, and other web applications as well
as continuing to deliver innovative ease of use, the highest levels of stability and performance, security
and unmatched value. With over 20 new features and capabilities, Parallels Plesk remains the true
leader in multi-platform control panels.
New Features
- 1. Parallels Plesk Billing Bundle
- 2. Changing DNS zone SOA serial number format
- 3. Improved DNS zone update
- 4. Permission for clients to select a target DB server
- 5. Categories in Application Vault
- 6. DomainKeys support
- 7. 4PSA VoipNow integration
- 8. Database users prefix
- 9. Import/Export Database Backup
- 10. New Plesk events
- 11. Ability to block domain creation in foreign DNS zone
- 12. Extended branding options
- 13. Application Packaging Standard (APS) CGI support
- 14. ProFTPd 1.3.1 Update
- 15. Horde 3.1.7 Update
- 16. SPAW 2.0 Update
- 17. DotNetNuke 4.8.2 Update
- 18. openSuSE 10.3 Support
- 19. Fedora 8 Support
- 20. Parallels Plesk Sitebuilder 4.2 Support
- 21. Simple DNS Plus 5.0 Support
- 22. ColdFusion 8 Support
- 23. SmarterMail 5 Support
- 24. CommuniGate Pro 5.2 Support
- 25. MailEnable 3.14 Support
- 26. Merak 9.2.1 Support
- 27. Parallels Plesk Billing (formerly ModernBill) integration
* ServerBuddies recommends Plesk!
