柳暗花明笔记

    mysql 查看版本的方式

    所属分类:[ php&web ] 猫哲学家 发表于:2016-09-29 10:38 浏览:247

    1.

    [lanmiz@rt-1ew5 http://lanmiz.beiliuhome.com/]# mysql -V
    mysql Ver 14.14 Distrib 5.6.33, for Linux (x86_64) using EditLine wrapper

    2.

    mysql> select version();
    +------------+
    | version() |
    +------------+
    | 5.6.33-log |
    +------------+
    1 row in set (0.00 sec)

    3.

    mysql> status;
    --------------
    mysql Ver 14.14 Distrib 5.5.42, for Linux (x86_64) using readline 5.1

    Connection id: 64
    Current database:
    Current user: lanmiz@beiliuhome.com
    SSL: Not in use
    Current pager: stdout
    Using outfile: ''
    Using delimiter: ;
    Server version: 5.5.42-log Source distribution
    Protocol version: 10
    Connection: Localhost via UNIX socket
    Server characterset: utf8
    Db characterset: utf8
    Client characterset: utf8
    Conn. characterset: utf8
    UNIX socket: /tmp/mysql.sock
    Uptime: 1 hour 45 min 30 sec

    Threads: 1 Questions: 2426 Slow queries: 0 Opens: 182 Flush tables: 1 Open tables: 64 Queries per second avg: 0.383

    标签: mysql 
    上一编文章 linux 统计文件行数 下一编文章 mysql 优化相关
    最近文章
    发表评论