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 of WebDNA. I made a test which did the following. 1. I've created a stress test project with "Microsoft Application Center Test", which does some WebDNA page requests on my site for 5 minutes (which has 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 constantly refreshing test_page1.tpl and another person refreshing test_page2.tpl, approx. whenever test_page1.tpl showed "sql error 000000" test_page2.tpl showed the same message, which doesn't make any sense, since test_page2.tpl doesn't access the same database, unless we say that it is WebCatalog which can 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:

    
  1. Re: mysql errors ( "Chaim Klar" 2005)
  2. Re: mysql errors ( devaulw@onebox.com 2005)
  3. Re: mysql errors ( devaulw@onebox.com 2005)
  4. Re: mysql errors ( "Chaim Klar" 2005)
  5. Re: mysql errors ( devaulw@onebox.com 2005)
  6. mysql errors ( "webdna-talk" 2005)
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 of WebDNA. I made a test which did the following. 1. I've created a stress test project with "Microsoft Application Center Test", which does some WebDNA page requests on my site for 5 minutes (which has 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 constantly refreshing test_page1.tpl and another person refreshing test_page2.tpl, approx. whenever test_page1.tpl showed "sql error 000000" test_page2.tpl showed the same message, which doesn't make any sense, since test_page2.tpl doesn't access the same database, unless we say that it is WebCatalog which can 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)