Hi!
My Config: Running Redhat 9.0 Linux 2.4.20-8bigmem SMP 8GB mem 250GB raid array
My server: MySQL 4.1.2-alpha-standard
We are running into strange memory related errors with our system.
1) Warning: Asked for 262144 thread stack, but got 126876 On start up, we get the above warning.
How can I help MySQL get the stack space that it expects?
I changed thead_stack in my.cnf to 256k (from 192k) just to test the param out and it had no effect.
2) Out of Memory; check if mysqld or some other process uses all available memory -and- Out of memory (needed 56 bytes)
These errors are usually generated after MySQL dies.
These usually are produced after a large insert of a let's say 100,000 records from our c client app using:
INSERT DELAYED INTO kneejoint VALUES (),(),(), etc...
Our C client inserter application works well, so I am leaning toward our server/distro configuration as the problem.
I'm inserting the records using our client because we are receiving real-time stress/strain data from a remote input source.
By the way, max_allowed_packet is large enough, so that is not the problem.
3) Can't create new thread (errno 11)
I am assuming that the server can't start a new client thread because of memory issues.
I have monitored the system and it doesn't look like any other app is using much memory at all. In fact, it looks like most mem is cached when examined using top.
I haven't been able to interpret any of these error properly, so any help would be appreciated!
