Friday, February 24, 2017

Re: [google-cloud-sql-discuss] Re: Major change to InnoDB Pages Written after update

Thanks for taking a look. The largest table on this instance is about 6K rows and 19MB in size. 

I already replied to your other email, but just ran SHOW TABLE STATUS on each of the schemas. I'll include that output in the other thread.




On Thu, Feb 23, 2017 at 5:38 PM, 'paynen' via Google Cloud SQL discuss <google-cloud-sql-discuss@googlegroups.com> wrote:
Hey Geoffrey,

There are many moving parts involved in the InnoDB engine which might lead to an increase or decrease of page writes. Without knowing anything more about your system, it's hard to say what might be the cause.

I've sent an email to you through our support portal to request your Project ID and the instance name so we can see about taking a closer look at what update was applied. You may want to also gather information about the sizes of your tables, the kinds of queries run, the frequencies with which they're run, etc. for your reply.

I'll be happy to post here any further progress we make as we look into this.

Cheers, 

On Thursday, February 23, 2017 at 12:06:58 PM UTC-5, geoffrey.arnold@gmail.com wrote:
Hello,

It appears that on February 4 at 11:13 PM CT our Cloud SQL instance received an update. Since then we've seen a major change to the InnoDB Pages Written metric. Screenshots attached. Any help with where to begin troubleshooting would be greatly appreciated.

Thanks in advance,
Geoff.



--
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/0c57b551-be97-478e-9f87-1146506f0055%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
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/CAF388627yms1wQrioMT%2B3px%2BCvSjQN4%3DDy%2BEgskR4Np5gi5wpw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

No comments:

Post a Comment