вот собвственно лог
130708 15:49:46 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130708 15:52:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130708 15:52:32 InnoDB: Initializing buffer pool, size = 512.0M
130708 15:52:32 InnoDB: Completed initialization of buffer pool
130708 15:52:33 InnoDB: Started; log sequence number 2 3973779094
130708 15:52:33 [Note] Event Scheduler: Loaded 0 events
130708 15:52:33 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69' socket: '/var/lib/mysqld/mysqld.sock' port: 3306 Source distribution
130708 23:58:17 mysqld_safe Number of processes running now: 0
130708 23:58:17 mysqld_safe mysqld restarted
130708 23:58:17 InnoDB: Initializing buffer pool, size = 512.0M
130708 23:58:17 InnoDB: Error: cannot allocate 536887296 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 5203168 bytes. Operating system errno: 12
InnoDB: Check if you should increase the swap file or
InnoDB: ulimits of your operating system.
InnoDB: On FreeBSD check you have compiled the OS with
InnoDB: a big enough maximum process size.
InnoDB: Note that in most 32-bit computers the process
InnoDB: memory space is limited to 2 GB or 4 GB.
InnoDB: We keep retrying the allocation for 60 seconds...
130708 23:59:18InnoDB: Fatal error: cannot allocate the memory for the buffer pool
130708 23:59:18 [ERROR] Plugin 'InnoDB' init function returned error.
130708 23:59:18 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130708 23:59:18 [ERROR] Unknown/unsupported table type: innodb
130708 23:59:18 [ERROR] Aborting
130708 23:59:18 [Note] /usr/libexec/mysqld: Shutdown complete
130708 23:59:18 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130709 08:46:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130709 8:46:37 InnoDB: Initializing buffer pool, size = 512.0M
130709 8:46:37 InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130709 8:46:37 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...
система по имее мощная
установлено на trueVDS 2.0mhz 2gb ОЗУ
есть подозрение что падение происходит в момент посещения ботами яндекса но хотелось бы не ограничивать яндекс
настройки my.cnf
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/lib/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
skip-external-locking
query_cache_size = 32M
table_cache = 4096
thread_cache_size = 32
max_heap_table_size = 32M
tmp_table_size = 32M
innodb_buffer_pool_size = 32M
innodb_flush_log_at_trx_commit = 2
innodb_log_file_size = 64M
innodb_flush_method = O_DIRECT
transaction-isolation = READ-COMMITTED
default-storage-engine = innodb
bind-address = 127.0.0.1
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
myisam-recover = BACKUP
expire_logs_days = 10
max_binlog_size = 100M
join_buffer_size = 2M
sort_buffer_size = 2M
character-set-server = utf8
collation-server = utf8_unicode_ci
init-connect = "SET NAMES utf8 COLLATE utf8_unicode_ci"
skip-character-set-client-handshake
innodb_file_per_table
max_connections = 150
подскажите куда копать???? падает с периодичностью 1 раз в 2-5 дней
ежедневное посещение пока маленькое до 100 чел/день
база данных большая - каталог около 200 тыс товаров
130708 15:49:46 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130708 15:52:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130708 15:52:32 InnoDB: Initializing buffer pool, size = 512.0M
130708 15:52:32 InnoDB: Completed initialization of buffer pool
130708 15:52:33 InnoDB: Started; log sequence number 2 3973779094
130708 15:52:33 [Note] Event Scheduler: Loaded 0 events
130708 15:52:33 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69' socket: '/var/lib/mysqld/mysqld.sock' port: 3306 Source distribution
130708 23:58:17 mysqld_safe Number of processes running now: 0
130708 23:58:17 mysqld_safe mysqld restarted
130708 23:58:17 InnoDB: Initializing buffer pool, size = 512.0M
130708 23:58:17 InnoDB: Error: cannot allocate 536887296 bytes of
InnoDB: memory with malloc! Total allocated memory
InnoDB: by InnoDB 5203168 bytes. Operating system errno: 12
InnoDB: Check if you should increase the swap file or
InnoDB: ulimits of your operating system.
InnoDB: On FreeBSD check you have compiled the OS with
InnoDB: a big enough maximum process size.
InnoDB: Note that in most 32-bit computers the process
InnoDB: memory space is limited to 2 GB or 4 GB.
InnoDB: We keep retrying the allocation for 60 seconds...
130708 23:59:18InnoDB: Fatal error: cannot allocate the memory for the buffer pool
130708 23:59:18 [ERROR] Plugin 'InnoDB' init function returned error.
130708 23:59:18 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130708 23:59:18 [ERROR] Unknown/unsupported table type: innodb
130708 23:59:18 [ERROR] Aborting
130708 23:59:18 [Note] /usr/libexec/mysqld: Shutdown complete
130708 23:59:18 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
130709 08:46:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
130709 8:46:37 InnoDB: Initializing buffer pool, size = 512.0M
130709 8:46:37 InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130709 8:46:37 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...
система по имее мощная
установлено на trueVDS 2.0mhz 2gb ОЗУ
есть подозрение что падение происходит в момент посещения ботами яндекса но хотелось бы не ограничивать яндекс
настройки my.cnf
[mysqld]
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/lib/mysqld/mysqld.sock
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
skip-external-locking
query_cache_size = 32M
table_cache = 4096
thread_cache_size = 32
max_heap_table_size = 32M
tmp_table_size = 32M
innodb_buffer_pool_size = 32M
innodb_flush_log_at_trx_commit = 2
innodb_log_file_size = 64M
innodb_flush_method = O_DIRECT
transaction-isolation = READ-COMMITTED
default-storage-engine = innodb
bind-address = 127.0.0.1
key_buffer = 16M
max_allowed_packet = 16M
thread_stack = 128K
myisam-recover = BACKUP
expire_logs_days = 10
max_binlog_size = 100M
join_buffer_size = 2M
sort_buffer_size = 2M
character-set-server = utf8
collation-server = utf8_unicode_ci
init-connect = "SET NAMES utf8 COLLATE utf8_unicode_ci"
skip-character-set-client-handshake
innodb_file_per_table
max_connections = 150
подскажите куда копать???? падает с периодичностью 1 раз в 2-5 дней
ежедневное посещение пока маленькое до 100 чел/день
база данных большая - каталог около 200 тыс товаров