Re: How can I observe mysqld?

2006-03-08 Thread Karl Schock
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 pe

RE: How can I observe mysqld?

2006-03-08 Thread Karl Schock
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 da

Re: How can I observe mysqld?

2006-03-07 Thread Karl Schock
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 low

Re: How can I observe mysqld?

2006-03-07 Thread Karl Schock
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"

Re: How can I observe mysqld?

2006-03-07 Thread Karl Schock
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: http://l

Re: How can I observe mysqld?

2006-03-07 Thread Karl Schock
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? C

How can I observe mysqld?

2006-03-07 Thread Karl Schock
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 /var/lib/mysql/mysql.sock is there. "ps aux | grep mysqld" shows me