Re: Information
MySQL Cluster (NDB) has a rather complex setup. It is normally configured with more than 2 machines. You have not provided any information that indicates that Cluster is desirable.
What issue are you having? Very few writes, only a few hundred reads/sec, lots of RAM -- there might not be any performance problems.
If there are performance problems, please provide
SHOW CREATE TABLE -- at least for the active tables
SHOW VARIABLES LIKE '%buffer%';
Some of the common SELECTs.
SHOW TABLE STATUS -- need to see the table sizes in GB.
> Web has 32GB of memory, 4 processors and disks SATA3.
> DB offers 192 GB of memory, 24 processors and 15K SAS drives.
Good split of resources.
InnoDB _might_ perform better.
Subject
Written By
Posted
Re: Information
June 14, 2013 11:48PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.