Home » Open Source » MySQL » Slow Query (Mysql Cluster GPL)
Slow Query [message #602724] Sat, 07 December 2013 21:10 Go to next message
mzainal
Messages: 54
Registered: March 2010
Location: Malaysia
Member
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.
Re: Slow Query [message #602725 is a reply to message #602724] Sat, 07 December 2013 21:12 Go to previous message
mzainal
Messages: 54
Registered: March 2010
Location: Malaysia
Member
I'm using mysql proxy to route both node from application. Application will point to ip mysql proxy. Mysql proxy is in NDB management (same server).
Previous Topic: Any MS Access to MySQL database conversion tool
Next Topic: Unable to start data nodes in MySQL CGE 7.3.2
Goto Forum:
  


Current Time: Thu Mar 28 03:38:41 CDT 2024