# Temporary tables on slave

**URL:** <https://forums.percona.com/t/temporary-tables-on-slave/1799>\
**Category:** Other MySQL® Questions\
**Created:** [April 19, 2012, 12:06pm UTC](https://forums.percona.com/t/temporary-tables-on-slave/1799 "2012-04-19T12:06:06Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![brpacecar](https://avatars.discourse-cdn.com/v4/letter/b/90ced4/32.png) [@brpacecar](https://forums.percona.com/u/brpacecar)\
**Post date:** [April 19, 2012, 12:06pm UTC](https://forums.percona.com/t/temporary-tables-on-slave/1799/1 "2012-04-19T12:06:06Z")

</div>

I am running mysql 5.1.41 on a master and slave server using MyISAM tables. Could creating temporary tables on the slave server itself result in any issues with the replication process from the master? I have done tests without having replication break but don’t want to miss any unforeseen possible issues with this.

---

<div class="post-metadata">

**Author:** ![sterin](https://avatars.discourse-cdn.com/v4/letter/s/3ab097/32.png) [@sterin](https://forums.percona.com/u/sterin)\
**Post date:** [April 20, 2012, 3:07am UTC](https://forums.percona.com/t/temporary-tables-on-slave/1799/2 "2012-04-20T03:07:48Z")

</div>

I would say no, not unless your temporary tables fill up the disk.

The only possible issue is that the slave might temporarily get a little behind due to the slow down due to high load of the temporary tables.

In fact a scenario where you have a master-\>slave setup and you choose to run heavy reporting queries against the slave is very often a good solution to avoid performance issues with the OLTP role the master has.

---

<div class="post-metadata">

**Author:** ![brpacecar](https://avatars.discourse-cdn.com/v4/letter/b/90ced4/32.png) [@brpacecar](https://forums.percona.com/u/brpacecar)\
**Post date:** [April 23, 2012, 1:18pm UTC](https://forums.percona.com/t/temporary-tables-on-slave/1799/3 "2012-04-23T13:18:33Z")

</div>

That is what I was hoping to hear. Thanks.