Solved

using temp tables in NDBCLUSTER engine

Posted on 2008-10-29
2
262 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
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:ushastry
ID: 22937444
Any update on this?
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
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…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

911 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

20 Experts available now in Live!

Get 1:1 Help Now