[google-cloud-sql-discuss] Re: Error truncating performance_schema tables

Thanks for the reply. If I can't do the operation myself, can I request GCP support to do it for me from time to time? Trying to find a way out of this hole.

On Wednesday, February 3, 2021 at 1:32:20 AM UTC+5:30 George (Cloud Platform Support) wrote:

Because Cloud SQL for MySQL is a managed service, it restricts access to certain system procedures and tables that require advanced privileges. In Cloud SQL, customers cannot create or have access to users with superuser attributes. Your operation requires super privileges, so you won't be able to execute it. Related information can be found on the "MySQL users" page. 

On Tuesday, 02 February 2021 at 12:35:34 UTC-5 dhawal....@rubrik.com wrote:

Hi all, 

I'm using 2nd Gen MySQL 5.7. I want to collect data from performance_schema tables, such as "events_statements_summary_by_digest". However, this table has a max size and I think it will require periodic truncation to insert new rows. But when I run truncate table or delete command on this table, I get permission denied error

mysql> truncate table performance_schema.events_statements_summary_by_digest ; ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Without deleting old rows, we won't really be able to use perf schema as it'll fill all the rows quickly. Is there a way to delete rows from this table? Are folks able to use performance schema without periodic truncation? 

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/c87a0adf-1d77-4161-ace3-ad17f2e25453n%40googlegroups.com.