# MySQL Table details error **URL:** \ **Category:** PMM 2.x\ **Created:** [October 19, 2022, 9:17am UTC](https://forums.percona.com/t/mysql-table-details-error/18083 "2022-10-19T09:17:29Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![PavelVD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavelvd/32/6640_2.png) [@PavelVD](https://forums.percona.com/u/PavelVD)\ **Post date:** [October 19, 2022, 9:17am UTC](https://forums.percona.com/t/mysql-table-details-error/18083/1 "2022-10-19T09:17:29Z")
Problem with dashboard Table Details ````auto Templating [service_name] Error updating options: cannot fetch data for "MinTimestamp=2022-10-18 21:16:45 +0000 UTC, MaxTimestamp=2022-10-19 09:16:45 +0000 UTC, TagFilters=[\n{Key=\"\", Value=\"mysql_info_schema_table_version\", IsNegative: false, IsRegexp: false}\n]": search error after reading 0 data blocks: error when searching for tagFilters=[{ __name__ ="mysql_info_schema_table_version"}] on the time range [2022-10-18 21:16:45 +0000 UTC - 2022-10-19 09:16:45 +0000 UTC]: error when searching tsids: the number of matching timeseries exceeds 10000; either narrow down the search or increase -search.max* command-line flag values at vmselect``` ```` ---
**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\ **Post date:** [October 24, 2022, 2:36pm UTC](https://forums.percona.com/t/mysql-table-details-error/18083/2 "2022-10-24T14:36:10Z")
Hi @PavelVD welcome back! Can you share some details about your deployment: - version of PMM Server and Client - Version and distribution of MySQL - Number of instances in this PMM Server Looks to me like you have a lot of MySQL instances being monitored. If you can fill in some details then we can come back with a tuning recommendation for VictoriaMetrics. Thanks! ---
**Author:** ![PavelVD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavelvd/32/6640_2.png) [@PavelVD](https://forums.percona.com/u/PavelVD)\ **Post date:** [October 24, 2022, 2:55pm UTC](https://forums.percona.com/t/mysql-table-details-error/18083/3 "2022-10-24T14:55:09Z")
PMM Server and clients 2.29.0 Mysql different versions Percona 5.7 MariaDB 10.3 MariaDB 10.6 75 monitoring services ---
**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\ **Post date:** [October 24, 2022, 3:02pm UTC](https://forums.percona.com/t/mysql-table-details-error/18083/4 "2022-10-24T15:02:41Z")
Thanks for the feedback. I’m escalating with the PMM Engineers to see if we can provide some guidance here. ---
**Author:** ![Anton\_Bystrov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/anton_bystrov/32/4880_2.png) [@Anton\_Bystrov](https://forums.percona.com/u/Anton_Bystrov)\ **Post date:** [October 28, 2022, 1:31pm UTC](https://forums.percona.com/t/mysql-table-details-error/18083/5 "2022-10-28T13:31:25Z")
> [@PavelVD](#): > > `Error updating options: cannot fetch data for “MinTimestamp=2022-10-18 21:16:45 +0000 UTC, MaxTimestamp=2022-10-19 09:16:45 +0000 UTC, TagFilters=[\n{Key="", Value="mysql\_info\_schema\_table\_version", IsNegative: false, IsRegexp: false}\n]”: search error after reading 0 data blocks: error when searching for tagFilters=[{ **name** =“mysql\_info\_schema\_table\_version”}] on the time range [2022-10-18 21:16:45 +0000 UTC - 2022-10-19 09:16:45 +0000 UTC]: error when searching tsids: the number of matching timeseries exceeds 10000; either narrow down the search or increase -search.max\* command-line flag values at vmselect```` Hello! You have default pmm installation without any changes in VictoriaMetrics? Can you share result “ps -aux | grep victoriametrics” from your instance with pmm-server? ---
**Author:** ![PavelVD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavelvd/32/6640_2.png) [@PavelVD](https://forums.percona.com/u/PavelVD)\ **Post date:** [October 28, 2022, 1:47pm UTC](https://forums.percona.com/t/mysql-table-details-error/18083/6 "2022-10-28T13:47:28Z")
> [@Anton\_Bystrov](#): > > ps -aux | grep victoriametrics No any changes in VictoriaMetrics - only default ```auto rsindar+ 1847 53.5 42.9 46147580 6977992 ? Sl Aug16 56275:55 /usr/sbin/victoriametrics --promscrape.config=/etc/victoriametrics-promscrape.yml --retentionPeriod=30d --storageDataPath=/srv/victoriametrics/data --httpListenAddr=127.0.0.1:9090 --search.disableCache=true --search.maxQueryLen=1MB --search.latencyOffset=5s --search.maxUniqueTimeseries=60000000 --search.maxQueueDuration=30s --search.logSlowQueryDuration=30s --search.maxQueryDuration=60s --promscrape.streamParse=true --prometheusDataPath=/srv/prometheus/data --http.pathPrefix=/prometheus --envflag.enable --envflag.prefix=VM_ root 1966 26.4 0.7 5009648 114632 ? Sl Aug16 27797:51 /usr/sbin/pmm-managed --victoriametrics-config=/etc/victoriametrics-promscrape.yml --victoriametrics-url=http://127.0.0.1:9090/prometheus --postgres-name=pmm-managed --postgres-username=pmm-managed --postgres-password=***--supervisord-config-dir=/etc/supervisord.d ``` ---
**Author:** ![Anton\_Bystrov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/anton_bystrov/32/4880_2.png) [@Anton\_Bystrov](https://forums.percona.com/u/Anton_Bystrov)\ **Post date:** [October 28, 2022, 2:32pm UTC](https://forums.percona.com/t/mysql-table-details-error/18083/7 "2022-10-28T14:32:45Z")
Thank you. You have 75 services, right? And how many databases do you have? Did you have any databases growth at 2022-10-18 - 2022-10-19? ---
**Author:** ![PavelVD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavelvd/32/6640_2.png) [@PavelVD](https://forums.percona.com/u/PavelVD)\ **Post date:** [October 28, 2022, 2:37pm UTC](https://forums.percona.com/t/mysql-table-details-error/18083/8 "2022-10-28T14:37:22Z")
We constantly make changes in databases, including the number of monitoring objects, it is very difficult to associate with a specific change ( ---
**Author:** ![PavelVD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavelvd/32/6640_2.png) [@PavelVD](https://forums.percona.com/u/PavelVD)\ **Post date:** [October 28, 2022, 3:01pm UTC](https://forums.percona.com/t/mysql-table-details-error/18083/9 "2022-10-28T15:01:41Z")
And this error on any time frame ```auto Error updating options: cannot fetch data for "MinTimestamp=2022-10-28 03:01:10 +0000 UTC, MaxTimestamp=2022-10-28 15:01:10 +0000 UTC, TagFilters=[\n{Key=\"\", Value=\"mysql_info_schema_table_version\", IsNegative: false, IsRegexp: false}\n]": search error after reading 0 data blocks: error when searching for tagFilters=[{ __name__ ="mysql_info_schema_table_version"}] on the time range [2022-10-28 03:01:10 +0000 UTC - 2022-10-28 15:01:10 +0000 UTC]: error when searching tsids: the number of matching timeseries exceeds 10000; either narrow down the search or increase -search.max* command-line flag values at vmselect ``` ---
**Author:** ![PavelVD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavelvd/32/6640_2.png) [@PavelVD](https://forums.percona.com/u/PavelVD)\ **Post date:** [October 28, 2022, 3:02pm UTC](https://forums.percona.com/t/mysql-table-details-error/18083/10 "2022-10-28T15:02:36Z")
About database count - it ~ 1500 ---
**Author:** ![Anton\_Bystrov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/anton_bystrov/32/4880_2.png) [@Anton\_Bystrov](https://forums.percona.com/u/Anton_Bystrov)\ **Post date:** [October 31, 2022, 7:36am UTC](https://forums.percona.com/t/mysql-table-details-error/18083/11 "2022-10-31T07:36:16Z")
> [@PavelVD](#): > > `Error updating options: cannot fetch data for "MinTimestamp=2022-10-28 03:01:10 +0000 UTC, MaxTimestamp=2022-10-28 15:01:10 +0000 UTC, TagFilters=[\n{Key=\"\", Value=\"mysql_info_schema_table_version\", IsNegative: false, IsRegexp: false}\n]": search error after reading 0 data blocks: error when searching for tagFilters=[{ __name__ ="mysql_info_schema_table_version"}] on the time range [2022-10-28 03:01:10 +0000 UTC - 2022-10-28 15:01:10 +0000 UTC]: error when searching tsids: the number of matching timeseries exceeds 10000; either narrow down the search or increase -search.max* command-line flag values at vmselect` Looks like you have limitation at “-search.maxSeries”. How you run pmm instance? In docker? ---
**Author:** ![PavelVD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavelvd/32/6640_2.png) [@PavelVD](https://forums.percona.com/u/PavelVD)\ **Post date:** [October 31, 2022, 7:46am UTC](https://forums.percona.com/t/mysql-table-details-error/18083/12 "2022-10-31T07:46:03Z")
Yes, in docker and only default params ---
**Author:** ![Anton\_Bystrov](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/anton_bystrov/32/4880_2.png) [@Anton\_Bystrov](https://forums.percona.com/u/Anton_Bystrov)\ **Post date:** [October 31, 2022, 9:28am UTC](https://forums.percona.com/t/mysql-table-details-error/18083/13 "2022-10-31T09:28:16Z")
You can try to increase `-search.maxSeries` parameter in your docker container directly (add in /etc/supervisord.d/victoriametrics.ini --search.maxSeries=30000, and `supervisorctl reread && supervisorctl stop victoriametrics && supervisorctl remove victoriametrics && supervisorctl add victoriametrics` in docker container with pmm) or waiting for new release of PMM. It should be fixed at this PR: [PMM-10629: upgrade to VictoriaMetrics 1.82.1 by michal-kralik · Pull Request #1325 · percona/pmm · GitHub](https://github.com/percona/pmm/pull/1325) ---
**Author:** ![PavelVD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/pavelvd/32/6640_2.png) [@PavelVD](https://forums.percona.com/u/PavelVD)\ **Post date:** [October 31, 2022, 9:53am UTC](https://forums.percona.com/t/mysql-table-details-error/18083/14 "2022-10-31T09:53:31Z")
Thank you for reply!