Solved

using temp tables in NDBCLUSTER engine

Posted on 2008-10-29
2
284 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
mysql left join sentence 7 40
Problem with Simple PHP/mySQL Query 3 76
mysql database, schema and table creation 13 59
Optimize the query 5 43
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

820 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