› MySQL 5.5 Community Server
› MySQL 5.6 Community Server
› Percona Configuration Wizard
› XtraBackup 搭建主从复制
Great Sites on MySQL
› Percona
› MySQL Performance Blog
› Severalnines
推荐管理工具
› Sequel Pro
› phpMyAdmin
推荐书目
› MySQL Cookbook
MySQL 相关项目
› MariaDB
› Drizzle
参考文档
› http://mysql-python.sourceforge.net/MySQLdb.html
tanteng
V2EX  ›  MySQL

数据库挂了,如何根据这些信息定位问题?

  •  
  •   tanteng ·
    tanteng · Apr 10, 2016 · 4458 views
    This topic created in 3840 days ago, the information mentioned may be changed or developed.

    打开网站,发现网站报错,提示数据库连接失败。

    打开阿里云,查看数据库服务状态,如下:

    Welcome to aliyun Elastic Compute Service!
    
    [root@iZ94r80gdghZ ~]# ls
    [root@iZ94r80gdghZ ~]# service mariadb status
    Redirecting to /bin/systemctl status  mariadb.service
    ● mariadb.service - MariaDB database server
       Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
      Drop-In: /etc/systemd/system/mariadb.service.d
               └─migrated-from-my.cnf-settings.conf
       Active: failed (Result: timeout) since 日 2016-04-10 19:32:47 CST; 2h 0min ago
      Process: 14771 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER (code=exited, status=0/SUCCESS)
     Main PID: 14771 (code=exited, status=0/SUCCESS)
       Status: "MariaDB server is down"
    
    4 月 10 19:32:46 iZ94r80gdghZ mysqld[14771]: 2016-04-10 19:32:46 14005736395....
    4 月 10 19:32:46 iZ94r80gdghZ mysqld[14771]: Version: '10.1.13-MariaDB'  soc...r
    4 月 10 19:32:46 iZ94r80gdghZ mysqld[14771]: 2016-04-10 19:32:46 14005736351...s
    4 月 10 19:32:46 iZ94r80gdghZ mysqld[14771]: 2016-04-10 19:32:46 14005658500....
    4 月 10 19:32:46 iZ94r80gdghZ mysqld[14771]: 2016-04-10 19:32:46 14005736351....
    4 月 10 19:32:47 iZ94r80gdghZ mysqld[14771]: 2016-04-10 19:32:47 14005736351...2
    4 月 10 19:32:47 iZ94r80gdghZ mysqld[14771]: 2016-04-10 19:32:47 14005736351...e
    4 月 10 19:32:47 iZ94r80gdghZ systemd[1]: Failed to start MariaDB database s....
    4 月 10 19:32:47 iZ94r80gdghZ systemd[1]: Unit mariadb.service entered faile....
    4 月 10 19:32:47 iZ94r80gdghZ systemd[1]: mariadb.service failed.
    

    那么根据如上提示怎么定位数据库出错原因呢?

    4 replies  •  2016-04-12 12:44:02 +08:00
    bdbai
        1
    bdbai  
       Apr 10, 2016 via Android
    systemctl status -l mariadb
    hcymk2
        2
    hcymk2  
       Apr 10, 2016
    应该有 error.log 或者 mysqld.log 吧。
    coagent
        3
    coagent  
       Apr 10, 2016
    是不是磁盘满了? df -h 看看结果
    aliyunservice
        4
    aliyunservice  
       Apr 12, 2016
    您好,建议您结合数据库和服务器的错误日志分析下,看下具体什么原因导致不能启动的,同时也看下服务器系统资源状态是否正常,如果还有问题可以通过在线工单或者微博 @阿里云客户满意中心联系我们核实。
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   5839 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 39ms · UTC 02:05 · PVG 10:05 · LAX 19:05 · JFK 22:05
    ♥ Do have faith in what you're doing.