469,626 Members | 1,065 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,626 developers. It's quick & easy.

How to fix Error 12?

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

Jul 20 '05 #1
0 1337

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Gregory | last post: by
7 posts views Thread by p | last post: by
3 posts views Thread by Manuel | last post: by
1 post views Thread by developer | last post: by
reply views Thread by mchuc7719 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.