Re: mysql errors
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62390
interpreted = N
texte = HI,> Bill Quoting:> > If the other webdna code is being processed, then it is MySQL > that is failing you. If you have MySQL and the web server on > the same machine, you might be much better off separating the > two. Perhaps some stress testing is warranted. How many > connections per second at peak traffic?Approximately 300 tpl requests per minute.It seems that the issue of the "MySql connection error" is a problem ofWebDNA.I made a test which did the following.1. I've created a stress test project with "Microsoft Application CenterTest", which does some WebDNA page requests on my site for 5 minutes (whichhas some queries to my REGULAR database), using a lot of concurrent threads.2. Created 2 simple WebDNA pages.1. Test_page1.tpl a simple query to my REGULAR database.2. Test_page2.tpl a simple query to a TEST database.3. While the test (in paragraph 1) was running, I had one person constantlyrefreshing test_page1.tpl and another person refreshing test_page2.tpl,approx. whenever test_page1.tpl showed "sql error 000000" test_page2.tplshowed the same message, which doesn't make any sense, since test_page2.tpldoesn't access the same database, unless we say that it is WebCatalog whichcan only handle a finite amount of MySql queries at once. -------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
HI,> Bill Quoting:> > If the other webdna code is being processed, then it is MySQL > that is failing you. If you have MySQL and the web server on > the same machine, you might be much better off separating the > two. Perhaps some stress testing is warranted. How many > connections per second at peak traffic?Approximately 300 tpl requests per minute.It seems that the issue of the "MySql connection error" is a problem ofWebDNA.I made a test which did the following.1. I've created a stress test project with "Microsoft Application CenterTest", which does some WebDNA page requests on my site for 5 minutes (whichhas some queries to my REGULAR database), using a lot of concurrent threads.2. Created 2 simple WebDNA pages.1. Test_page1.tpl a simple query to my REGULAR database.2. Test_page2.tpl a simple query to a TEST database.3. While the test (in paragraph 1) was running, I had one person constantlyrefreshing test_page1.tpl and another person refreshing test_page2.tpl,approx. whenever test_page1.tpl showed "sql error 000000" test_page2.tplshowed the same message, which doesn't make any sense, since test_page2.tpldoesn't access the same database, unless we say that it is WebCatalog whichcan only handle a finite amount of MySql queries at once. -------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
"Chaim Klar"
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
WebCatalog/Mac 2.1b2 - PIXO (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
WebCat2 - Getting to the browser's username/password data (1997)
[SearchString] usage (1997)
instant cookies? (1999)
WebDelivery: One step closer !! (1997)
version 2 for NT (1997)
searchable list archive (1997)
Search design (1997)
searching multiple databases (1997)
Roundup function? (1997)
Exists? (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
[WebDNA] Reformatting database headers (2009)
Summing fields (1997)
urls (2005)
Re:quit command on NT (1997)
Extended [ConvertChars] (1997)
Calculating multiple shipping... (1997)
Dummy Form Variables Needed (2000)