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
          74 kB
        2. Capture.PNG
          Capture.PNG
          37 kB

        Activity

          [OBS-1360] mysql 5.6 innodb io
          landy Mike Stupalov added a comment -

          Fixed in r12976.

          landy Mike Stupalov added a comment - Fixed in r12976.
          veldenb Bernard van der Velden added a comment -

          Had the same problem on 'mysql Ver 15.1 Distrib 10.0.32-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2'.
          It seems that the status-var 'have_innodb' has disappeared.

          Fixed it myself by altering the agent-script:

          --- observium_agent/lib/local/mysql
          		 
          +++ observium_agent/lib/local/mysql
          		 
          @@ -496,8 +496,7 @@ function ss_get_mysql_stats( $options ) {
          		 
           # Get SHOW INNODB STATUS and extract the desired metrics from it, then add
          		 
           # those to the array too.
          		 
           if ($chk_options['innodb']
          		 
          - && array_key_exists('have_innodb', $status)
          		 
          - && $status['have_innodb'] == 'YES'
          		 
          + && array_key_exists('Innodb_data_read', $status)
          		 
           ) {
          		 
           $result = run_query("SHOW /*!50000 ENGINE*/ INNODB STATUS", $conn);
          		 
           $istatus_text = $result[0]['Status'];

          veldenb Bernard van der Velden added a comment - Had the same problem on 'mysql Ver 15.1 Distrib 10.0.32-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2'. It seems that the status-var 'have_innodb' has disappeared. Fixed it myself by altering the agent-script: --- observium_agent/lib/local/mysql +++ observium_agent/lib/local/mysql @@ - 496 , 8 + 496 , 7 @@ function ss_get_mysql_stats( $options ) { # Get SHOW INNODB STATUS and extract the desired metrics from it, then add # those to the array too. if ($chk_options[ 'innodb' ] - && array_key_exists( 'have_innodb' , $status) - && $status[ 'have_innodb' ] == 'YES' + && array_key_exists( 'Innodb_data_read' , $status) ) { $result = run_query( "SHOW /*!50000 ENGINE*/ INNODB STATUS" , $conn); $istatus_text = $result[ 0 ][ 'Status' ];
          cameronbrister Cameron Brister added a comment -

          Hey guys - any update on this? I don't mind keeping the Digital Ocean droplet up and running if that will help... But if it's not needed I'd like to shut it down

          cameronbrister Cameron Brister added a comment - Hey guys - any update on this? I don't mind keeping the Digital Ocean droplet up and running if that will help... But if it's not needed I'd like to shut it down
          cameronbrister Cameron Brister added a comment -

          Done and done! You should have the details in your inbox!

          cameronbrister Cameron Brister added a comment - Done and done! You should have the details in your inbox!
          adama Adam Armstrong added a comment -

          put mysql 5.6 on it too!

          adama Adam Armstrong added a comment - put mysql 5.6 on it too!
          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!

          People

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

            Dates

              Created:
              Updated:
              Resolved: