Solved

using temp tables in NDBCLUSTER engine

Posted on 2008-10-29
2
299 Views
Last Modified: 2008-11-19
Hi,
 i read that NDBCLUSTOR engine doesn't support temp tables.
but we have temp table in our procedures.
is there any workaround to do this.
Regards
vijji
0
Comment
Question by:vijji_lakshmi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 26

Accepted Solution

by:
Umesh earned 500 total points
ID: 22829632
This may help you...

http://www.nabble.com/TEMPORARY-tables-with-NDB-td17736410.html

Take a look at the point (b)...

(b) TEMPORARY tables using a different storage engine which is entirely
possible - a MySQL server does not *have* to use the NDBCLUSTER engine
just because it's part of a MySQL Cluster. However, tables that don't
use NDBCLUSTER are local to that MySQL server/SQL node.
0
 
LVL 26

Expert Comment

by:Umesh
ID: 22937444
Any update on this?
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question