Re: Memory Allocation error

[Rick James]

At a low level, there are two ways for a client to receive a big resultset from the server -- all at once, or piecemeal. If Cognos is trying to receive all 1.2GB at once, perhaps it is not prepared to handle it. (Ask them.)

SHOW VARIABLES LIKE 'tmpdir';
SHOW VARIABLES LIKE '%buffer%';
SHOW VARIABLES LIKE 'version%';

With 16GB of RAM, there should not be a memory issue, but...

Is the OS 64-bit?
Is Cognos 64-bit?
While we are at it, is MySQL 64-bit?
I ask these, because the OS could be limiting each process to, say, 1GB of RAM. (This is likely with everything being 32-bit.)