Tag: tips

Some Tools and Tips

No Comments

May 3, 2011 at 8:03 pmCategory:Tools & Tips

HTOP

This is htop, an interactive process viewer for Linux. It is a text-mode application (for console or X terminals) and requires ncurses. Tested with Linux 2.4 and 2.6.

Needed RPMForge Repo for easy installation.

yum install htop

And Finish!



MTOP

Monitors a MySQL server showing the queries which are taking the most amount of time to complete. Features include ‘zooming’ in on a process to show the complete query, ‘explaining’ the query optimizer information for a query and ‘killing’ queries. In addition, server performance statistics, configuration information, and tuning tips are provided.

Needed RPMForge Repo for easy installation:

yum install mtop

Create file .mtoprc in own Home.

cd ~
vim .mtoprc

Add the following line in this file:

--dbuser=root --password=mypass --seconds=1

Save and Quit.

Run this comand:

mtop

And Finish!

To be Continued…

Install PhpMyAdmin

No Comments

May 3, 2011 at 6:42 pmCategory:Tools & Tips


PhpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

Install phpmyadmin and dependencies (libmcrypt, php-mbstring, php-mcrypt)

yum install phpmyadmin

Edit next file: config.inc.php
Read More…