Re: Bad performance

> I encountered a critical issue regarding MySQL cluster performance,
>
> My scenario is that I have 2000+ simultaneous updates,
> insertion and queries against MySQL database for every round
> operation,

Can you give a more detailed description of what you are doing?

E.g.

• table schemas
• typical queries
• transaction sizes (or use of AUTOCOMMIT?)
• number of client connections performing operations in parallel

> Without Cluster (1 MySQL Server), it took 15 mins to complete one
> round operation

• which table type being used here

> With cluster (2 MySQL servers, two data nodes and 1 management
> server), it took much longer time (say, hours) to complete one round
> operation.
> So I am wondering if it is an known issue or there are any tuning tricks
> to improve it, any help is much appreciated

-- 
Hartmut Holzgraefe, Senior Support Engineer                            .
MySQL AB, www.mysql.com

Discover new MySQL Monitoring & Advisory features at:
http://www.mysql.com/products/enterprise/whats_new.html

Hauptsitz: MySQL GmbH, Radlkoferstr. 2, D-81373 München
Geschäftsführer: Kaj Arnö - HRB München 162140



-- 
MySQL Cluster Mailing List
For list archives: 
http://lists.mysql.com/cluster
To unsubscribe:    
http://lists.mysql.com/cluster?unsub=lists@pantek.com