Hi,
I have 2 node mysql cluster gpl. When login via system, query is to slow. Took 8.xx second. But when using mysql community, it took only 2.xx second.
Here is config.ini.
[ndb_mgmd default]
DataDir=/var/lib/mysql-cluster
[ndb_mgmd]
HostName=vsvr-console
[ndbd default]
NoOfReplicas=2
DataMemory=1024M
IndexMemory=512M
DataDir=/var/lib/mysql-cluster
[ndbd]
nodeid=2
HostName=172.16.0.91
datadir=/var/lib/mysql
[ndbd]
nodeid=3
HostName=172.16.0.92
datadir=/var/lib/mysql
[mysqld]
[mysqld]
from my.cnf on both node.
[mysqld]
skip-name-resolve
max_allowed_packet = 128M
read_buffer_size = 128M
# Tuning #
max_connections = 30
max_connect_errors = 10
slow_query_log = 1
table_open_cache = 2048
long_query_time = 2
max_allowed_packet = 16M
binlog_cache_size = 1M
max_heap_table_size = 64M
read_buffer_size = 2M
read_rnd_buffer_size = 16M
sort_buffer_size = 8M
join_buffer_size = 8M
thread_cache_size = 16
thread_concurrency = 16
query_cache_size = 50M
query_cache_type = 1
query_cache_limit = 2M
ft_min_word_len = 4
thread_stack = 192K
ndbcluster
ndb-connectstring=172.16.0.90 # IP address of the management server
default-storage-engine=ndbcluster
[mysql_cluster]
ndb-connectstring=172.16.0.90 # IP address of the management server
Please advice.
Thanks.