PHP MySQLi Singleton for Ajax-Requests end in to many processes -


i have php application uses ajax information - in back, uses php mysqli singleton. ajax-requests send every 0.5 second , read stuff out of database , deliver json string website. when open website several times (in different tabs), error because php, or rather apache, not "fork process". server has enough ram, problem taht process-limit of 130 processes reached.

cat /proc/user_beancounters ---------------------------         | held  | maxheld | numproc |  130  |     130 |

so, know if it's possible singleton fault (like "why singletons bad") or imagine error source? error source, many mysql-processes started , reach max. limit?

i recommend post code of singleton , ajax back-end. it's hard make statement saying singleton or ajax back-end @ fault if not able @ it.

i @ number of connections more cause though. if not local application it's not uncommon actual requests take more 0.5s. 1 request might not done before call another. on time build queue sqli backend not able process fast enough , process count start rise since new requests added queue every 0.5s each connected client.

how ajax back-end look? run query straight away? launch php instance? how many concurrent connection webserver , database configured for? these things heavily determine how application behaves. also, stated. note if use singleton not live past execution of ajax call. each time make call php application starts scratch , singleton created scratch once again.

you set application (written in php or other) run time , make use of main loop. either make listen specific socket or other means have ajax back-end pass data application. running application handle database back-end , return data ajax back-end return reply. way database handler not recreate singleton time. still run queue issues if there lot of clients making requests require database look-up every 0.5s.

good luck!


Comments

Post a Comment

Popular posts from this blog

c# - SharpSVN - How to get the previous revision? -

i trying find efficient way previous revision of file text comparison using sharpsvn. using (svnclient c = new svnclient()) { c.authentication.defaultcredentials = new networkcredential( configurationmanager.appsettings.get("svnserviceusername") , configurationmanager.appsettings.get("svnservicepassword") , configurationmanager.appsettings.get("svnservicedomain") ); c.authentication.sslservertrusthandlers += new eventhandler<svnsslservertrusteventargs>(authentication_sslservertrusthandlers); collection<svnfileversioneventargs> fileversioncollection = new collection<svnfileversioneventargs>(); svnrevisionrange range = new svnrevisionrange(0, this.hooks.revision); svnfileversionsargs args = new svnfileversionsargs(); args.retrieveproperties = true; args.range = range; foreach (svnchangeitem item in log.changedpaths) { string path = this.repositorypath + it...
Read more

c++ - Is it possible to compile a VST on linux? -

for class project i'm attempting write vst plugin backed cuda. current cuda workflow on linux box, i'd prefer compile , link there. according wikipedia , should possible (i couldn't find steinberg documentation relevant linux) can't find makefile or instructions on how build if aren't using xcode or visual studio. i'm vst 3 sdk doesn't support linux. when try compile plugin under linux, error: ./base/source/fatomic.cpp:39:30: fatal error: libkern/osatomic.h: no such file or directory this issue caused following code in "vst3 sdk/base/source/fatomic.cpp" #if mac #include <libkern/osatomic.h> #if mac_os_x_version_min_required > mac_os_x_version_10_4 #define native_atomic_type (volatile int32_t*) #else #define native_atomic_type (int32_t*) #endif #elif windows #include <windows.h> #endif but hope compiling under linux work vst sdk 2.4. reading. jvstwrapper seems run on lin...
Read more

url - Querystring manipulation of email Address in PHP -

i using third party application (email2http) send me emailid, body , message. unable retrieve email id due name appended on , enclosed < , >. here querystring getting. test.php?from=ajay+reddy &subject=cx&body=somebody when print variable in php returns name , not email id. $from = $_get['from']; echo $from; //output ajay reddy please suggest me how can emailid also. i dont want use post method due testing , debugging. it's working fine. forgot use htmlentities() in debugging.
Read more