Cacti templates no longer working with Percona's MySQL 5.1 + XtraDB

What steps will reproduce the problem?
1. Setup Cacti templates as normal
2. Upgrade to MySQL 5.1 / XtraDB
3. Note Graphs no longer graphing properly

What is the expected output? What do you see instead?

When running the script manually, I get this:

php ss_get_mysql_stats.php --host q2 --user cactimon --pass #############
--items ah,ai,aj,ak

...
Notice: Undefined offset:  4 in
/usr/share/cacti/site/scripts/ss_get_mysql_stats.php on line 394
Error executing 'SELECT CONCAT('', ((51FC << 32) + 0)) AS
innodb_transactions, CONCAT('', (((51FC << 32) + 0) - ((51D6 << 32) +
undo))) AS unpurged_txns, CONCAT('', ((549342 << 32) + 0)) AS
log_bytes_written, CONCAT('', ((549342 << 32) + 0)) AS log_bytes_flushed,
CONCAT('', (((549342 << 32) + 0) - ((549342 << 32) + 0))) AS unflushed_log,
CONCAT('', 354+101+0) AS spin_waits, CONCAT('', 7044) AS spin_rounds,
CONCAT('', 348+101+0) AS os_waits': You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the
right syntax to use near 'undo))) AS unpurged_txns, CONCAT('', ((549342 <<
32) + 0)) AS log_bytes_written,' at line 1

What version of the product are you using? On what operating system?

Cacti Templates: Latest
Cacti: 0.8.7b
MySQL: 

mysql> SELECT version();
+----------------+
| version()      |
+----------------+
| 5.1.33-xtradb4 | 
+----------------+
1 row in set (0.00 sec)

Please provide any additional information below.

The templates worked previously on 5.0.51a. I upgraded to XtraDB and now
the graph-data does not show up. Since it was working before, and since php
ss_get_mysql_stats.php is b0rking, I'm thinking something is incompatible.

Line 394 in the script seems to be in relation to the TRANSACTIONS section
with InnoDB and I believe this section has been moved around a bit in the
"SHOW ENGINE INNODB STATUS" output in XtraDB.

Original issue reported on code.google.com by m00d...@gmail.com on 27 Apr 2009 at 6:45

google-code-export / mysql-cacti-templates

Cacti templates no longer working with Percona's MySQL 5.1 + XtraDB #55