Re: RW/splitting temporary table
Temporary table aren't managed by mysql-proxy because there is no tokens for it.
So what i did , i create a table with the CONNECTION_ID() in its name, i compare with SHOW PROCESSLIST and SHOW TABLES, if there is a match with the a connection id, and i drop it. This one is for the application-side.
the Second way, it's to rewriting the CREATE TEMPORARY TABLE by CREATE TABLE... CONNECTION_ID()...
this one is for lua-side.
Which i really don't understand it's technically, the temporary table are replicated into the slaves, but when i want to do a select statement for it, i've got nothing and i've all the privileges. If you have any ideas ?
Subject
Views
Written By
Posted
3252
January 22, 2010 07:08AM
Re: RW/splitting temporary table
1978
February 02, 2010 03:46AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.