Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Parser finds only every other section of INNODB STATUS result. #80

Open
AndyLeeRobinson opened this issue Nov 24, 2015 · 1 comment
Open

Comments

@AndyLeeRobinson
Copy link

I noticed this error while installing the plugin:
Output from SHOW ENGINE INNODB STATUS was truncated.
This happens if the output of SEIS exceeds 64KB.

I checked the size of the field returned and it was only about 8KB.

So I dug into the plugin a bit more, and discovered that the parsing algorithm was skipping sections, and I could not work out why, despite trying to follow every match.

In the end, I rewrote it to split the innodb result into an associative array of sections, and then iterate over those, so that every section would be counted.

Now no need for the dummy section, because if 'END OF INNODB MONITOR OUTPUT' isn't defined, then the status was truncated.

The subs, skip_heading and match_new_section are now obsolete.

Updated plugin attached, please review!

@AndyLeeRobinson AndyLeeRobinson changed the title Parse Parser finds only every other section of INNODB STATUS result. Nov 25, 2015
@AndyLeeRobinson
Copy link
Author

mysql_.txt
Tested using
mariadb-server-10.0.21-1.fc22.x86_64
munin-node-2.0.25-2.fc22.noarch

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant