Различия

Показаны различия между двумя версиями страницы.

--- mysql:mytop [2015/09/15 23:59] – внешнее изменение 127.0.0.1
+++ mysql:mytop [2018/06/20 16:40] (текущий) – [Установка] mirocow
@@ Строка 1: / Строка 1: @@
-{{tag>shell utils}}
+{{tag>shell utils mysql}}
 ====== Mytop ======
+mytop is a console-based (non-gui) tool for monitoring the threads and overall performance of a MySQL 3.22.x, 3.23.x, and 4.x server. It runs on most Unix systems (including Mac OS X) which have Perl, DBI, and Term::ReadKey installed. And with Term::ANSIColor installed you even get color. If you install Time::HiRes, you'll get good real-time queries/second stats. As of version 0.7, it even runs on Windows (somewhat).
+===== Установка =====
+<code bash>
+$ wget http://jeremy.zawodny.com/mysql/mytop/mytop-1.6.tar.gz
+$ tar xvfz mytop-1.6.tar.gz
+$ cpan install Config::IniFiles
+</code>
+===== Использование =====
 Мониторнг базы данных MySQL или MariaDB
@@ Строка 9: / Строка 21: @@
   * mytop -u root -p password
   * mytop -S /var/run/mysqld/mysqld.sock -u root -p password -s 1
+===== Пользовательските настройки =====
+nano ~/.mytop
+<code bash>
+user=root
+pass=password
+host=localhost
+delay=5
+port=3306
+socket=
+batchmode=0
+header=1
+color=1
+idle=1
+</code>
+===== Debian =====
+<code sh>
+mytop -S /var/run/mysqld/mysqld.sock -u debian-sys-maint -p $(cat /etc/mysql/debian.cnf|grep password|sed 's/password = //'|head -n 1) -s 1
+</code>