Announcement Module
No announcement yet.

Temporary Tables on virtual memory

Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • Temporary Tables on virtual memory

    Hello everyone,

    I'm running a configuration with one master and a replication slave. Both on Linux.

    For better performance, I decided some days ago to put the tmpdir to /dev/shm like a recommandation I read. And the performance increases a lot. Because I've a lot of created_tmp_disk_tables created (about 751K on a total of 3743K of created_tmp_tables. Because on my SELECTs, I must get text fields).

    But today, I read this : where it was specified to don't put the tmpdir to virtual memory on a slave.

    So my question is : In which case, it is dangerous to put the tmdir in virtual memory for a slave ?
    Do you have a workaround to continue to put only created_tmp_disk_tables on virtual memory and not the temporary tables necessary for the replication ?

    Thanks for yours answers.

    Best regards.