Tuesday Apr 14, 2009

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


Tuesday Feb 03, 2009

SugarCRM Conference 2009

Today I presented at the SugarCon 2009. The agenda for the conference can be found here: http://www.sugarcrm.com/crm/events/sugarcon/agenda.html. My presentation was regarding "Benchmarking Sugar and MySQL on Solaris". The presentation itself can be downloaded from here: http://blogs.sun.com/vanga/resource/sugar/BenchmarkingSugarOnSolaris-SugarCon2009.pdf.

Wednesday Jul 09, 2008

Using Sun Storage J4200/J4400 Arrays with MySQL and SugarCRM

Using Sun Storage J4200/J4400 Arrays with MySQL and SugarCRM


The Sun Storage J4200/J4400 Arrays are general purpose, high-availability, and cost-effective 2RU, 12-disk SCSI Enclosure Services (SES) disk tray system (J4200) and a 4RU, 24-disk SES disk tray system. Additional Information on the storage arrays can be obtained here http://docs.sun.com/source/820-3222-10/index.html.

We are working on a benchmark with the latest SugarCRM 4.5.1 with the intent to measure the price to performance of using Sun Storage J4200/J4400 Arrays. Please stay tuned for a more detailed blog on our findings. Other than the storage arrays replacing the ST2540 this benchmark is similar to the one we did recently http://blogs.sun.com/vanga/entry/scaling_sugarcrm_with_mysql_on

About

Satish Vanga

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today