Re: Severe Memory Loss

[Steve Williams]

I am sorry about the last post... I had one of my sys admins read it over, and he placed other information in there that he should not have, and I missed it before I posted.

1. Firstly, We are running BOTH MYSQL VERSIONS: "4.1-14a" & "3.23.58-1a" and BOTH have the same problem. I originaly just posted the most current version we experienced the problem with. ALSO, we only use MYISAM tables. I do not know why my sys admin pasted the InnoDB settings in there.

2. Sorry for not being specific on the server. It is:

RedHat Linux 9.0
Distribution version "shrike"
Kernel 2.4-20-smp

3. We never use Temorary tables

4. The memory log is "Standard PS output" (command: ps -auxx)
We are testing this on a development box, and so there is only one command to monitor. So it is easy to spot what the memorey allocation is from one call to the other.

5. As for the commands you wanted:

show variables like 'key%'

+-----------------+---------+
| Variable_name | Value |
+-----------------+---------+
| key_buffer_size | 8388600 |
+-----------------+---------+

show status like 'key%'

+--------------------+-------+
| Variable_name | Value |
+--------------------+-------+
| Key_blocks_used | 156 |
| Key_read_requests | 190 |
| Key_reads | 52 |
| Key_write_requests | 219 |
| Key_writes | 177 |
+--------------------+-------+