MySQL Forums
Forum List  »  Italian

Mysql crash o normale amministrazione?
Posted by:
Date: November 01, 2012 10:17AM

Vi riporto di seguito le caratteristiche del mio VPS tiscali:
-Operating system Ubuntu Linux 10.04
-Webmin version 1.600
-Kernel and CPU Linux 2.6.18-194.26.1.el5.028stab079.2 on i686
-Processor information Quad-Core AMD Opteron(tm) Processor 8356, 2 cores
-CPU load averages 0.51 (1 min) 0.60 (5 mins) 0.56 (15 mins)
-CPU usage 2% user, 1% kernel, 0% IO, 97% idle
-Real memory 2 GB total, 241.89 MB used
-Local disk space 28.61 GB total, 17.12 GB used

Stamattina ho verificato se ci fossero dei problemi strani tracciati nei log. Riporto di seguito quanto trovato in ognuno.


In “Daemon.log” ho trovato “ripetutamente”(in ogni minuto) tracciati i seguenti errori:
Nov 1 10:20:01 vps1490 init: mysql main process (17888) killed by KILL signal
Nov 1 10:20:01 vps1490 init: mysql main process ended, respawning
Nov 1 10:20:03 vps1490 /etc/mysql/debian-start[19599]: Upgrading MySQL tables if necessary.
Nov 1 10:20:03 vps1490 /etc/mysql/debian-start[19624]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Nov 1 10:20:03 vps1490 /etc/mysql/debian-start[19624]: Looking for 'mysql' as: /usr/bin/mysql
Nov 1 10:20:03 vps1490 /etc/mysql/debian-start[19624]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Nov 1 10:20:03 vps1490 /etc/mysql/debian-start[19624]: This installation of MySQL is already upgraded to 5.1.41, use --force if you still need to run mysql_upgrade
Nov 1 10:20:03 vps1490 /etc/mysql/debian-start[19647]: Checking for insecure root accounts.
Nov 1 10:20:04 vps1490 /etc/mysql/debian-start[19664]: Triggering myisam-recover for all MyISAM tables


In “Mysql-err.log” ho trovato “ripetutamente”(in ogni minuto) tracciati i seguenti errori:
121101 10:26:01 [Note] Plugin 'FEDERATED' is disabled.
121101 10:26:01 [Note] Plugin 'InnoDB' is disabled.
121101 10:26:01 [Note] Event Scheduler: Loaded 0 events
121101 10:26:01 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.41-3ubuntu12.6-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu)
121101 10:26:01 [ERROR] /usr/sbin/mysqld: Table './shoponmyweb/disponib' is marked as crashed and should be repaired
121101 10:26:01 [Warning] Checking table: './shoponmyweb/disponib'


In “Mysql-slow-query.log” ho trovato “ripetutamente” tracciate le seguenti segnalazioni:
/usr/sbin/mysqld, Version: 5.1.41-3ubuntu12.6-log ((Ubuntu)). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument


In “syslog” ho trovato “ripetutamente”(in ogni minuto) tracciati i seguenti errori:
Nov 1 10:20:03 vps1490 /etc/mysql/debian-start[19599]: Upgrading MySQL tables if necessary.
Nov 1 10:20:03 vps1490 /etc/mysql/debian-start[19624]: /usr/bin/mysql_upgrade: the '--basedir' option is always ignored
Nov 1 10:20:03 vps1490 /etc/mysql/debian-start[19624]: Looking for 'mysql' as: /usr/bin/mysql
Nov 1 10:20:03 vps1490 /etc/mysql/debian-start[19624]: Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Nov 1 10:20:03 vps1490 /etc/mysql/debian-start[19624]: This installation of MySQL is already upgraded to 5.1.41, use --force if you still need to run mysql_upgrade
Nov 1 10:20:03 vps1490 /etc/mysql/debian-start[19647]: Checking for insecure root accounts.
Nov 1 10:20:04 vps1490 /etc/mysql/debian-start[19664]: Triggering myisam-recover for all MyISAM tables


Questo vuol dire che il database mysql crasha ripetutamente e si riavvia ogni minuto?
Come faccio a capire cos'è che va sistemato?
Per quanto riguarda il “repair” della tabella disponib, facendo il repair non riscontro alcun problema su quella tavola. L'unica cosa che ho trovato è la presenta di alcune slow-query su quella tavola nel relativo log.

La mia paura è che il db crashi in continuazione penalizzando poi l'accesso degli utenti e/o dei motori di ricerca

Attendo consigli.

Grazie.

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql crash o normale amministrazione?
2578
November 01, 2012 10:17AM


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.