Hi to all and sorry for my bad english!
I'm using Zencart 1.3.7 on a mysql-4.1.10 host.
On the zencart's index page, if i activate the new products box under admin->index listing (4 cols*4 rows) often i get an error like this:
2002 Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)
in:
[select products_type from zen_products where products_id = '313']
If i disable the 'new products' view in index, this no more happens!
Seems a problem related to mysql, but i can't figure it out.
Here's the 'my.cnf' file, on a VPS with 256mb RAM:
[mysqld]
#skip-locking
skip-innodb
query_cache_limit=1M
query_cache_size=16M
query_prealloc_size = 163840
query_alloc_block_size = 32768
tmp_table_size = 16M
max_heap_table_size = 64M
query_cache_type=1
max_connections=400
interactive_timeout=25
wait_timeout=1000
connect_timeout=10
thread_cache_size=286
key_buffer = 16M
join_buffer=1M
max_allowed_packet = 16M
table_cache = 1024
record_buffer=1M
sort_buffer_size = 2M
read_buffer_size = 1M
read_rnd_buffer_size = 524288
bulk_insert_buffer_size = 8M
net_buffer_length = 8K
max_connect_errors=10
# Prova numero di CPU's*2 per thread_concurrency
thread_concurrency=2
myisam_sort_buffer_size = 32M
server-id=1
set-variable = wait_timeout=60
log-slow-queries = /var/log/mysql/mysql-slow.log
long_query_time = 1
[safe_mysqld]
err-log=/var/log/mysqld.log
open_files_limit=8192
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
#safe-updates
[isamchk]
key_buffer = 32M
sort_buffer_size = 32M
read_buffer = 16M
write_buffer = 16M
[myisamchk]
key_buffer = 32M
sort_buffer_size = 32M
read_buffer = 16M
write_buffer = 16M
[mysqlhotcopy]
interactive-timeout
Tx in advance



