I am getting an Issue after everey 2-3 minutes
mysql> show tables;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 57
I am really not able to find why it is happening. I saw to my error log it says
120419 0:36:03 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
InnoDB: Last MySQL binlog file position 0 93884, file name /EBSmnt/mysql/mysql-bin.000233
120419 0:36:04 InnoDB: Started; log sequence number 1692 2597076235
120419 0:36:04 [Note] Event Scheduler: Loaded 0 events
120419 0:36:04 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.43-enterprise-gpl-advanced-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Enterprise Server - Advanced Edition (G
Can Anybody please tell How to handle the Scenario.It is on one of the Production Server.
EDIT
RAM is of 7GB.
And InnoDB Configuration in my.cnf are
innodb_additional_mem_pool_size = 16M
innodb_buffer_pool_size = 3G
innodb_data_home_dir = /lvm/mysql
innodb_data_file_path = ibdata1:80G:autoextend
innodb_log_buffer_size = 8M
innodb_log_file_size = 1300M
innodb_log_files_in_group = 3
SHOW VARIABLES LIKE 'max_allowed_packet';