MySQL Forums
Forum List  »  MySQL Administrator

help with my.cnf to support large number of connections
Posted by: Hargos R
Date: November 29, 2011 05:21AM

Hi,

We have a 32bit Red Hat Enterprise Linux Server release 5.4 (Linux 2.6.18-164.el5 #1 SMP Tue Aug 18 15:51:54 EDT 2009 i686 i686 i386 GNU/Linux)
with mysql-server 5.1.58. 4GB of RAM.

Only innodb tables.

We are thinking about 1000 connections. Each connection can be active 8 hours or more, running 8 insert per minute.


my.cnf:


[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-external-locking

key_buffer_size = 1M
max_allowed_packet = 16M
table_open_cache = 256
sort_buffer_size = 8M
read_buffer_size = 2M
read_rnd_buffer_size = 16M

innodb_buffer_pool_size = 500M
innodb_additional_mem_pool_size = 20M

innodb_log_file_size = 5M
innodb_log_buffer_size = 4M

max_connections = 1000

thread_concurrency = 8
thread_cache_size = 8

query_cache_size = 16M
query_cache_limit = 2M

log-bin=mysql-bin
binlog_format=mixed



Advice please.

Thanks.

Regards.

Options: ReplyQuote


Subject
Written By
Posted
help with my.cnf to support large number of connections
November 29, 2011 05:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.