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

Hey Geoffrey,

To check whether there's any process running which might be responsible for the approx 1 page-write/s rate, you could see about running "SHOW FULL PROCESSLIST\G" during those times with zero user activity and yet a 1 page-write/s rate reporting.

This Q&A on the DBA Stack Exchange site has an excellent reply examining all the different possible sources of writes in the InnoDB engine.

Running "SHOW ENGINE INNODB STATUS;" during the times with zero user activity and yet a 1 page-write/s rate reporting could also be useful in analyzing what's happening. 

Feel free to analyze the results of your investigations alone or send them along via replying to that same email I had sent. I'd be very interested to take a look at the data.

I'll be taking a look to see if I can learn more about what the update contained, and to what extent it could have contributed to this. At any rate, one page write per second is nothing that will impact performance on your app, so there's nothing to worry about in the meantime.

Cheers,

Nick
Cloud Platform Community Support



On Friday, February 24, 2017 at 12:38:25 PM UTC-5, Geoffrey Arnold wrote:

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/e7db948c-4435-4387-9976-042dd5721576%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.