1

How to monitor MySQL Cluster undo log size & status?

view story
linux-howto

http://serverfault.com – We are investigating using MySQL Cluster and, while importing data, we're bumping up against this error from time to time: ERROR 1297 (HY000) at line 1: Got temporary error 1501 'Out of undo space' from NDBCLUSTER We're not in production yet but obviously we'll need a way to monitor this undo space when we are in production. Here's the query I'm trying to use, but as you can see, the values it is returning are bogus: mysql> SELECT node_id, log_id, used, total FROM ndbinfo.logspaces WHERE log_type='DD-UNDO'; +---------+--------+----------------------+-----------+ | node_id | log_id | use (HowTos)