Solved

using temp tables in NDBCLUSTER engine

Posted on 2008-10-29
2
251 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
  • 2
2 Comments
 
LVL 26

Accepted Solution

by:
ushastry earned 500 total points
Comment Utility
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:ushastry
Comment Utility
Any update on this?
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Suggested Solutions

I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

772 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now