java - AppEngine frontend to DB latency temporarily ~10 secs every ~20 calls? -

-

this (see chart below) happening since 3/7. sure can because of instances loading , unloading. know other reasons gae behaving this?

it's not high replication instance. , during testing had 5 instances f2 running our test client calls. there db calls, image processing , memcache usage.

there 2 issues equal: http://code.google.com/p/googleappengine/issues/detail?id=4180&sort=priority&colspec=id%20type%20component%20status%20stars%20summary%20language%20priority%20owner%20log

http://code.google.com/p/googleappengine/issues/detail?id=6309&sort=priority&colspec=id%20type%20component%20status%20stars%20summary%20language%20priority%20owner%20log

and there's entry in forum: https://groups.google.com/forum/#!topic/google-appengine/js5cerwlqz0/discussion

gae-j appstat chart

logging (shay requested) shows persistence manager seems take 6 seconds initialize:

2012-03-11 15:32:47.543 /api/yyy 200 16811ms 0kb xxx/1.1 cfnetwork/548.1.4 darwin/11.0.0 78.53.230.114 - - [11/mar/2012:07:32:47 -0700] "post /api/yyy http/1.1" 200 94 - "zzz/1.1 cfnetwork/548.1.4 darwin/11.0.0" "zzz.appspot.com" ms=16812 cpu_ms=6040 api_cpu_ms=82 cpm_usd=0.167820 pending_ms=5765 instance=00c71b117ca3858c47bdc41d5b30a732dd76eaaf 2012-03-11 15:32:37.196 www.server.xxxservlet getvvv: 1 2012-03-11 15:32:37.202 www.server.xxxservlet getvvv: hash 2012-03-11 15:32:37.207 www.server.xxxservlet getvvv: pm (persistencemanager pm = pmf.get().getpersistencemanager();) 2012-03-11 15:32:43.606 www.server.xxxservlet getvvv: data 2012-03-11 15:32:47.355 www.server.xxxservlet getvvv: got data 2012-03-11 15:32:47.388 www.server.xxxservlet getvvv: done

and pmf implemented as:

public final class pmf {     private static final persistencemanagerfactory pmfinstance =         jdohelper.getpersistencemanagerfactory("transactions-optional");      private pmf() {}      public static persistencemanagerfactory get() {         return pmfinstance;     } }

the area don't see stats code running, stats starts when request entered don't think got thing instance loading.
suggest adding logs see flow of handler code.


Comments

Post a Comment

Popular posts from this blog

delphi - How to convert bitmaps to video? -

-
Image
my application creates images fractals , love feeling of 'flying' around fractal. once saved 2000 bitmaps file , created avi using premiere. experience rather frustrating though succeeded in creating movie. spectacular. of course want create video application. don't care niftyness of codec, compression or whatever. want have video can replay on systems. in past have tried never succeeded. triggered question alas not ffmpeg running. update i decided adapt question , put bounty it. have seen several solutions attractive (because it's simple) seems me taviwrite. tried taviwriter did not succeed. in procedure taviwriter.write; function call around line 370 avierr := avisavev(s, // pchar(filename), nil, // file handler nil, // callback nstreams, // number of streams streams, compoptions); // compress options
Read more

jasper reports - Fixed header in Excel using JasperReports -

-
how can create excel report fixed header using japserreports? mean need header fixed when scroll excel file. this possible adding couple properties in jrxml file each report. take @ advanced excel features freeze panes. if wanted freeze after first column header (down left side basically) this: <statictext> <reportelement style="sans_bold" mode="opaque" x="0" y="60" width="104" height="20" forecolor="#ffffff" backcolor="#666666"> <property name="net.sf.jasperreports.export.xls.auto.filter" value="start"/> <property name="net.sf.jasperreports.export.xls.column.width" value="110"/> <property name="net.sf.jasperreports.export.xls.freeze.column.edge" value="left"/> </reportelement> &
Read more

python - ('The SQL contains 0 parameter markers, but 50 parameters were supplied', 'HY000') or TypeError: 'tuple' object is not callable -

-
import pyodbc,nltk,array cnxn = pyodbc.connect('driver={mysql odbc 5.1 driver};server=127.0.0.1;port=3306;database=information_schema;user=root; password=1234;option=3;') cursor = cnxn.cursor() cursor.execute("use collegedatabase ;") cursor.execute("select * sampledata ; ") cnxn.commit() s=[] j=[] x=[] words = [] w = [] sfq = [] pos=[] entry in cursor: s.append(entry.injury_type),j.append(entry.injury_desc) nltk.tokenize import punktwordtokenizer nltk.corpus import stopwords tokenizer = punktwordtokenizer() english_stops = set(stopwords.words('english')) in range(0,26): # filter stop words tokenizer.tokenize(j[i]) w.append([word word in tokenizer.tokenize(j[i]) if word not in english_stops]) in range(0 , 26):#converting tokenzied text ito string sfq.append(" ".join(w[a])) replacers import regexpreplacer replacer = regexpreplacer() in range (0,26):#pos tagging replacer.repl
Read more