statistics for mysql cluster
We are evaluating mysql cluster technology. I have tried mysql 5.1-beta version which seems to work fine at least for in-memory tables. However, I can't query statistics for clustered tables (storage engine ndbcluster).
select count(*) from test2.record
-> ;
+----------+
| count(*) |
+----------+
| 2000000 |
+----------+
mysql> select TABLE_SCHEMA, table_name, index_name, cardinality from statistics where table_name='record';
+--------------+------------+------------+-------------+
| TABLE_SCHEMA | table_name | index_name | cardinality |
+--------------+------------+------------+-------------+
| test2 | record | PRIMARY | 100 |
+--------------+------------+------------+-------------+
And so on, all the statistics fields for ndbcluster tables
are either null or have the value 100 (as above).
The version of mysql is as follows:
mysqld --version
mysqld Ver 5.1.11-beta for unknown-linux-gnu on x86_64 (MySQL Community Server (GPL))
./bin/mysql --version
./bin/mysql Ver 14.12 Distrib 5.1.11-beta, for unknown-linux-gnu (x86_64) using readline 5.0
I have tried
all clusterlog statistics=15
in ndb management client, but nothing "interesting" appears in log files either.
Am I missing something? Are there any parameters I need to set up to view the statistics properly?
Are there any tools available for monitoring cluster statistics, (actual table memory size, various log(s) size(s), etc. ). Is there any documentation available on how to obtain this information through api?
Thanks,
Alex
Subject
Views
Written By
Posted
statistics for mysql cluster
1780
June 23, 2006 01:40PM
958
June 25, 2006 06:41PM
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.