Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Activity for Jirka Hanika
Type | On... | Excerpt | Status | Date |
---|---|---|---|---|
Edit | Post #279427 | Initial revision | — | almost 4 years ago |
Answer | — |
A: How much memory is allocated for a MySQL VARCHAR variable in a stored procedure? The example variable will use 101 bytes, independently of whether any data was already assigned to it. This holds regardless of whether you are using InnoDB or MyISAM which otherwise differ in how they handle string storage. An alternative fix to shortening the variables would be to change them... (more) |
— | almost 4 years ago |
Comment | Post #278978 |
It's really puzzling that a low, fixed number of variables could ever exhaust your system memory. Was the stored procedure perhaps recursive? If you changed max_sp_recursion_depth, you might need to change thread_stack as well. (more) |
— | almost 4 years ago |