From: Peter Holm
Date: May 21 2000 9:14pm
Subject: memory out while data-bulk
List-Archive: http://lists.mysql.com/win32/2622
Message-Id: <43kgis8rmptqf4s3scj75sb8gvmib5vf24@4ax.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable

Hi,

i have some memory problems here while some data-bulk activity.

I read open a file, which gives me some id. With this id i get some data
from a table. the data is then written to another file.

After some while of doing this, the whole thing stops, because=20
"MySQL client run out of memory"

What am I doing wrong?

an extended-status after such an event gives me something like this
(but it not really gives me a hint)

+--------------------------+-------+
| Variable_name            | Value |
+--------------------------+-------+
| Aborted_clients          | 0     |
| Aborted_connects         | 0     |
| Created_tmp_tables       | 0     |
| Delayed_insert_threads   | 0     |
| Delayed_writes           | 0     |
| Delayed_errors           | 0     |
| Flush_commands           | 1     |
| Handler_delete           | 0     |
| Handler_read_first       | 1     |
| Handler_read_key         | 24064 |
| Handler_read_next        | 0     |
| Handler_read_rnd         | 8     |
| Handler_update           | 0     |
| Handler_write            | 1     |
| Key_blocks_used          | 240   |
| Key_read_requests        | 47911 |
| Key_reads                | 227   |
| Key_write_requests       | 13    |
| Key_writes               | 13    |
| Max_used_connections     | 1     |
| Not_flushed_key_blocks   | 0     |
| Not_flushed_delayed_rows | 0     |
| Open_tables              | 4     |
| Open_files               | 8     |
| Open_streams             | 2     |
| Opened_tables            | 25    |
| Questions                | 24141 |
| Running_threads          | 1     |
| Slow_queries             | 0     |
| Uptime                   | 3178  |
+--------------------------+-------+


Thanks for your attention,
Peter