Проблемы с мусколом в Ubuntu Server 12.04

[aqis]

dpkg-reconfigure mysql-server пробовал?

[AnrDaemon]

С какой целью? Просто лишь бы попробовать?

[anytup]

все переустановил, проблема повторяется.

Код: [Выделить]

syslog | grep mysql
Apr 19 11:49:45 mysite mysqld_safe[27994]: 140419 11:49:45 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Apr 19 11:49:46 mysite mysqld_safe[27994]: 140419 11:49:46 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Apr 19 11:49:46 mysite mysqld_safe[27994]:
Apr 19 11:49:46 mysite mysqld_safe[27994]: PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
Apr 19 11:49:46 mysite mysqld_safe[27994]: To do so, start the server, then issue the following commands:
Apr 19 11:49:46 mysite mysqld_safe[27994]:
Apr 19 11:49:46 mysite mysqld_safe[27994]: /usr/bin/mysqladmin -u root password 'new-password'
Apr 19 11:49:46 mysite mysqld_safe[27994]: /usr/bin/mysqladmin -u root -h mysite password 'new-password'
Apr 19 11:49:46 mysite mysqld_safe[27994]:
Apr 19 11:49:46 mysite mysqld_safe[27994]: Alternatively you can run:
Apr 19 11:49:46 mysite mysqld_safe[27994]: /usr/bin/mysql_secure_installation
Apr 19 11:49:46 mysite mysqld_safe[27994]:
Apr 19 11:49:46 mysite mysqld_safe[27994]: which will also give you the option of removing the test
Apr 19 11:49:46 mysite mysqld_safe[27994]: databases and anonymous user created by default.  This is
Apr 19 11:49:46 mysite mysqld_safe[27994]: strongly recommended for production servers.
Apr 19 11:49:46 mysite mysqld_safe[27994]:
Apr 19 11:49:46 mysite mysqld_safe[27994]: See the manual for more instructions.
Apr 19 11:49:46 mysite mysqld_safe[27994]:
Apr 19 11:49:46 mysite mysqld_safe[27994]: Please report any problems with the /usr/scripts/mysqlbug script!
Apr 19 11:49:46 mysite mysqld_safe[27994]:
Apr 19 11:49:46 mysite mysqld_safe[28041]: 140419 11:49:46 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Apr 19 11:49:50 mysite mysqld_safe[28084]: 140419 11:49:50 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Apr 19 11:49:51 mysite mysqld_safe[28105]: 140419 11:49:51 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Apr 19 11:49:53 mysite mysqld_safe[28126]: 140419 11:49:53 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
Apr 19 11:49:57 mysite /etc/mysql/debian-start[28240]: Upgrading MySQL tables if necessary.
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: Looking for 'mysql' as: /usr/bin/mysql
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' '--host=localhost' '--socket=/var/run/mysqld/mysqld.sock' '--host=localhost' '--socket=/var/run/mysqld/mysqld.sock'
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: Running 'mysqlcheck' with connection arguments: '--port=3306' '--socket=/var/run/mysqld/mysqld.sock' '--host=localhost' '--socket=/var/run/mysqld/mysqld.sock' '--host=localhost' '--socket=/var/run/mysqld/mysqld.sock'
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.columns_priv                                 OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.db                                           OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.event                                        OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.func                                         OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.general_log                                  OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.help_category                                OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.help_keyword                                 OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.help_relation                                OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.help_topic                                   OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.host                                         OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.ndb_binlog_index                             OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.plugin                                       OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.proc                                         OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.procs_priv                                   OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.proxies_priv                                 OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.servers                                      OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.slow_log                                     OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.tables_priv                                  OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.time_zone                                    OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.time_zone_leap_second                        OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.time_zone_name                               OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.time_zone_transition                         OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.time_zone_transition_type                    OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: mysql.user                                         OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: Running 'mysql_fix_privilege_tables'...
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28243]: OK
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28277]: Checking for insecure root accounts.
Apr 19 11:49:59 mysite /etc/mysql/debian-start[28282]: Triggering myisam-recover for all MyISAM tables
Apr 19 11:58:12 mysite /etc/mysql/debian-start[4427]: Upgrading MySQL tables if necessary.
Apr 19 11:58:12 mysite /etc/mysql/debian-start[4430]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Apr 19 11:58:12 mysite /etc/mysql/debian-start[4430]: Looking for 'mysql' as: /usr/bin/mysql
Apr 19 11:58:12 mysite /etc/mysql/debian-start[4430]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Apr 19 11:58:12 mysite /etc/mysql/debian-start[4430]: This installation of MySQL is already upgraded to 5.5.35, use --force if you still need to run mysql_upgrade
Apr 19 11:58:12 mysite /etc/mysql/debian-start[4441]: Checking for insecure root accounts.
Apr 19 11:58:12 mysite /etc/mysql/debian-start[4446]: Triggering myisam-recover for all MyISAM tables
Apr 19 12:48:07 mysite /etc/mysql/debian-start[661]: Upgrading MySQL tables if necessary.
Apr 19 12:48:07 mysite /etc/mysql/debian-start[664]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Apr 19 12:48:07 mysite /etc/mysql/debian-start[664]: Looking for 'mysql' as: /usr/bin/mysql
Apr 19 12:48:07 mysite /etc/mysql/debian-start[664]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Apr 19 12:48:07 mysite /etc/mysql/debian-start[664]: This installation of MySQL is already upgraded to 5.5.35, use --force if you still need to run mysql_upgrade
Apr 19 12:48:07 mysite /etc/mysql/debian-start[675]: Checking for insecure root accounts.
Apr 19 12:48:07 mysite /etc/mysql/debian-start[680]: Triggering myisam-recover for all MyISAM tables

Код: [Выделить]

dmesg | grep mysql
[10087383.288730] Out of memory in UB 10653821: OOM killed process 482 (mysqld) score 0 vm:785456kB, rss:41464kB, swap:0kB
[10087383.627404] Out of memory in UB 10653821: OOM killed process 1680 (mysqld) score 0 vm:447140kB, rss:37932kB, swap:0kB
[10087383.805987] Out of memory in UB 10653821: OOM killed process 1728 (mysqld) score 0 vm:408216kB, rss:37828kB, swap:0kB
[10087959.425814] Out of memory in UB 10653821: OOM killed process 1846 (mysqld) score 0 vm:308552kB, rss:20036kB, swap:0kB
[10087959.511292] Out of memory in UB 10653821: OOM killed process 1870 (mysqld) score 0 vm:308552kB, rss:20148kB, swap:0kB
[10087959.601398] Out of memory in UB 10653821: OOM killed process 1894 (mysqld) score 0 vm:308552kB, rss:20132kB, swap:0kB
Говорите, если я что-то не так делаю

Что самое интересное, у меня на компе все пашет. Код один и тот же. Софт тоже.

[AnrDaemon]

http://translate.google.com/
http://translate.yandex.ru/
если сами не в состоянии перевести сообщение "out of memory" в понятные образы.

[anytup]

еще вчера это понял, не надо столько экспрессии

[Archil]

Подобная ситуация была только  что, одним словом помогло удалить и потом установить MySQL.
Потом выкидывало  ошибку при установке типа:

(Нажмите, чтобы показать/скрыть)

Errors were encountered while processing:
 /var/cache/apt/archives/mysql-server-5.5_5.5.43-
0ubuntu0.14.04.1_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

Я расстроился, ведь  ошибка то анальная, но  потом тупо  удалил то  что  по идее мешало.

Код: [Выделить]

sudo rm /var/cache/apt/archives/mysql-server-5.5_5.5.43-0ubuntu0.14.04.1_amd64.debА потом дернул  еще раз  с -f
Лично  у меня потом всё стало  хорошо...