Jesse Norell wrote:
But I think than 'copying to tmp table' requests make velocity too
badly.
This was discussed on the list not long ago .. iirc, the proposed
solution was to have a config item for where your tmp directory is
located; those who don't want it on a physical disk can simply mount a
ram-based device somewhere and point it at that. Eg. tmpfs in linux.
He seems to be saying this is inside mysql. As i recall mysql uses temp
tables when it needs to sort things or runs out of ram.
The OP might want to take a look at how he is using the ram on the
machine to see if that fixes it.
How to disable too same requests?
I'm not sure what you mean here ... how to cache the results of a
query?
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
