Hello All,
I'm running mysql 4.0.21 on an HP-UNIX machine and I am getting the
following error:
Got error 12 from Table Handler
After looking up this error in the MySQL manual,
http://dev.mysql.com/doc/mysql/en/Op...ror_codes.html,
I've found that it is an "Out of Memory" error.
After looking into how to solve this problem, I came across this,
http://dev.mysql.com/doc/mysql/en/Out_of_memory.html . But, I'm not
sure how to invoke mysql with the --quick option.
You see, I've built a ColdFusion web application which is database
driven. My application is connecting to mysql which is running on a
separate machine.
The machine that has mysql running on it (HP-UNIX) has 8 processors.
When I type "top", I get the following for memory:
Memory: 932188K (881320K) real, 1735196K (1658188K) virtual, 5280980K
free Page# 1/11
I'm not sure of any other way on how to check the memory.
How do I fix this problem? There are only 2,500 records in my database
and it is causing this error when I try to run queries on all 2,500
records.
I've tried installing MySQL 4.1.8 on my windows XP Pro machine and I
copied all of the data over. I cannot duplicate the error using
windows XP pro.
So, is it a *nix thing or is my mysql server running on the HP-UNIX
machine too old?
Thanks in Advance!
--
Nathan