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
