Missing database "disk"

30 views
Skip to first unread message

Fabio Palladino

unread,
Apr 24, 2021, 8:31:23 AM4/24/21
to proxysql
Hi,
I don't know why but the database disk has disappeared and doing show tables I see the tables of the db stats.

admin (main)>show tables;
+--------------------------------------+
| tables                               |
+--------------------------------------+
| global_variables                     |
| stats_memory_metrics                 |
| stats_mysql_commands_counters        |
| stats_mysql_connection_pool          |
| stats_mysql_connection_pool_reset    |
| stats_mysql_errors                   |
| stats_mysql_errors_reset             |
| stats_mysql_free_connections         |
| stats_mysql_global                   |
| stats_mysql_gtid_executed            |
| stats_mysql_prepared_statements_info |
| stats_mysql_processlist              |
| stats_mysql_query_digest             |
| stats_mysql_query_digest_reset       |
| stats_mysql_query_rules              |
| stats_mysql_users                    |
| stats_proxysql_servers_checksums     |
| stats_proxysql_servers_metrics       |
| stats_proxysql_servers_status        |
+--------------------------------------+
19 rows in set (0.00 sec)

admin (main)>show databases;
+-----+---------------+-------------------------------------+
| seq | name          | file                                |
+-----+---------------+-------------------------------------+
| 0   | main          |                                     |
| 2   | monitor       |                                     |
| 3   | stats_history | /var/lib/proxysql/proxysql_stats.db |
+-----+---------------+-------------------------------------+
3 rows in set (0.00 sec)

Can someone help me?
Thanks in advance

René Cannaò

unread,
Apr 24, 2021, 9:28:24 AM4/24/21
to Fabio Palladino, proxysql
You are using a user with stats credentials instead of a user with admin credentials

--
You received this message because you are subscribed to the Google Groups "proxysql" group.
To unsubscribe from this group and stop receiving emails from it, send an email to proxysql+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/proxysql/c4ca834a-dd41-4f9c-a055-2b6917a3de81n%40googlegroups.com.

Fabio Palladino

unread,
Apr 24, 2021, 10:26:22 AM4/24/21
to René Cannaò, proxysql
I solved thanks
Reply all
Reply to author
Forward
0 new messages