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)

xskl's picture
Submitted by xskl on 10/22/2012

Stories similar to How to monitor MySQL Cluster undo log size & status?

Hi, All.

I used to be able to undo actions all the way until a file was opened. Recently, I've been unable to do that, and I'm unable to undo actions beyond a certain point, which seems random, but might be related to the undo buffer size.

I was just wondering if anyone might have come across this problem, and if there might be a solution.

Thanks.

SG.

Undo and Redo 2 years 26 weeks ago

← Older revision Revision as of 11:05, November 17, 2010

Line 14: Line 14:

*<tt>u</tt>: undo last change (can be repeated to undo preceding commands)

*<tt>u</tt>: undo last change (can be repeated to undo preceding commands)

*<tt>U</tt>: return the line to its original state (undo all changes in current lin

Restoring an addon domain 33 weeks 5 days ago

Hello All,

I've made a stupid mistake and accidentally removed an addon domain in the cpanel. Now I'm desperately trying to restore it. I understand my databases and files are still intact... but the site is no longer viewable from the browser. When I try to recreate it, I get an error message saying the domain exists globally.

I've changed data directory in /etc/my.cnf.

[SOLVED] nano's undo/redo 2 years 37 weeks ago

I encountered a rather strange problem when using nano in general. When using the undo/redo shortcuts it just says "Nothing in undo buffer!" and nothing happens. Yeah, that's it. Anyone an idea how get undo/redo working in nano?

The problem is that my MySQL server keeps crashing every few seconds. Even if I repeat a simple SQL command several times, the MySQL server goes down:

mysql> show databases; ERROR 2006 (HY000): MySQL server has gone away No connection.

I need some help diagnosing a fault

I have a development server and a production server. They are (in the large part) identical in setup. Both are Ubuntu Server 10.04 LTS installs.

I turned on the MySQL slow query logs on both servers, and it works on the development server, but not the production server.

I have enabled SSL on MySQL 5.1.52 on CentOS 6.0 using the following guide: http://www.madirish.net/node/244

I have followed the instructions correctly but I am running into the following error when I try to connect from the client server:

[root@mta mysql]# mysql -u ssluser -h 10.178.234.142 -p ssldb Enter password: ERROR 2026 (HY000): SSL connection error

I have been doing some research and h

I've tried it all (removing all the packages associated with MySQL) but keep getting stuff like this:

Preconfiguring packages ... (Reading database ...