vtiger

[pnagendra79]

Dear vTiger Team,

We are using vTigerCRM 5.0.2 Version. Since 2 months onwards CRM became very slow. We are not able to find the solution. We are using only 5 modules. Since our server has high configuration we are still facing problem. Please help me on this issue. How to make it faster.

Currently We have Record Statistics as follows:


Leads: 866
Acounts: 20,437
Contacts: 16648
Trouble Tickets: 1,51,227
Potentials: 19,766


My Server Details are as follows:

Generic Details
Canonical Hostname CRMUN
Listening IP XXX.XX.XX.X
Kernel Version 5.2.3790 SP2
OS/ Distribution Microsoft(R) Windows(R) Server 2003, Enterprise Edition
Server uptime 9 hours 55 minutes
Current Users N.A.
Load Averages 2 0 0 0




Server Memory
Type Percent Capacity Free Used Size
Hardware Memory (RAM) 18% 3.29 GB 729.54 MB 4.00 GB
Disk Swap 2% 1.97 GB 25.00 MB 2.00 GB


Server Drives and Volumes
Mount/Drive Type Partition Percent Capacity Free Used Size
A: Removeable Disk (3 1/2 in.) 0% 0.00 KB 0.00 KB 0.00 KB
C: FAT32 Local Disk 44% 11.08 GB 8.45 GB 19.52 GB
D: Compact Disc 0% 0.00 KB 0.00 KB 0.00 KB
E: NTFS Local Disk 1% 126.26 GB 69.40 MB 126.33 GB
F: NTFS Local Disk 25% 147.29 GB 48.03 GB 195.32 GB
Totals : 17% 284.63 GB 56.54 GB 341.17 GB




Hardware Information
Processors 4
Model Intel(R) Xeon(TM) CPU 3.20GHz
CPU Speed 3.19 GHz
BUS Speed 800 MHz
Cache Size 1024
PCI Devices - Intel(R) E7520 Memory Controller Hub - 3590
- Intel(R) E7525/E7520/E7320 PCI Express Root Port A0 - 3595
- Intel(R) 80332 PCI Express-to-PCI Bridge A - 0330
- DELL PERC 4e/Di RAID Controller
- Intel(R) 80332 PCI Express-to-PCI Bridge B - 0332
- Intel(R) E7525/E7520 PCI Express Root Port B0 - 3597
- Intel(R) E7520 PCI Express Root Port B1 - 3598
- (2x) Intel(R) 6700PXH PCI Express-to-PCI Bridge A - 0329
- Intel(R) PRO/1000 MT Network Connection #2
- (2x) Intel(R) 6700PXH PCI Express-to-PCI Bridge B - 032A
- Intel(R) PRO/1000 MT Network Connection
- Intel(R) E7520 PCI Express Root Port C0 - 3599
- Intel(R) 82801EB USB Universal Host Controller - 24D2
- Intel(R) 82801EB USB Universal Host Controller - 24D4
- Intel(R) 82801EB USB Universal Host Controller - 24D7
- Intel(R) 82801EB USB2 Enhanced Host Controller - 24DD
- Intel(R) 82801 PCI Bridge - 244E
- RADEON 7000 SERIES
- Intel(R) 82801EB LPC Interface Controller - 24D0
- Intel(R) 82801EB Ultra ATA Storage Controllers

IDE Devices - 0: HL-DT-ST DVD-ROM GDR8082N

SCSI Devices - P (Capacity: 0.00 KB)
- D (Capacity: 0.00 KB)
- P (Capacity: 0.00 KB)

USB Devices - (4x) USB Root Hub
- Generic USB Hub


Thanks & Regards,
P.Nagendra.

[snoopyski]

Hello P.Nagendra

Did you change any things on the network since you see the slowest speed of vTiger ?

See a list of things to do...

-Check network settings (DNS settings, Network Interface Optimization)
-All server app's UP2DATE (drivers, controlers, etc)
-HUB or Switch ??? (do you use 10/100 Switch) switch is better then a HUB
-Think about implementing a PHP accelerator ?
-Do you use RAID systems ? Yes, check your drive status... I get a speed problem in the past on a server... With bad hard drive in a RAID...

You use 4GB of RAM that's seem to be good...
So the other things is on the vTiger dev's team !!!

Thanks,

Snoopyski

[jagi]

