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.
Requirements:
Before installing Parallels Plesk Panel on FreeBSD, you should add the ‘kern_securelevel_enable=”NO”‘ entry to the /etc/rc.conf file on your server’s file system, and then restart your server.
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.
This explanation tells you how to disable open_basedir in plesk without breaking/commenting your current httpd.conf basedir lines.
Create a new file, called vhost.conf
This file will include anything you want to disable from httpd.conf main config from your virtual host.
-
# touch /var/www/vhosts/yourdomain.com/conf/vhost.conf
Now we edit the file and we add the following,
-
# vi /var/www/vhosts/yourdomain.com/conf/vhost.conf
<Directory /var/www/vhosts/yourdomain.com/httpdocs>
php_admin_value open_basedir none
</Directory>
Once you finish adding the mentioned lines, its time to reconfigure and restart the webserver config.
-
# /usr/local/psa/admin/sbin/websrvmng -v -a
open_basedir for yourdomain.com should be disabled by now.
