Uploaded image for project: 'Observium'
  1. Observium
  2. OBS-1360

mysql 5.6 innodb io

Details

    • Bug
    • Resolution: Fixed
    • Major
    • None
    • Professional Edition
    • Unix Agent
    • ubuntu 14 LTS

    Description

      In May, I switched my tables in my database from MyISAM to INNODB. At that time, it started showing INNODB IO. After may (around June 17th) I updated the MySQL version to 5.6. After that, the data is no longer retrieved. Is MySQL 5.6 not supported yet? I updated the local_agent and restarted xinetd but it appears that didn't help any.

      Any help would be appreciated.

      Attachments

        1. Capture.PNG
          Capture.PNG
          37 kB
        2. Capture.PNG
          Capture.PNG
          74 kB

        Activity

          [OBS-1360] mysql 5.6 innodb io
          adama Adam Armstrong added a comment -

          adama@observium.org!

          adama Adam Armstrong added a comment - adama@observium.org!
          cameronbrister Cameron Brister added a comment -

          Sure thing... Who can I sent root credentials to?

          cameronbrister Cameron Brister added a comment - Sure thing... Who can I sent root credentials to?
          adama Adam Armstrong added a comment -

          That might actually help

          adama Adam Armstrong added a comment - That might actually help
          cameronbrister Cameron Brister added a comment -

          I'll spin up a Digital Ocean VPS for you guys to have access to a MySQL 5.6 box if that's all it would take to fix this issue...

          cameronbrister Cameron Brister added a comment - I'll spin up a Digital Ocean VPS for you guys to have access to a MySQL 5.6 box if that's all it would take to fix this issue...
          joshuahaber Josh Haber added a comment -

          Do you know when you will get one? It's been a few months and I don't have any innodb data in my images. Just curious on the time frame I am looking at. Appreciate it!

          joshuahaber Josh Haber added a comment - Do you know when you will get one? It's been a few months and I don't have any innodb data in my images. Just curious on the time frame I am looking at. Appreciate it!
          adama Adam Armstrong added a comment -

          it seems it just needs an extra command and/or modified test.

          I don't have a mysql 5.6 system to test on at the moment, though.

          Adam.

          adama Adam Armstrong added a comment - it seems it just needs an extra command and/or modified test. I don't have a mysql 5.6 system to test on at the moment, though. Adam.
          joshuahaber Josh Haber added a comment -

          Just following up. Do you have a timeline on when you think this would be fixed?

          joshuahaber Josh Haber added a comment - Just following up. Do you have a timeline on when you think this would be fixed?
          joshuahaber Josh Haber added a comment -

          Any ETA on a fix?

          joshuahaber Josh Haber added a comment - Any ETA on a fix?
          landy Mike Stupalov added a comment -

          Ok, I think found where problem. Multiple variables changed in 5.6, agent script need to be rewritten

          landy Mike Stupalov added a comment - Ok, I think found where problem. Multiple variables changed in 5.6, agent script need to be rewritten
          joshuahaber Josh Haber added a comment -

          I got mysql 5.6 from a digital ocean mirror.

          I installed it like you would do with the majority of applications on Ubuntu server...

          apt-get install mysql-server-5.6 (follow the steps from there)

          Set root password - etc.

          Nothing special.....

          http://mon01.newrockit.com/device/device=3/tab=apps/app=mysql/app_section=innodb/

          That will show you all innodb graphs and if you wanted to see 1 particular graph, you would select it from the dropdown....

          http://mon01.newrockit.com/graphs/to=1436555236/from=1436468836/legend=no/type=application_mysql_innodb_io/id=2/

          there is nothing special about this build of mysql server.

          joshuahaber Josh Haber added a comment - I got mysql 5.6 from a digital ocean mirror. I installed it like you would do with the majority of applications on Ubuntu server... apt-get install mysql-server-5.6 (follow the steps from there) Set root password - etc. Nothing special..... http://mon01.newrockit.com/device/device=3/tab=apps/app=mysql/app_section=innodb/ That will show you all innodb graphs and if you wanted to see 1 particular graph, you would select it from the dropdown.... http://mon01.newrockit.com/graphs/to=1436555236/from=1436468836/legend=no/type=application_mysql_innodb_io/id=2/ there is nothing special about this build of mysql server.
          landy Mike Stupalov added a comment -

          Aggrrr... again, where you get mysql 5.6.. how you install it.. write all the steps please.

          Also.. what the graph you showed? (full url pls, I not found similar for mysql graphs).

          landy Mike Stupalov added a comment - Aggrrr... again, where you get mysql 5.6.. how you install it.. write all the steps please. Also.. what the graph you showed? (full url pls, I not found similar for mysql graphs).

          People

            landy Mike Stupalov
            joshuahaber Josh Haber
            Votes:
            3 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: