Mysql problems - Abort connections
Posted by: Ali Nebi
Date: March 26, 2008 10:52AM

Hi,

can i ask for little bit help and ideas what can i do in this situation. Today we get these messages:

080326 17:38:39 [Warning] Aborted connection 69 to db: 'dbname' user: 'user' host: 'hostname' (Got timeout reading communication packets)

i read the article for this error in mysql site and made some changes, but i still continue to get this error every 10 minutes.

This is the current configuration of mysql:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=0
# bind-address=127.0.0.1
max_connections=300
innodb_file_per_table
# Set buffer pool size to 50 - 80% of availiable memory.
innodb_buffer_pool_size=1500M
innodb_additional_mem_pool_size=10M
# Set the log file size to about 25% of the buffer pool size.
#innodb_log_file_size=5M
#innodb_log_buffer_size=1M
table_cache=1024
#sort_buffer_size=3M
query_cache_type=1
query_cache_limit=1M
query_cache_size=32M
net_read_timeout=120
# Network settings
max_connect_errors=30
max_allowed_packet=15M
connect_timeout=120
net_write_timeout=120
tmp_table_size=16M
# Logging.
log=/var/log/mysql/sql.log
log_warnings=2
#long_query_time=10
#log_slow_queries=/var/log/mysql/slow-queries.log
#log_queries_not_using_indexes=1
collation_server=utf8_unicode_ci
character_set_server=utf8

[mysql]
default-character-set=utf8

[mysqldump]
default-character-set=utf8

[mysql.server]
basedir=/var/lib

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

The site is located on a different server and on this server we have started only mysql server.

The system has 8 GB RAM and 2 CPU, both core duo. The OS is CentOS 5.1 and 2.6.18-53.1.14.el5 x86_64 x86_64.

also these are another avriables:

wait_timeout = 28800
the same for interactive_timeout.

What can i change to optimize this system and also to solve these problems?

We are using INNODB engine on this server and we have over 1 million records.

Thanks in advanced!

Options: ReplyQuote


Subject
Written By
Posted
Mysql problems - Abort connections
March 26, 2008 10:52AM


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.