On Mon, 22 May 2000, Peter Holm wrote:
>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
>"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
HI!
What program gives you that error message ??
mysql.exe
If that is a case use it with -q option.
Regards,
Sinisa
+----------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------------+
