mtop and mkill are two terminal based mysql monitoring tools.

mtop (MySQL top) monitors a MySQL server and displays the queries which are taking the most amount of time to complete. mtop’s 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.

mkill (MySQL kill) monitors a MySQL server for long running queries and kills them after a specified time interval. Queries can be selected based on regexes on the user, host, command, database, state and query.

These tools can be downloaded from here.

Xataface provides extensible and intuitive user interface for MySQL databases with ability to add/edit/delete/search and manage relationships. It automatically generates the appropriate forms, lists, and menus for a user to interact with the database without having to know any SQL.

It is a full-featured Web application framework, and gives developers the flexibility to customize the features and behavior of their application via configuration files (using the simple INI-file syntax), templates, and plug-ins.

Xataface is for web developers and database administrators who would like to build a front-end for their MySQL database.

Requirements: MySQL 3.23+ , PHP 5+
License: GPL

WAMPs are packages of independently-created programs installed on computers that use a Microsoft Windows operating system. “WAMP” is an acronym formed from the initials of the operating system (Windows) and the components: Apache, MySQL and PHP (or Perl or Python).

Here I’m listing few such open source WAMP packages.

1. WampServer

WampServer is a Windows web development environment. It allows you to create web applications with Apache, PHP and the MySQL database. It also comes with PHPMyAdmin to easily manage your databases.

WampServer will install Apache, PHP5 and MySQL on your Windows system. WampServer comes with a service manager as a tray icon. It will allow you to easily manage your server. You can install all releases of Apache, MySQL and PHP as add-ons.

You can switch online/offline to give access to everyone or only localhost. Read more