[google-cloud-sql-discuss] Re: I/O performance (mostly write?) intermittently goes severely low

Thanks for your input. But the insertions are performed in bulk (like 1000 rows) and light in index. They read data from local files. Above all, they execute fast enough until the described problem gets triggered.

2021年5月10日月曜日 4:47:54 UTC+9 od...@eversql.com:

As it is mostly write, it can be from several reasons like: Having unnecessary indexes, not using a bulk insert, uploading the data from remote servers,  etc. 
you can use EverSQL to get a performance analysis and find missing MySQL indexes.

On Saturday, May 8, 2021 at 4:11:01 PM UTC+3 shinji...@gmail.com wrote:

Hello. I'm looking at an instance (MySQL 2.7 2nd gen + 4vcpu + 15GB RAM + 100GB SDD + no failover) that has been running happily for about a year but have started to show intermittent performance issue  since late Apr.

Insertions that get executed at several tens of times per second suddenly start  to take tens or hundreds of seconds to get just a row inserted. When this happens I see lots of messages in the log like 

  textPayload: "2021-05-08T11:16:29.861999Z 369333 [Note] Aborted connection 369333 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error writing communication packets)"

  textPayload: "2021-05-08T11:14:10.448301Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 9784ms. The settings might not be optimal. (flushed=521 and evicted=0, during the time.)" 

A restart seems to resolve the issue momentary but the problem resurfaces after some hours or days

Is there a solution or a workaround for the issue?

TIA for your help.

--
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/c1e487aa-94fd-4e03-8c2c-0d8b147ff6aan%40googlegroups.com.