This documentation relates to CiviCRM version 3.2. It's not maintained anymore.
Current version of documentation.

Speeding up Mysql

Aller directement à la fin des métadonnées
Aller au début des métadonnées

This page refers to outdated version of CiviCRM. Check current version of documentation.


Documentation Search


CiviCRM 3.2 Documentation

Support and Participation

Developer Resources


CiviCRM book!

Make sure to check out Understanding CiviCRM as well! You can also support this project by ordering a hard copy.

There numerous ways to speed up the database one way is just to optimize the my.cnf file.

If you have access to this file here are some key areas I found to speed up Civi. I especially have seen huge improvements in Importing Contacts.

For example we have three servers that are all the same specs 

Intel(R) Core(TM)2 CPU          6600  @ 2.40GHz

2 gigs of memory and standard sata drives (one may be NCQ for multi processing)

But out of the box the settings for in this case Ubuntu was somewhat slow. We installed CentOS on the third server 

and it came out of the box a bit faster but not perfect either.

They all now benefit from this mysql setup as well as additions to php settings.

in ubuntu or debian /etc/mysql/my.cnf

in centos /etc/my.cnf

key_buffer = 64M

key_buffer_size = 32M

thread_cache_size = 64

query_cache_limit = 8M

query_cache_size = 64M

query_cache_type = 1

join_buffer_size 512K

max_connections = 150

long_query_time = 5

log-slow-queries = /var/log/mysql/mysql-slow.log

Étiquette
  • Aucun

Creative Commons License
Except where otherwise noted, content on this site is licensed under a Creative Commons Attribution-Share Alike 3.0 United States Licence.