Dear Di, I tried to regenerate your problem but I couldn't. I simulate 1000 concurrent users (the database is loaded with 1000) and 4 worker processes in Nginx. I get 90-100% utilization on one core. Do you see any errors in the simulation log or in the MySQL log file? If so, please send the log files to me. Note that the CPU utilization is for the whole processor and not a single core. The DB server should have lower CPU utilization (~3-4x) compared to the Web server.
Regards, Mohammad On Apr 24, 2012, at 8:34 PM, di wang wrote: 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]<mailto:[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]<mailto:[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]<mailto:[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]<mailto:[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>
