Am Dienstag, den 07.03.2006, 17:00 -0600 schrieb Ryan Stille:
What else can I do to observe myslqd?
mytop may be of some use: http://jeremy.zawodny.com/mysql/mytop/
Hello Ryan,
mytop is indeed very nice. :-) Thank you for that.
One question: Is it possible to oberserve more than one
mytop measures the overall performance of the server... it's not daatabase
bound !
For itself it uses the test database... but that has no meaning... it's
not measuring that database performance...
You can see queries that take to long aprearing in the list...
It uses
SHOW STATUS - to get
Am Mittwoch, den 08.03.2006, 12:22 +0200 schrieb Gabriel PREDA:
Hello Gabriel,
mytop measures the overall performance of the server... it's not daatabase
bound !
you are right.
For itself it uses the test database... but that has no meaning...
maybe it is meant to confuse clueless people
although mytop would give you overall performance statistics , you can
monitor the processes/queries/threads for a specific database using the
switch d ( if thats what you are looking for)
JFYI: type in ? in the mytop window and it would give you a full list of
options to choose from...
Kishore
May be the mysqld server has exceeded max-connections, and is therefore not
able to serve any clients ( but you should have a log for that), is this
your server, and does this happen at peak times, and what happens after the
circle, mysqld just dies
Kishore Jalleda
On 3/7/06, Karl Schock
On 3/7/06, Karl Schock [EMAIL PROTECTED] wrote:
Hello,
my problem: I run a phpbb-Forum with a mysql database on a linux
server.
Every 5 - 7 days the mysql database runs in a vicious circle:
mysqladmin --user=x --password=y ping says that the connect failed.
The socket
Am Dienstag, den 07.03.2006, 11:30 -0500 schrieb Kishore Jalleda:
Hello Kishore,
May be the mysqld server has exceeded max-connections, and is therefore not
able to serve any clients
how can I see the value of max-connections and how can I see how many
connections are active at the moment?
The web applications below will allow you to connect to and
monitor and administer MySQL databases.
http://www.phpmyadmin.net/home_page/index.php
Check out the DEMO link in the top menu bar, RHS.
Or there is the MySQL Administrator at:
Hello,
how can I see the value of max-connections
I found it in phpmyadmin. It is 100.
Can I set max-connections? If so: where can I set it? In /etc/my.cnf?
I found the answer in the mysql-documentation. RTFM I know. ;-)
Bye
Karl
--
MySQL General Mailing List
For list archives:
Hello Keith,
The web applications below will allow you to connect to and
monitor and administer MySQL databases.
http://www.phpmyadmin.net/home_page/index.php
it helps a lot when MySQL is running. Thank you.
But when mysqladmin --user=x --password=y ping says that
the connect failed even
Hello Daniel,
To find the reason causing the problem I started mysqld with the
--log-option and the --log-error-option ...
Try --log-warnings, so you know about ...
I will have a look at the documentation and - if possible - I will
even try --log-everything. ;-)
Also try lowering the
What else can I do to observe myslqd?
mytop may be of some use: http://jeremy.zawodny.com/mysql/mytop/
-Ryan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[EMAIL PROTECTED]
Subject: Re: How can I observe mysqld?
Hello Keith,
The web applications below will allow you to connect to and
monitor and administer MySQL databases.
http://www.phpmyadmin.net/home_page/index.php
it helps a lot when MySQL is running. Thank you.
But when
13 matches
Mail list logo