Home » Open Source » MySQL » MySQL Cluster 5.4 (GPL Edition, MySQL Proxy 7.3)
MySQL Cluster 5.4 [message #606644] Mon, 27 January 2014 19:44 Go to next message
mzainal
Messages: 48
Registered: March 2010
Location: Malaysia
Member
Hi,

I'm using mysql cluster gpl edition with mysql proxy. The idea is to improve query and performance. Below is my config.ini
[ndb_mgmd default]

[ndb_mgmd]
NodeId=1
HostName=vsvr-console
DataDir=/var/lib/mysql-cluster


[ndbd default]
NoOfReplicas = 2
DataMemory = 4G
IndexMemory = 6G
#LockPagesInMainMemory = 1
MaxNoOfConcurrentOperations = 200000
MaxNoOfTables = 20000
#MaxNoOfOrderedIndexes = 3221225472
MaxNoOfAttributes = 25000
MaxNoOfOrderedIndexes = 25000
MaxNoOfExecutionThreads=8

[ndbd]
NodeId=2
HostName=172.16.0.90
DataDir=/var/lib/mysql-cluster/data1

[ndbd]
NodeId=3
HostName=172.16.0.91
DataDir=/var/lib/mysql-cluster/data1

[mysqld]
NodeId=10
HostName=172.16.1.90

[mysqld]
NodeId=20
HostName=172.16.1.91


Query from application very slow. What should i do? Please advice.

Thanks.
Re: MySQL Cluster 5.4 [message #606645 is a reply to message #606644] Mon, 27 January 2014 19:57 Go to previous messageGo to next message
BlackSwan
Messages: 22512
Registered: January 2009
Senior Member
http://www.lmgtfy.com/?q=mysql+explain+plan
Re: MySQL Cluster 5.4 [message #611782 is a reply to message #606645] Tue, 08 April 2014 20:59 Go to previous message
mzainal
Messages: 48
Registered: March 2010
Location: Malaysia
Member
On production, it's use Innodb. The idea using cluster is HA. The table structure is same as production but production little bit fast than using cluster. I still don't know what it's wrong. If you said table structure, why production fast than mysql cluster?
Previous Topic: Migrate data from Oracle to Mysql
Next Topic: access and mysql: cascading insert into query problem
Goto Forum:
  


Current Time: Mon Jul 28 07:22:33 CDT 2014

Total time taken to generate the page: 0.04617 seconds