The mysql-cluster tag has no wiki summary.
0
votes
1answer
75 views
How to removing or reduce the size of redo logs in MySQL cluster
Can anybody tell me that how can we reduce the redo log file size or can we remove the redo log file size in MySQL Cluster and also what will be the impact of it on performance of cluster.Also can we ...
1
vote
0answers
26 views
Error in alter table reorganize partition for MySQL Cluster
My cluster contains 48 million rows and cluster contains 4 storage nodes . After that I add online storage node and executed alter table 'customer_tbl' reorganize partition.
Some parameters of ...
1
vote
0answers
40 views
memcached+mysql cluster maximum memory
I'm deploying a system with memcached and mysql cluster.
The command line is:
memcached -E lib/ndb_engine.so -e "connectstring=maddy:1186;role=dev"
I can't specify the -m argument since I used -E ...
1
vote
0answers
153 views
MySQL cluster stuck in start phase 4, how to proceed?
Over the weekend our cluster we set up for evaluation had one of its data nodes lose network connectivity briefly. This was while another data node was in the middle of a restart (which had been going ...
1
vote
0answers
158 views
Does MariaDB-Galera Cluster support LAST_INSERT_ID and mysql_info?
As far as I understand, Galera does not support table locking, but what information can be retrieved about the last query?
LOCK/UNLOCK TABLES cannot be supported in master-master replication. Lock ...
1
vote
0answers
343 views
MySQL Cluster LOAD DATA too slow
mysql-5.5.22 ndb-7.2.6 cluster 64bit running on Centos 6 with each node installed on the same Citrix Xen Server communicating via a virtual private network. Each node has 4GB of RAM, 4 vCPUs and 10GB ...
0
votes
0answers
22 views
All four data nodes in MySQL Cluster in same node group
I am testing MySQL Cluster 7.2. I have two servers, mysql1 and mysql2. I want the management server and two data nodes to run on mysql1 and two other data nodes to run on mysql2. My config.ini file ...
0
votes
0answers
31 views
ERROR while doing coalesce partition Mysql Cluster
My table contains 3299000 rows. My Mysql Cluster contains 2 storage nodes with NoOfReplicas=2. By default it contains 2 partitions and after that i added 3 partitions more one by one using command ...
0
votes
0answers
26 views
After optimize table statement my data usage increased Mysql Cluster
I deleted 500000 rows in my mysql cluster table having 12468000 rows and then i tried to OPTIMIZE TABLE so that all the freed up data memory can be used by another table also, but after optimizing ...
0
votes
0answers
19 views
Re-use disk data extents after delete Mysql Cluster
In my mysql cluster i have 1 million rows and my disk data tables are using all the disk usage available to them ;i.e; free extents are 0 . Now i deleted 50K rows from ap_perf_tbl but still it show ...
0
votes
0answers
22 views
Why data usage increases when deleting rows Mysql Cluster?
My mysql cluster data nodes data usage increased to 95%. Then i tried to delete 500000 rows and my data usage of nodes started increasing initially and reached to 99% and above and TABLE FULL error is ...
0
votes
0answers
31 views
MYSQL Clutser (NDB) varchar storage requirement if indexed(Unique Index)
In MySQL Cluster (ndb engine) disk based table, if a column is varchar(255) with UNIQUE INDEX defined then,
For Latin(default) char set, does varchar column takes fixed size?
For UTF-8 (3 char ...
