Hello All,
Okay, I've had a horrible time trying to figure out this problem, maybe someone on the list can help...
The bookexchange is using mysql (version 4.0.21) on an HP-UNIX machine (the ebiz server).
I am getting the following error when I run a query on a table with 2,500 records in it...
Got error 12 from Table Handler
After looking up this error in the MySQL manual, http://dev.mysql.com/doc/mysql/en/Operating_System_error_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 the bookexchange as a ColdFusion web application which is database driven.
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
PS I've been told it might be a problem with the mysql configuration?
-- Check out our online forum! http://www.bethandnathan.com - Check out the BYU Book Exchange! http://bookexchange.byu.edu - Check out a National Book Exchange! http://www.booksoncampus.com
--------------------
BYU Unix Users Group http://uug.byu.edu/
The opinions expressed in this message are the responsibility of their
author. They are not endorsed by BYU, the BYU CS Department or BYU-UUG. ___________________________________________________________________
List Info: http://uug.byu.edu/cgi-bin/mailman/
