Re: Defragmentation of MySQL tables, how many times have I to do it?

Hi Reindl, I would like to implement your strategy of optimizing tables. Can you please share how are running these scripts? Where does the mysql-wrapper-class exist? And what parameters need to be passed? Thanks Bheem Aitha MySQL and Oracle DBA On Mar 28, 2013 4:43 AM, "Reindl Harald" wrote: >

MySQL Cluster alerts

Hi list I am frequently seeing the following alerts in our production MySQL Cluster environment. Does anyone have any metrics, guidelines and scripts to monitor and fix these alerts? Any help is appreciated. Temporary Tables To Disk Ratio Excessive Excessive Disk Temporary Table Usage Detected

MySQL Enterprise Monitor Testing

Hi list, I just installed MySQL Enterprise Monitor (MEM) to monitor our MySQL NDB cluster. Per our company policies, I need to test all MEM advisors for all metrics. Did anyone do this before? Any there any tools to test the advisors in MEM? I appreciate if anyone can share their experiences with

ndb_restore is not restoring users and grants

Hi, I was able to backup my cluster using ndb_mgm and also restore using ndb_restore. However, when everything looks fine after restore, I see that users and grants are not restored. So, does ndb_restore restore all databases including information_schema and mysql databases, plus users and grants?

How to start a cluster using MCM after crash and prepare for restore using ndb_restore?

Hi, We have MySQL cluster 7.2.7 with the following setup. 1 ndb_mgmd, 1 mysqld on one host 2 ndbmtd on another host We use MySQL cluster Manager known as MCM (v: 1.1.6) to manage the cluster. We don't use ndb_mgm client at all. I wanted to simulate and test the restore using ndb_restore. In or

Re: Backup Error while backing up MySQL Cluster

Just for others to know, it was the memory problem. I re-set the memory parameters for ndbmtd (two nodes) to minimum. Then I could run the backup successfully. Thanks BA On Wed, Oct 24, 2012 at 11:57 AM, Bheemsen Aitha wrote: > Hi, > > After following the steps at the following w

Backup Error while backing up MySQL Cluster

Hi, After following the steps at the following website, I tried to do an online backup of the cluster. http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-backup-using-management-client.html It is a plain vanilla command which is below. The cluster is almost an empty database, but backup is cra

Install problem on MySQL Enterprise Monitor on linux

I tried to install the mysql monitor, but stumbled on some problems. Here is what I did. 1. Installed a second instance of mysql server on one of our servers into a different folder rather than into the regular folder because there is already another instance of mysql server running on the same