Hi Mohammad, Thanks for your reply. I tried 1000 concurrent users and also populate both database and filestore with 1000 scale. Set the worker_processes to 4 and each can handle 1024. I set the rampup time to 300 seconds. However, the cpu of utilization of both web server and database server is still very low, at most 5%. I also noticed that at the webserver side, typically 5-6 threads come and go.
It seems that there is some bottleneck in my setup that the number of concurrent users does not have an effect. Any idea what I might need to tune? thanks, di On Wed, Apr 18, 2012 at 3:51 AM, Mohammad Alisafaee < [email protected]> wrote: > Hi Di, > > You need to set the number of "Concurrent Users" when running the > experiments (Driver tab) and also populate the database to support that > many users. A ~1000 users per core should be enough to saturate one core in > the web server machine. To saturate DB machine you might need 3000-4000 > users. Also make sure that the ramp up time is not too short (~3-4 minutes > should be fine). > > BTW, you should set the worker_processes to a much lower value (e.g. 4 > or so). The multiplication of theses two parameter must be larger than the > number of concurrent users. > > Mohammad > > On Apr 17, 2012, at 3:31 AM, di wang wrote: > > Thanks, Mohammad. It works now. I think I set the wrong nginx > configuration file. > > Another question related to this: how can I saturate the web server and > database server? > > I tried to change the worker_processes and worker_connections to a > larger value e.g., 128, 1024 respectively. > > But the CPU utilization of web server and database server are still very > low, at most 2-3%. > > Are there other parameters that I need to increase? > > thanks, > > di > > On Sat, Apr 14, 2012 at 8:24 PM, Mohammad Alisafaee < > [email protected]> wrote: > >> Hi Di, >> >> Reaching to the index page means that you could have connected to the >> database. I do not know what you exactly mean by "login errors". Can you >> please tell me what are the error messages you get? >> >> Getting these PHP notices is fine but you should prevent them from >> being displayed on pages. Add the following two lines to your php.ini >> (replace them if they are already there) and restart your PHP/Nginx: >> error_reporting = E_NONE >> >> >> display_errors = Off >> >> The index page should look like the attached image. >> >> Mohammad >> <Screen Shot 2012-04-15 at 2.20.04 AM.png> >> >> On Apr 13, 2012, at 7:36 PM, di wang wrote: >> >> Hi Mohammad, >> >> Thanks for your quick reply. I know both username and password are >> olio and I have done (grant all privileges on *.* to 'olio'@'localhost' >> identified by 'olio' with grant option;) . I still have the login errors. >> Do I also need to explicitly set the user name and password for MySQL? I >> am new to MySQL, please forgive my ignorance. >> >> I did a quick test by connecting to the web server. But I got the >> following messages on the webpage. I also attached the screenshot of the >> webpage. Does that look right to you? >> >> >> *Notice*: Undefined index: uname in */var/www/html/public_html/index.php* on >> line *29* >> >> *Notice*: Undefined index: page in */var/www/html/public_html/index.php* on >> line *30* >> >> *Notice*: Undefined index: flag in */var/www/html/public_html/index.php* on >> line *31* >> >> *Notice*: Undefined index: month in */var/www/html/public_html/index.php* on >> line *70* >> >> *Notice*: Undefined index: day in */var/www/html/public_html/index.php* on >> line *71* >> >> *Notice*: Undefined index: year in */var/www/html/public_html/index.php* on >> line *72* >> >> *Notice*: Undefined index: month in */var/www/html/public_html/index.php* on >> line *74* >> >> *Notice*: Undefined variable: eventdate in * >> /var/www/html/public_html/index.php* on line *87* >> >> *Notice*: Undefined variable: eventdate in * >> /var/www/html/public_html/index.php* on line *93* >> >> *Notice*: Use of undefined constant cursorClosed - assumed >> 'cursorClosed' in */var/www/html/classes/PDOResult.php* on line *66* >> >> *Deprecated*: Function session_unregister() is deprecated in * >> /var/www/html/public_html/index.php* on line *103* >> * >> * >> * >> * >> On Fri, Apr 13, 2012 at 4:21 AM, Mohammad Alisafaee < >> [email protected]> wrote: >> >>> Dear Di, >>> >>> The default username and password in the JDBC connection string is >>> "olio" (i.e. >>> "jdbc:mysql://dbHost/olio?*user=olio*&*password=olio*&relaxAutoCommit=true&sessionVariables=FOREIGN_KEY_CHECKS=0"). >>> You must replace this with the username and password which you used for the >>> MySQL database. >>> Make sure that in the database, the user has access permission from the >>> web server machine (e.g. grant all privileges on *.* to 'olio'@'localhost' >>> identified by 'olio' with grant option;). >>> You also can connect to the database via a browser to see if thing are >>> setup correctly. Manually start NginX and then go to >>> http://localhost:80<http://localhost/>(or any other ip or port which you >>> are using for the web server). You >>> should be able to see the first page of the Olio. >>> >>> Mohammad >>> >>> On Apr 13, 2012, at 4:34 AM, di wang wrote: >>> >>> Thanks, Mohammad. I have another question with regard to the the >>> following instruction: >>> In “JDBC connection URL” replace *dbHost* with the database server >>> address and set the correct username and password for connecting to the >>> database >>> >>> Where are the username and password set in the instruction? I have a >>> lot of login failures (e.g., UIDriverAgent[2].7.doLogin: Found login >>> prompt at index 4226, Login as cp48h5fa, 2233 failed.) >>> >>> so I guess it is related to this. >>> >>> >>> >>> On Fri, Apr 6, 2012 at 12:26 PM, Mohammad Alisafaee < >>> [email protected]> wrote: >>> >>>> Dear Di, >>>> >>>> The values for fields which are required for a simulation are >>>> available in the instructions. If you have problem with some of the fields >>>> please mention their names and the error message you get. >>>> >>>> For the memcached error, clearing the "Host:Port Pairs" text box >>>> (under the "Memcached Servers" section) should fix the problem. >>>> >>>> The Nginx is not supported by Olio and that's why you get an error >>>> message. The Nginx should start normally and you should be able to run >>>> simulations. If it doesn't, then either start it manually or create a >>>> script which ignores the "start" argument and starts Nginx. Use this script >>>> as the "Web server command path". >>>> >>>> Regards, >>>> Mohammad >>>> >>>> On Apr 6, 2012, at 4:21 AM, di wang wrote: >>>> >>>> Hi, >>>> >>>> Would you please let me know your inputs for the web server and >>>> database server tabs of http://<faban_master_machine>:9980 ? >>>> >>>> I have some difficulties in filling some of the fields and have some >>>> errors during the run? >>>> >>>> For e.g., it is stilling looking for memcached server even though I >>>> disable it. >>>> And it complains about nginx: invalid option: "start". Failed to find >>>> start message in /usr/local/nginx/logs/error_log on 130.203.37.158 ... >>>> >>>> >>>> >>>> thanks, >>>> >>>> di >>>> >>>> >>>> >>> >>> >> <Screenshot at 2012-04-13 13:26:51.png> >> >> >> > >
