Magento Forum

Search Indexing Issue on large store…
 
Vishal Kapadia
Jr. Member
 
Total Posts:  6
Joined:  2011-03-16
 

Hello,

I have a site with more then 1,20,000 products and the search indexes are showing just processing all the time and left with the error like “MySQL server has gone Away” or “Can’t connect to MySQL”.

Following is the configuration of my server. Can anyone please help me that if it is a sufficient configuration or not or do I need to upgrade my server configuration?

CENTOS 6.3 x86_64 standard – ip-184-168-67-122
WHM 11.34.0 (build 9)
Load Averages: 0.47 0.27 0.83

Operating System: CentOS 6 x64
Processor : Intel Core i5 - 3.10 GHz
RAM : 4 GB
Total Disk Space: 600 GB
RAID: None

Disk Drive(s):
300 GB (Drive #1)
300 GB (Drive #2)

Bandwidth Quota: 10000 GB
Quota Used: 48 GB
Firewall: None
Control Panel Type: cPanel (license enabled)

Following is the My.cnf file.

[mysqld]
innodb_file_per_table
=1
#innodb settings
innodb_additional_mem_pool_size=16M
innodb_flush_log_at_trx_commit
=2
innodb_lock_wait_timeout
=1800
innodb_buffer_pool_size
=2G

#other vars
net_read_timeout=120
skip
-external-locking
skip
-name-resolve
table_cache
=1024
thread_cache_size
=16
back_log
=100
max_connect_errors
=10000
open
-files-limit=20000
interactive_timeout
=3600
wait_timeout
=1800
max_connections
=100
key_buffer
=1024M
connect_timeout
=120
log_slow_queries
=/var/lib/mysql/slow.log

#skip-name-resolve
#skip-innob
max_allowed_packet=16M
tmp_table_size
=64M
max_heap_table_size
=64M
query_cache_size
=32M
query_cache_type
=1
query_cache_limit
=2048M
sort_buffer_size
=1M
read_buffer_size
=1M
[size=3]

Please let me know if you have a better configuration example for the larger stores.

Thank You,[/size]

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top