sugar
SugarCRM Performance on Sun X4270 Server
Open Source Benchmark Kit for SugarCRM has been recently released on-line. This benchmark kit is a standardized benchmark kit that can be used to measure the performance of SugarCRM 4.5.1 and 5.2.0 releases. The source and instructions to use the benchmark kit can be downloaded from here: http://kenai.com/projects/erpbench
Using the Open Source Benchmark Kit for SugarCRM the performance
of SugarCRM 4.5.1i has been measured on Sun X4270 Server. The
following results were obtained on this server.
|
Final Result: 66.937 @CRM Ops/Sec, Total Users: 330 |
|
Server Configuration |
Sun X4270 SSD Drives (2 x 32GB) |
2 x Intel X5570 Processors 24GB RAM |
|
Software Configuration |
SugarCRM 4.5.1i Apache 2.2.11 MySQL 5.0.67 PHP 5.2.9 Open Solaris Build 110 |
|
Throughput and Response Time Graphs for CRM Operations
The CRM Operations are divided into three drivers that call these operations during the benchmark. I have provided the throughput graphs for all the three including the Response Times.
Open Source Benchmark Kit for SugarCRM
This kit is based on the Faban Harness that is known to scale well for thousands of concurrent user simulations across distributed drivers. More information regarding Faban can be obtained from the project website here: http://faban.sunsource.net/
This benchmark is based on the typical functions that can be performed on a CRM application like SugarCRM. The following Business Objects are used during benchmark runs.
|
Module |
List View, Detail View |
Create, Delete |
|
Login |
- |
- |
|
Contacts |
Yes |
Yes |
|
Meetings |
Yes |
Yes |
|
Tasks |
Yes |
Yes |
|
Accounts |
Yes |
Yes |
|
Opportunities |
Yes |
Yes |
|
Leads |
Yes |
Yes |
|
Emails |
Yes |
Yes |
|
Notes |
Yes |
Yes |
|
Cases |
Yes |
Yes |
|
Logout |
- |
- |
Performance Tunings
The following tunings were applied to SugarCRM 4.5.1i for this benchmark:
|
#file name config_override.php #Some of the following are available only in 5.x $sugar_config['calculate_response_time'] = false; $sugar_config['verify_client_ip'] = false; $sugar_config['use_real_names'] = false; $sugar_config['stack_trace_errors'] = false; $sugar_config['developerMode'] = false; $sugar_config['disable_count_query'] = true; $sugar_config['hide_subpanels_on_login'] = true; $sugar_config['disable_vcr'] = true |
|
#file name config.php following lines are modified 'special_query_limit' => 9000000, 'default_limit' => 9000000, |
The following tunings were applied to the MySQL database configuration:
|
#file name /etc/mysql/5.0/my.cnf [mysqld] port = 3306 socket = /tmp/mysql.sock datadir = "/db_ssd/data" back_log = 50 max_connections = 5000 max_connect_errors = 10 table_cache = 2048 max_allowed_packet = 2M binlog_cache_size = 8M max_heap_table_size = 128M sort_buffer_size = 64M join_buffer_size = 128M thread_cache_size = 3000 thread_concurrency = 3000 record_buffer = 8M query_cache_size = 256M query_cache_type = 1 query_cache_limit = 4M query_prealloc_size=65536 ft_min_word_len = 4 default-storage-engine = innodb thread_stack = 192K transaction_isolation = REPEATABLE-READ tmp_table_size = 1024M log_long_format
server-id = 1 key_buffer_size = 64M read_buffer_size = 8M read_rnd_buffer_size = 64M bulk_insert_buffer_size = 128M
innodb_additional_mem_pool_size = 1024M innodb_buffer_pool_size = 1G innodb_data_file_path = ibdata1:2048M:autoextend innodb_data_home_dir = /db_ssd/data innodb_file_io_threads = 8 innodb_thread_concurrency = 0 innodb_flush_log_at_trx_commit = 1 innodb_log_buffer_size = 16M innodb_log_file_size = 1G innodb_log_files_in_group = 2 innodb_log_group_home_dir = /ZFS_DISK/db/logs innodb_max_dirty_pages_pct = 90 innodb_lock_wait_timeout = 120 |
Posted at 09:26AM Apr 14, 2009 by Satish Vanga in Sun | Comments[1]
Thank you for yet another informative and useful post. Can we expect a benchmark of the following setup:
- MySQL Cluster 7.0.8a GA with two physically separate server nodes
with
- SugarCRM 5.2.0j on two physically separate webservers, with all tables on NDB storage engine
?
It's a really, practically useful realworld setup.
Thanks in advanse,
WBR,
Andy
Posted by andy_scott on October 14, 2009 at 03:49 AM PDT #