MySQL Forums
Forum List  »  NDB clusters

statistics for mysql cluster
Posted by: Alexander Kushkuley
Date: June 23, 2006 01:40PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
statistics for mysql cluster
1780
June 23, 2006 01:40PM


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.