MySql Tools & Utilities
Following is the list of some tools which support MySql:
Tools to Monitor Queries and Transactions:
1). mytop: tool for monitoring queries. It is a Perl program that runs in a terminal and displays information about all connections in a tabular layout, similar to the Unix top program's process display. Columns include the connection ID, the connection's status, and the text of the current query. From this display you can select a query to EXPLAIN, kill a query, and a few other tasks.
2). mtop: (MySQL top) 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.
3). 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.
4). innotop: a powerful text-mode MySQL and InnoDB monitoring tool. It has lots of features, is fast and configurable, and it’s easy to use.
5). phpMyTop: It is a web based mytop clone. It is useful when we don't have shell access and can't connect remotely to our database server, but can connect from a web server.
6). ajaxMyTop: it’s function is similar to phpMyTop. It also feels more like a traditional GUI program, the entire page does not constantly refresh itself.
7). phpMyAdmin : It is also a web based tool with features to design tables, run queries, manage users and more. Its focus isn't on monitoring queries and processes, but it has some of the features such as showing a process list.
Tools to Monitor a MySQL Server:
1). mysqlreport: It is a well-designed program that turns MySQL status information into knowledge. It prints out a report of relevant variables, sensibly arranged for an experienced MySQL user.
2). Nagios: Nagios is an open source host, service and network monitoring program. Its task is setting up automated systems to monitor your server and let you know if it's alive
3). mysqlmonitor: It monitors a Mysql database server. It is designed to be used as a monitor for the mon package. As such if any host's Mysql server is dead it returns 1 and outputs the hostnames that failed. If all hosts' servers are alive 0 is returned.
Following is the list of some MySql Utilities:
1). isamchk
isamchk [options]table [table...]
Performs operations on the database table files themselves (called ISAM files for Indexed Sequential Access Method). This utility is used to check and repair the files, as well as report information about them. You must provide the correct path to the ISAM file you wish to examine. The default location for the ISAM files is /usr/local/var/databasename/tablename.ISM.
2). isamlog
isamlog [options] [logfile] [table]
Displays information about ISAM logs. An ISAM log is generated if the MySQL server is started with the -log-isam option. The information in the ISAM log can be used to recover damaged tables using the -r option. However, modifying the data files directly can be dangerous and you should always back up your data before doing so.
3). mysql
mysql [options] [database]
The MySQL command line monitor. This program is the most basic way to communicate with the MySQL server. SQL commands can be typed directly on the command line and the results are displayed on the screen. If database is supplied, it is automatically selected as the current database.
4). mysqlaccess
mysqlaccess [options] [host] user database
Displays and modifies access rights for the MySQL server. You may examine the rights of users for any database and in connection with any host. Unix shell wildcards `*' and `?' may be used to match multiple hosts, users and databases. All actions are performed on a copy of the actual grant tables until a mysqlaccess --commit command is sent.
5). mysqladmin
mysqladmin [options] command [command...]
Performs operations that affect the database server as a whole. This utility is used to shutdown the database server, add and delete entire databases, and other administrative functions.
6). mysqlbug
mysqlbug
Reports a bug in a MySQL program or utility. This program collects information about your MySQL installation and sends a detailed problem report to the MySQL team.
7). mysqld
mysqld [options]
The MySQL server daemon. All other programs interact with the database through this server, so it should be left running at all times (except when down for maintenance). The daemon is usually started from a script called safe_mysqld. This script sets the appropriate environment variables and launches mysqld with the necessary arguments.
8). mysqldump
mysqldump [options] database[table]
Outputs the contents of the given database (or table within a database) as a series of ANSI SQL commands. This command is handy for breaking up a database; use the -1 and -opt options.
9). mysqlimport
mysqlimport [options] database [file]
Reads a file of data in a variety of common formats (such as comma delimited or fixed width) and inserts the data into a database. A table with the same name as the file must exist in the database with enough columns of the appropriate type to store the data.
10). mysqlshow
mysqlshow [options] [database] [table] [field]
Displays the layout of the requested database, table or field. If no argument is given, a list of all of the databases is given. With one argument the layout of the given database is displayed. With two arguments, a table within the database is displayed. If all three arguments are present, the information about a specific field within a table is presented.
Tools to Monitor Queries and Transactions:
1). mytop: tool for monitoring queries. It is a Perl program that runs in a terminal and displays information about all connections in a tabular layout, similar to the Unix top program's process display. Columns include the connection ID, the connection's status, and the text of the current query. From this display you can select a query to EXPLAIN, kill a query, and a few other tasks.
2). mtop: (MySQL top) 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.
3). 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.
4). innotop: a powerful text-mode MySQL and InnoDB monitoring tool. It has lots of features, is fast and configurable, and it’s easy to use.
5). phpMyTop: It is a web based mytop clone. It is useful when we don't have shell access and can't connect remotely to our database server, but can connect from a web server.
6). ajaxMyTop: it’s function is similar to phpMyTop. It also feels more like a traditional GUI program, the entire page does not constantly refresh itself.
7). phpMyAdmin : It is also a web based tool with features to design tables, run queries, manage users and more. Its focus isn't on monitoring queries and processes, but it has some of the features such as showing a process list.
Tools to Monitor a MySQL Server:
1). mysqlreport: It is a well-designed program that turns MySQL status information into knowledge. It prints out a report of relevant variables, sensibly arranged for an experienced MySQL user.
2). Nagios: Nagios is an open source host, service and network monitoring program. Its task is setting up automated systems to monitor your server and let you know if it's alive
3). mysqlmonitor: It monitors a Mysql database server. It is designed to be used as a monitor for the mon package. As such if any host's Mysql server is dead it returns 1 and outputs the hostnames that failed. If all hosts' servers are alive 0 is returned.
Following is the list of some MySql Utilities:
1). isamchk
isamchk [options]table [table...]
Performs operations on the database table files themselves (called ISAM files for Indexed Sequential Access Method). This utility is used to check and repair the files, as well as report information about them. You must provide the correct path to the ISAM file you wish to examine. The default location for the ISAM files is /usr/local/var/databasename/tablename.ISM.
2). isamlog
isamlog [options] [logfile] [table]
Displays information about ISAM logs. An ISAM log is generated if the MySQL server is started with the -log-isam option. The information in the ISAM log can be used to recover damaged tables using the -r option. However, modifying the data files directly can be dangerous and you should always back up your data before doing so.
3). mysql
mysql [options] [database]
The MySQL command line monitor. This program is the most basic way to communicate with the MySQL server. SQL commands can be typed directly on the command line and the results are displayed on the screen. If database is supplied, it is automatically selected as the current database.
4). mysqlaccess
mysqlaccess [options] [host] user database
Displays and modifies access rights for the MySQL server. You may examine the rights of users for any database and in connection with any host. Unix shell wildcards `*' and `?' may be used to match multiple hosts, users and databases. All actions are performed on a copy of the actual grant tables until a mysqlaccess --commit command is sent.
5). mysqladmin
mysqladmin [options] command [command...]
Performs operations that affect the database server as a whole. This utility is used to shutdown the database server, add and delete entire databases, and other administrative functions.
6). mysqlbug
mysqlbug
Reports a bug in a MySQL program or utility. This program collects information about your MySQL installation and sends a detailed problem report to the MySQL team.
7). mysqld
mysqld [options]
The MySQL server daemon. All other programs interact with the database through this server, so it should be left running at all times (except when down for maintenance). The daemon is usually started from a script called safe_mysqld. This script sets the appropriate environment variables and launches mysqld with the necessary arguments.
8). mysqldump
mysqldump [options] database[table]
Outputs the contents of the given database (or table within a database) as a series of ANSI SQL commands. This command is handy for breaking up a database; use the -1 and -opt options.
9). mysqlimport
mysqlimport [options] database [file]
Reads a file of data in a variety of common formats (such as comma delimited or fixed width) and inserts the data into a database. A table with the same name as the file must exist in the database with enough columns of the appropriate type to store the data.
10). mysqlshow
mysqlshow [options] [database] [table] [field]
Displays the layout of the requested database, table or field. If no argument is given, a list of all of the databases is given. With one argument the layout of the given database is displayed. With two arguments, a table within the database is displayed. If all three arguments are present, the information about a specific field within a table is presented.
Thank you for writing list of some tools which support MySql, Tools to monitor mysql server & List of MySql utilities. It is very helpful post for me. Keep it up!