XMLWordPrintable

    Details

      Description

      Hi,

      in pmm-client-1.17 those two queries are issued:

       

      SELECT t.table_schema, t.table_name, column_name, `auto_increment`,SELECT t.table_schema, t.table_name, column_name, `auto_increment`,   pow(2, case data_type     when 'tinyint'   then 7     when 'smallint'  then 15     when 'mediumint' then 23     when 'int'       then 31     when 'bigint'    then 63     end+(column_type like '% unsigned'))-1 as max_int   FROM information_schema.tables t   JOIN information_schema.columns c     ON BINARY t.table_schema = c.table_schema AND BINARY t.table_name = c.table_name

       

      and

       

      SELECT     TABLE_SCHEMA,     TABLE_NAME,     TABLE_TYPE,     ifnull(ENGINE, 'NONE') as ENGINE,     ifnull(VERSION, '0') as VERSION,     ifnull(ROW_FORMAT, 'NONE') as ROW_FORMAT,     ifnull(TABLE_ROWS, '0') as TABLE_ROWS,     ifnull(DATA_LENGTH, '0') as DATA_LENGTH,     ifnull(INDEX_LENGTH, '0') as INDEX_LENGTH,     ifnull(DATA_FREE, '0') as DATA_FREE,     ifnull(CREATE_OPTIONS, 'NONE') as CREATE_OPTIONS   FROM information_schema.tables   WHERE TABLE_SCHEMA = 'lists'  

       

      Needless to say that doesn't play out well with databases that have hundreds of thousands of tables. I understand this is documented in the FAQ as : "Table statistics are disabled automatically if there are over 1 000 tables."; but somehow it doesn't seem to happen.

       

      Addendum. Those two particular scrapes seem to be collect.auto_increment.columns and collect.info_schema.tables:

      time="2019-02-22T10:32:21Z" level=error msg="Error scraping for collect.auto_increment.columns: context deadline exceeded" source="exporter.go:110"
      time="2019-02-22T10:32:21Z" level=error msg="Error scraping for collect.info_schema.tables: context deadline exceeded" source="exporter.go:110"

       

      It would be great to provide a way to disable them with pmm-client.

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              guillaume Guillaume Lefranc
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated: