Остановка сервиса mysqld. Причины?

Кто подскажет? вот сейчас снова служба остановилась и сайт упал

менять хостинг

какая виртуализация? на OpenVZ такое часто бывает, когда кончается реальная оперативка или файловые дескрипторы.

с сайта хостера инфа, возможно ли падение из-за нехватки ОЗУ?

форум с музыкой на сервере, возможно ли что из-за нагрузки пользователей при одновременном скачивании будет такой случаться?

SeaSoul, вы разделом ошиблись, вам сюда /ru/forum/development/servers-administration

если оперативки сильно не хватает - могут принудительно убиваться "ненужные" процессы, или же процессы сами падают изза нехватки памяти. вообще смотрите логи сервера, там все есть. в /var/log/daemon.log или же самом логе mysql

вот лог за вторую половину сегодняшнего дня, сервис падал 2 раза:

Jul 10 14:37:02 site_name named[936]: client 31.220.0.10#33333: query (cache) 'ripe.net/ANY/IN' denied

Jul 10 15:08:32 site_name mysqld_safe: Number of processes running now: 0

Jul 10 15:08:32 site_name mysqld_safe: mysqld restarted

Jul 10 15:08:36 site_name mysqld: 130710 15:08:36 [Note] Plugin 'FEDERATED' is disabled.

Jul 10 15:08:36 site_name mysqld: 130710 15:08:36  InnoDB: Initializing buffer pool, size = 8.0M

Jul 10 15:08:36 site_name mysqld: 130710 15:08:36  InnoDB: Completed initialization of buffer pool

Jul 10 15:08:39 site_name mysqld: InnoDB: Error: pthread_create returned 11

Jul 10 15:08:40 site_name mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended

Jul 10 15:52:43 site_name named[936]: client 192.69.90.2#49064: query (cache) 'mydnsscan.us/ANY/IN' denied

Jul 10 17:17:29 site_name named[936]: client 94.102.51.42#34391: query (cache) '1rip.com/A/IN' denied

Jul 10 17:24:21 site_name named[936]: client 89.248.172.6#57378: query (cache) '1rip.com/A/IN' denied

Jul 10 17:25:23 site_name named[936]: client 80.82.64.217#49714: query (cache) '1rip.com/A/IN' denied

Jul 10 17:52:56 site_name named[936]: client 93.174.93.175#33830: query (cache) '1rip.com/A/IN' denied

Jul 10 18:06:14 site_name named[936]: client 89.248.174.2#36081: query (cache) '1rip.com/A/IN' denied

Jul 10 18:16:25 site_name mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql

Jul 10 18:16:26 site_name mysqld: 130710 18:16:26 [Note] Plugin 'FEDERATED' is disabled.

Jul 10 18:16:26 site_name mysqld: 130710 18:16:26  InnoDB: Initializing buffer pool, size = 8.0M

Jul 10 18:16:26 site_name mysqld: 130710 18:16:26  InnoDB: Completed initialization of buffer pool

Jul 10 18:16:26 site_name mysqld: InnoDB: The log sequence number in ibdata files does not match

Jul 10 18:16:26 site_name mysqld: InnoDB: the log sequence number in the ib_logfiles!

Jul 10 18:16:26 site_name mysqld: 130710 18:16:26  InnoDB: Database was not shut down normally!

Jul 10 18:16:26 site_name mysqld: InnoDB: Starting crash recovery.

Jul 10 18:16:26 site_name mysqld: InnoDB: Reading tablespace information from the .ibd files...

Jul 10 18:16:26 site_name mysqld: InnoDB: Restoring possible half-written data pages from the doublewrite

Jul 10 18:16:26 site_name mysqld: InnoDB: buffer...

Jul 10 18:16:28 site_name mysqld: 130710 18:16:28  InnoDB: Started; log sequence number 0 600810600

Jul 10 18:16:28 site_name mysqld: 130710 18:16:28 [Note] Event Scheduler: Loaded 0 events

Jul 10 18:16:28 site_name mysqld: 130710 18:16:28 [Note] /usr/sbin/mysqld: ready for connections.

Jul 10 18:16:28 site_name mysqld: Version: '5.1.63-0+squeeze1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)

Jul 10 18:16:29 site_name /etc/mysql/debian-start[17058]: Upgrading MySQL tables if necessary.

Jul 10 18:16:30 site_name /etc/mysql/debian-start[17061]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored

Jul 10 18:16:30 site_name /etc/mysql/debian-start[17061]: Looking for 'mysql' as: /usr/bin/mysql

Jul 10 18:16:30 site_name /etc/mysql/debian-start[17061]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck

Jul 10 18:16:30 site_name /etc/mysql/debian-start[17061]: This installation of MySQL is already upgraded to 5.1.63, use --force if you still need to run mysql_upgrade

Jul 10 18:16:30 site_name /etc/mysql/debian-start[17074]: Checking for insecure root accounts.

Jul 10 18:16:30 site_name /etc/mysql/debian-start[17078]: Triggering myisam-recover for all MyISAM tables

Jul 10 18:16:35 site_name mysqld: 130710 18:16:35 [ERROR] /usr/sbin/mysqld: Table './Database/xf_session' is marked as crashed and should be repaired

Jul 10 18:16:35 site_name mysqld: 130710 18:16:35 [Warning] Checking table:   './Database/xf_session'

Jul 10 18:16:41 site_name mysqld: 130710 18:16:41 [ERROR] /usr/sbin/mysqld: Table './Database/xf_search_index' is marked as crashed and should be repaired

Jul 10 18:16:41 site_name mysqld: 130710 18:16:41 [Warning] Checking table:   './Database/xf_search_index'

Jul 10 18:18:01 site_name named[936]: client 94.102.51.226#38441: query (cache) '1rip.com/A/IN' denied

Jul 10 20:16:37 site_name mysqld_safe: Number of processes running now: 0

Jul 10 20:16:37 site_name mysqld_safe: mysqld restarted

Jul 10 20:17:03 site_name mysqld: 130710 20:17:01 [Note] Plugin 'FEDERATED' is disabled.

Jul 10 20:17:11 site_name mysqld: 130710 20:17:10  InnoDB: Initializing buffer pool, size = 8.0M

Jul 10 20:17:11 site_name mysqld: 130710 20:17:10  InnoDB: Completed initialization of buffer pool

Jul 10 20:17:11 site_name mysqld: InnoDB: Error: pthread_create returned 11

Jul 10 20:17:11 site_name mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended

Jul 10 21:39:50 site_name named[936]: client 80.82.64.205#40628: query (cache) '1rip.com/ANY/IN' denied

Jul 10 23:20:01 site_name named[936]: client 94.102.49.150#38553: query (cache) './ANY/IN' denied

Jul 10 23:37:28 site_name mysqld_safe: Starting mysqld daemon with databases from /var/lib/mysql

Jul 10 23:37:28 site_name mysqld: 130710 23:37:28 [Note] Plugin 'FEDERATED' is disabled.

Jul 10 23:37:28 site_name mysqld: 130710 23:37:28  InnoDB: Initializing buffer pool, size = 8.0M

Jul 10 23:37:28 site_name mysqld: 130710 23:37:28  InnoDB: Completed initialization of buffer pool

Jul 10 23:37:28 site_name mysqld: InnoDB: Log scan progressed past the checkpoint lsn 0 602140656

Jul 10 23:37:28 site_name mysqld: 130710 23:37:28  InnoDB: Database was not shut down normally!

Jul 10 23:37:28 site_name mysqld: InnoDB: Starting crash recovery.

Jul 10 23:37:28 site_name mysqld: InnoDB: Reading tablespace information from the .ibd files...

Jul 10 23:37:28 site_name mysqld: InnoDB: Restoring possible half-written data pages from the doublewrite

Jul 10 23:37:28 site_name mysqld: InnoDB: buffer...

Jul 10 23:37:29 site_name mysqld: InnoDB: Doing recovery: scanned up to log sequence number 0 602140892

Jul 10 23:37:29 site_name mysqld: 130710 23:37:29  InnoDB: Starting an apply batch of log records to the database...

Jul 10 23:37:29 site_name mysqld: InnoDB: Progress in percents: 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 

Jul 10 23:37:29 site_name mysqld: InnoDB: Apply batch completed

Jul 10 23:37:29 site_name mysqld: 130710 23:37:29  InnoDB: Started; log sequence number 0 602140892

Jul 10 23:37:29 site_name mysqld: 130710 23:37:29 [Note] Event Scheduler: Loaded 0 events

Jul 10 23:37:29 site_name mysqld: 130710 23:37:29 [Note] /usr/sbin/mysqld: ready for connections.

Jul 10 23:37:29 site_name mysqld: Version: '5.1.63-0+squeeze1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  (Debian)

Jul 10 23:37:30 site_name /etc/mysql/debian-start[3891]: Upgrading MySQL tables if necessary.

Jul 10 23:37:30 site_name /etc/mysql/debian-start[3894]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored

Jul 10 23:37:30 site_name /etc/mysql/debian-start[3894]: Looking for 'mysql' as: /usr/bin/mysql

Jul 10 23:37:30 site_name /etc/mysql/debian-start[3894]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck

Jul 10 23:37:30 site_name /etc/mysql/debian-start[3894]: This installation of MySQL is already upgraded to 5.1.63, use --force if you still need to run mysql_upgrade

Jul 10 23:37:30 site_name /etc/mysql/debian-start[3905]: Checking for insecure root accounts.

Jul 10 23:37:30 site_name /etc/mysql/debian-start[3909]: Triggering myisam-recover for all MyISAM tables

Jul 10 23:37:32 site_name mysqld: 130710 23:37:32 [ERROR] /usr/sbin/mysqld: Table './Database/xf_session' is marked as crashed and should be repaired

Jul 10 23:37:32 site_name mysqld: 130710 23:37:32 [Warning] Checking table:   './Database/xf_session'

А df -h что показывает? :)

Чаще всего банально из-за нехватки места mysql падает и не запускается.

FairyHosting.com, да, но тогда ТС не смог бы его запустить и вручную

Для начала бы нужно сделать mysql_upgrade, затем mysqlcheck -Aor

Если не падастанет падать, дальше изучать логи.