On Mon, Aug 20, 2001 at 02:04:09PM -0500, Mike Wexler wrote:
>
> Is there any reason why I shouldn't create temporary tables on a
> slave server? The tables only last until the client closes its
> connection, they aren't visible to other clients.
>
> I don't do any
> INSERT INTO <permanentTable> SELECT ... FROM <temporaryTable>
As long as the slave isn't also a master for another slave, things
should work as expected. Even if it is, you probably won't run into
problems, but I haven't tried...
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max: up 3 days, processed 44,177,066 queries (145/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
