Re: aborted_clients // _connections

[trade.de_(at)_t-online.de (Uwe F.Herle)]

hallo,

wie kann ich diesen newsletter abbestellen?

danke
----- Original Message -----
From: "Thomas Borsutzky" <Thomas.Borsutzky_(at)_aman.de>
To: <mysql-de_(at)_lists.4t2.com>
Sent: Monday, March 05, 2001 2:04 PM
Subject: aborted_clients // _connections


> hallo
>
> ich bin neu hier :-)
> ich arbeite bei einer mediaagentur, wir programmieren viel in php3/4 in
> verbundung mit mysql.
>
> wir arbeiten in einer LAMP(3) umgebung und haben ein problem:
>
> und zwar schmiert mir meine mysql 3.23.33 regelmässig ab, wenn jemand auf
> bestimmte scripte in php zugreift. ich weiss nur leider nicht welche das
> genau sind.
> der fehler stellt sich so dar, dass immer mehr verbindungen auf sind (max
> 100) und die aborted clients und connections anschwellen... hier ein
auszug
> aus show status im phpmyadmin:
>
> Variable_name Value
>  Aborted_clients   150  Edit Delete
>  Aborted_connects   274  Edit Delete
>  Bytes_received   628272  Edit Delete
>  Bytes_sent   94812975  Edit Delete
>  Connections   710  Edit Delete
>  Created_tmp_disk_tables   0  Edit Delete
>  Created_tmp_tables   72  Edit Delete
>  Created_tmp_files   0  Edit Delete
>  Delayed_insert_threads   0  Edit Delete
>  Delayed_writes   0  Edit Delete
>  Delayed_errors   0  Edit Delete
>  Flush_commands   1  Edit Delete
>  Handler_delete   12  Edit Delete
>  Handler_read_first   111  Edit Delete
>  Handler_read_key   2095  Edit Delete
>  Handler_read_next   2581  Edit Delete
>  Handler_read_prev   0  Edit Delete
>  Handler_read_rnd   13702  Edit Delete
>  Handler_read_rnd_next   6124255  Edit Delete
>  Handler_update   82  Edit Delete
>  Handler_write   15736  Edit Delete
>  Key_blocks_used   71  Edit Delete
>  Key_read_requests   9515  Edit Delete
>  Key_reads   70  Edit Delete
>  Key_write_requests   5  Edit Delete
>  Key_writes   5  Edit Delete
>  Max_used_connections   100  Edit Delete
>  Not_flushed_key_blocks   0  Edit Delete
>  Not_flushed_delayed_rows   0  Edit Delete
>  Open_tables   46  Edit Delete
>  Open_files   93  Edit Delete
>  Open_streams   0  Edit Delete
>  Opened_tables   189  Edit Delete
>  Questions   13612  Edit Delete
>  Select_full_join   21  Edit Delete
>  Select_full_range_join   0  Edit Delete
>  Select_range   659  Edit Delete
>  Select_range_check   0  Edit Delete
>  Select_scan   6057  Edit Delete
>  Slave_running   OFF  Edit Delete
>  Slave_open_temp_tables   0  Edit Delete
>  Slow_launch_threads   0  Edit Delete
>  Slow_queries   0  Edit Delete
>  Sort_merge_passes   0  Edit Delete
>  Sort_range   18  Edit Delete
>  Sort_rows   13702  Edit Delete
>  Sort_scan   1101  Edit Delete
>  Table_locks_immediate   9509  Edit Delete
>  Table_locks_waited   0  Edit Delete
>  Threads_cached   0  Edit Delete
>  Threads_created   709  Edit Delete
>  Threads_connected   47  Edit Delete
>  Threads_running   1  Edit Delete
>  Uptime   3832  Edit Delete
>
> mich würde nun interessieren, wie ich rausbekommen kann, welches script
die
> fehler macht! oder wie ich den fehler auf db seite beheben kann.
irgendwann
> kommt der "too many connections" hinweis und ich mache einen mysql stop /
> start auf dem system
>
> könnt ihr mir weiterhelfen?
>
> cu
>
> thomas borsutzky :-)
>
>
> ---
> *** Weitere Infos zur Mailingliste und MySQL unter
http://www.4t2.com/mysql
>
>

---
*** Weitere Infos zur Mailingliste und MySQL unter http://www.4t2.com/mysql