google app engine - High Database Instance Uptime for no queries -

-

i have set wordpress site on google appengine php according instructions @ https://developers.google.com/appengine/articles/wordpress

i have cdn sitting in front of site load on google app engine instance tiny. cron jobs , cdn updating it's cache. here access logs fro last 7 hours example.

2013-08-29 06:09:12.829 /post-sitemap.xml 200 6793ms 0kb amazon cloudfront 2013-08-29 06:09:05.727 /robots.txt 200 4ms 0kb amazon cloudfront 2013-08-29 04:55:07.937 /wp-cron.php 200 7206ms 0kb appengine-google; (+http://code.google.com/appengine) 2013-08-29 04:33:59.915 /tag/javascript/ 200 8822ms 37kb amazon cloudfront 2013-08-29 04:33:59.914 request caused new process started application, , caused application code loaded first time. requ 2013-08-29 01:12:03.214 / 200 8751ms 39kb amazon cloudfront 2013-08-29 01:12:03.214 request caused new process started application, , caused application code loaded first time. requ 2013-08-29 01:11:50.755 /robots.txt 200 64ms 0kb amazon cloudfront 2013-08-29 00:05:27.592 /sitemap_index.xml 200 7316ms 1kb mozilla/5.0 (compatible; googlebot/2.1; +http://www.google.com/bot.html) 2013-08-29 00:05:20.217 /robots.txt 200 4ms 0kb mozilla/5.0 (compatible; googlebot/2.1; +http://www.google.com/bot.html) 2013-08-28 23:30:45.596 /system/feeds/sitemap 301 179ms 0kb amazon cloudfront

my problem despite tiny load cloud sql instance online way , though expect usage charges under scenario tiny, not, looking @ having commit package keep them under control rather paying usage.

see following graph instance uptime ends @ 6am (log time) (10pm utc)

instance uptime

then @ query load same period

query load

my guess @ happening database connection being opened google app engine instance started (whether serving static or dynamic objects).

any ideas on how can resolve this?

the cloud sql query graph misleading. application getting queries throughout day, resulted in hit on database every hour. caused database half time. problem solved in forthcoming version of cloud console (cloud.google.com/console).

sorry confusion

joe faith, product manager, google cloud sql


Comments

Post a Comment

Popular posts from this blog

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more