Look on problem in mySql. In my vT 5.02 or 4.x was this kind of problem and I find bug with reading special sign from dB ( I don't remember what sign , now ).
I suggest upgrade to vT 5.03 (or 5.04 soon ) - have some dB reading corrections.
You can try dB all data export, cleaning data in dB and import back - be careful - You have big dB - make backup. ( repair tables not solve problem in my case )

[jamesmoey]

Hi,

You need to go through a list of possible bottleneck elimination. Listed a sample list below.

- Network?
- Machine?
- Apache?
- PHP configuration
- Database?

I suspect is the database, because of your big DB. mySQL by default set min memory, hence less performance. To see how much memory the Database is using just goto Task Manager and check it out.

You need to config mySQL to use the maximum memory. This will allow it to cache most of data and query. So that it does not have to do a search in the DATAFILE on disk again. You will need to config mySQL setting. Goto http://dev.mysql.com/doc/ for more information on that topic.

It might be PHP/Apache, you might have turn on all the PHP error reporting function or you have not configure enough Apache thread/process.

If you could not figure it out, I can help you figure your machine, also give you advice on the machine setup and etc. But I do charge a fee.

Good luck.
James

[mcloide]

I'm running 70000 accounts in a local developer machine with a 1/4 of what you got in a windows environment with php/mysql and apache running together (AppServ bundle).
I believe that your bottleneck is on the database and you can actually improve some performance (major ones) by creating indexes on the main tables. Use common searchable fields to create the indexes. Fields such as phone, part of the name (you don't need to create an index for a full name), email, the known ids, etc.
If that does not work, check for:
* Vtiger settings
* PHP settings
* MySQL settings
* network bottleneck
* Hard drive issues
I really don't belive that your hard drive is your issue, but....

[jagi]

My mySql config (my.ini)
Code:
[mysqld]
basedir=C:\programy\VertrigoServ\Mysql\
datadir=C:\programy\VertrigoServ\Mysql\data\
port      = 3306
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 2M
net_buffer_length = 16K
read_buffer_size = 512K
read_rnd_buffer_size = 512K

character-set-server=utf8
collation-server=utf8_polish_ci
default-character-set=utf8
init-connect=SET NAMES utf8

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout
[WinMySQLadmin]
Server=C:\programy\VertrigoServ\Mysql\bin\mysqld.exe


link Tuning Server Parameters: http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html

PHP (php.ini)
Code:
;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;

max_execution_time = 30     
; Maximum execution time of each script, in seconds
max_input_time = 120   
; Maximum amount of time each script may spend parsing request data
memory_limit = 32M     
; Maximum amount of memory a script may consume (8MB)

[jamesmoey]

key_buffer = 20M
sort_buffer_size = 20M

are good start.

vTiger CRM use innodb type database a lot. There are some configuration that you can do on that too.

[jamesmoey]

I mean innodb table.

[pnagendra79]

Dear Jagi,

I did the same what you game me. But it is still slow.. Plz help me.

jagi wrote: My mySql config (my.ini)
Code:
[mysqld]
basedir=C:\programy\VertrigoServ\Mysql\
datadir=C:\programy\VertrigoServ\Mysql\data\
port      = 3306
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 2M
net_buffer_length = 16K
read_buffer_size = 512K
read_rnd_buffer_size = 512K

character-set-server=utf8
collation-server=utf8_polish_ci
default-character-set=utf8
init-connect=SET NAMES utf8

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout
[WinMySQLadmin]
Server=C:\programy\VertrigoServ\Mysql\bin\mysqld.exe


link Tuning Server Parameters: http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html

PHP (php.ini)
Code:
;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;

max_execution_time = 30     
; Maximum execution time of each script, in seconds
max_input_time = 120   
; Maximum amount of time each script may spend parsing request data
memory_limit = 32M     
; Maximum amount of memory a script may consume (8MB)

[pnagendra79]

Dear Jagi,

I did the same what you game me. But it is still slow.. Plz help me.

jagi wrote: My mySql config (my.ini)
Code:
[mysqld]
basedir=C:\programy\VertrigoServ\Mysql\
datadir=C:\programy\VertrigoServ\Mysql\data\
port      = 3306
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 2M
net_buffer_length = 16K
read_buffer_size = 512K
read_rnd_buffer_size = 512K

character-set-server=utf8
collation-server=utf8_polish_ci
default-character-set=utf8
init-connect=SET NAMES utf8

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 20M
sort_buffer_size = 20M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout
[WinMySQLadmin]
Server=C:\programy\VertrigoServ\Mysql\bin\mysqld.exe


link Tuning Server Parameters: http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html

PHP (php.ini)
Code:
;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;

max_execution_time = 30     
; Maximum execution time of each script, in seconds
max_input_time = 120   
; Maximum amount of time each script may spend parsing request data
memory_limit = 32M     
; Maximum amount of memory a script may consume (8MB)