Hi,
From my expericnce, MySQL Cluster performance depends on;
1. the number of (concurrent) threads from clients
2. SQL query
3. the number of SQL Node/Data Node/Replicas
4. interconnect (Ethernet or SCI)
5. 32bit/64bit (affecting on SQL Node)
From one of my benchmark results, I can say SQL Node could handle
concurrent transactions about 50, so it's good to configure
max_connections=50 for better performance, I believe.
FYI.
Thanks,
Kenji
On 11/11/05, pekka@stripped <pekka@stripped> wrote:
> > Does that mean NDB performance is always gonna be 100-200% worse than InnoDB? I
> realize it's networked, but it's kind of a "gee whiz" cool thing unless the performance is
> good on industry-standard hardware.
>
> Depends on application. Parallel applications get better throughput.
>
> Also, as an extreme NDB-biased example, imagine running a single
> query with complex predicate. If the predicate is pushed to 8 db
> nodes, it could run 8 times faster than on single cpu.
>
> --
> Pekka Nousiainen, Software Engineer
> MySQL AB, www.mysql.com
> pekka@stripped +46 (0) 73 068 4978
>
> --
> MySQL Cluster Mailing List
> For list archives: http://lists.mysql.com/cluster
> To unsubscribe: http://lists.mysql.com/cluster?unsub=1
>
>
--
kenji.hirohama@stripped
Kenji Hirohama
