QNAP TS-119PII and TS-269L as a MySQL Database Server Performance Report

Running SugarCRM on QNAP TS-119PII is slow. Therefore, I decide to separate PHP programs and MySQL database onto different computers. For small database, network transfer delay is okay to ignore.

Let’s take a look at the test now!

Processor, RAM, and Linux Difference

While QNAP TS-269L is based on Intel Atom D2701 running at 2.13GHz, QNAP TS-119PII is Marvell 88F6281 at 2.0GHz, Shuttle X50V2 is Intel Atom D510 at 1.66GHz, and Lenovo ThinkCentre Edge 72z is Intel Pentium G630 at 2.7GHz.

Both D2701 and D510 has 2 cores with 4 threads and 4 times the cache (1MB vs 256KB) compares to the single core 88F6281. G630 is 2 cores with 2 threads and 3MB Smart Cache.

D2701, D510, and G630 have 64-bit instruction set while 88F6281 is 32-bit. TS-269L and TS-119PII are running 32-bit QTSTurnKey Linux in X50V2 and OpenSuSE 13.1 in Edge 72z are x64.

eAccelerator is included in QTSXCache is in TurnKey LinuxAlternative PHP Cache is in OpenSuSE. All PHP accelerators may cache opcode to reduce interpret time.

Test Method

I connect NAS to computer directly. MySQL is configured for remote connections on QTS as in Using NAS as your Database ServerSugarCRM is download from SugarForge and is installed manually on Edge 72z as a client. All setup with build-in demo data.

About the environment, Apache is in prefork. memory_limit in php.ini has been increased from 128M to 256M. Unnecessary background process and programs are disabled on NAS.

TS-119PII is configured with following disk set.

  1. Kingston SSDNow V+100

TS-269L is configured with following disk sets.

  1. OCZ Vertex 120GB SSD
  2. Two Seagate Surveillance SV35 2TB HDD as RAID 1

According to my MTU test, I keep it as default 1500.

I measure load time for 1 and 5 contacts in a single login session with Firefox. The 5 contacts are loaded in different tabs.

If you are confused or interested in the relationship of LAMP, thread, multi-core processor, hyper-threading, please refer to How Multi-Core Processors Accelerate your LAMP Applications.


Performance comparison table on QNAP TS-119PII and TS-269L as MySQL Database Server with others loading contacts from SugarCRM.
Performance comparison table on QNAP TS-119PII and TS-269L as MySQL Database Server with others loading contacts from SugarCRM.

For reference, I also include SugarCRM performance test on TS-269L, TS-119PII, X50V2, and Edge 72z as Type: AP + DB in the table.


Compared to running SugarCRM on TS-119PII, if you move the PHP programs to Edge 72z and leave MySQL on TS-119PII, you get 64% performance gain for retrieving 5 contacts. On the other hand, TS-269L is about 10% faster for the same situation in both disk sets.

Final Thoughts

For single user, TS-119PII is better to be used as a database server than running SugarCRM. TS-269L seems no big different between them.

When there are more concurrent users, the difference between TS-119PII and TS-269L should become more noticeable. Based on the hardware architecture of D2701, 4 concurrent user is the best scenario for TS-269L.

You may use memcached and follow the instruction in Enable Support for memcached section in Optimize LAMP for SugarCRM to improve performance.


  1. SugarCRM
  2. QNAP TS-119PII
  3. PHP
  4. MySQL
  5. QNAP TS-269L
  6. Intel Atom Processor D2700
  7. Marvell: Marvell 88F6282 SoC
  8. Marvell: Marvell 88F6281 SoC with Sheeva Technology
  9. Shuttle X50V2 Datasheet
  10. Intel: Intel Atom Processor D510
  11. Lenovo: ThinkCentre Edge 72z
  12. Intel: Intel Pentium Processor G630 (3M Cache, 2.70 GHz)
  13. Wiki: Thread (computing)
  14. Wiki: Smart Cache
  15. Wiki: Instruction set
  16. QNAP: QTS
  17. TurnKey Linux
  18. OpenSuSE: Portal: 13.1
  19. QNAP: App Center (QPKG)
  20. eAccelerator
  21. XCache
  22. PHP: Alternative PHP Cache
  23. Wiki: List of PHP accelerators
  24. Connect NAS to your Computer Directly
  25. Using NAS as your Database Server
  26. SugarForge
  27. Apache
  28. Apache: Apache MPM prefork
  29. PHP: PHP Manual: Appendices: php.ini directives: memory_limit
  30. PHP: PHP Manual: Appendices: php.ini directives
  31. AnandTech: Kingston SSDNow V+100 Review
  32. Trusted Review: OCZ Vertex 120GB SSD review
  33. Seagate Surveillance HDD
  34. Wiki: RAID 1
  35. Wiki: Session (computer science)
  36. Mozilla: Firefox
  37. Wiki: LAMP (software bundle)
  38. Wiki: Multi-core processor
  39. Wiki: Hyper-threading
  40. How Multi-Core Processors Accelerate your LAMP Applications
  41. memcached
  42. Optimize LAMP for SugarCRM

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s