快速熟悉mysql新环境

最新推荐文章于 2023-04-11 18:22:15 发布

发歌的数据架构

最新推荐文章于 2023-04-11 18:22:15 发布

阅读量533

点赞数

分类专栏： mysql日常文章标签： mysql

本文链接：https://blog.csdn.net/u010522235/article/details/51841629

版权

mysql日常专栏收录该内容

12 篇文章 0 订阅

订阅专栏

1.初识单个mysql服务器

1.1 一个全新的Mysql环境，要基本了解mysql版本、os平台、字符集等信息

mysql> status

--------------

mysql Ver 14.14 Distrib 5.6.29-ndb-7.4.11, for Linux (x86_64) using EditLine wrapper

Connection id: 12

Current database: test

Current user: root@localhost

SSL: Not in use

Current pager: stdout

Using outfile: ''

Using delimiter: ;

Server version: 5.6.29-ndb-7.4.11-cluster-gpl MySQL Cluster Community Server (GPL)

Protocol version: 10

Connection: Localhost via UNIX socket

Server characterset: latin1

Db characterset: latin1

Client characterset: utf8

Conn. characterset: utf8

UNIX socket: /var/lib/mysql/mysql.sock

Uptime: 5 hours 31 min 56 sec

Threads: 2 Questions: 39 Slow queries: 0 Opens: 74 Flush tables: 2 Open tables: 7 Queries per second avg: 0.001

--------------

1.2 了解mysql支持哪些存储引擎

mysql> show engines;

+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

| ndbcluster | DEFAULT | Clustered, fault-tolerant tables | YES | NO | NO |

| CSV | YES | CSV storage engine | NO | NO | NO |

| PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |

| ndbinfo | YES | MySQL Cluster system information storage engine | NO | NO | NO |

| MRG_MYISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |

| MyISAM | YES | MyISAM storage engine | NO | NO | NO |

| ARCHIVE | YES | Archive storage engine | NO | NO | NO |

| InnoDB | YES | Supports transactions, row-level locking, and foreign keys | YES | YES | YES |

| BLACKHOLE | YES | /dev/null storage engine (anything you write to it disappears) | NO | NO | NO |

| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |

+--------------------+---------+----------------------------------------------------------------+--------------+------+------------+

11 rows in set (0.00 sec)

1.3 了解mysql安装了哪些插件

mysql> show plugins;

+----------------------------------+----------+--------------------+---------+---------+

+----------------------------------+----------+--------------------+---------+---------+

+----------------------------------+----------+--------------------+---------+---------+

45 rows in set (0.00 sec)

1.4 了解mysql是单机还是ndb集群

mysql> show variables like 'have_ndbcluster';

Empty set (0.00 sec)

1.5 了解是否配置REPLICATION

mysql> show slave status\G;

Empty set (0.00 sec)

ERROR:

No query specified

mysql> show master status\G

Empty set (0.00 sec)

本机是一个集群

1.6 查看Mysql的日志模式

mysql> show variables like 'log%';

+----------------------------------------+---------------------------+

| Variable_name | Value |

+----------------------------------------+---------------------------+

| log_bin | OFF |

| log_bin_basename | |

| log_bin_index | |

| log_bin_trust_function_creators | OFF |

| log_bin_use_v1_row_events | OFF |

| log_error | /var/mysql/log/mysqld.log |

| log_output | FILE |

| log_queries_not_using_indexes | OFF |

| log_slave_updates | OFF |

| log_slow_admin_statements | OFF |

| log_slow_slave_statements | OFF |

| log_throttle_queries_not_using_indexes | 0 |

| log_warnings | 1 |

+----------------------------------------+---------------------------+

13 rows in set (0.00 sec)

1.7 查看Mysql当前有哪些触发器和存储过程

mysql> show triggers;

Empty set (0.00 sec)

mysql> show procedure status;

Empty set (0.00 sec)

查看有分区的表

mysql> select TABLE_NAME from information_schema.PARTITIONS where PARTITION_NAME is not null;

+-----------------------+

| TABLE_NAME |

+-----------------------+

| ndb_apply_status |

| ndb_index_stat_head |

| ndb_index_stat_sample |

| fafa |

+-----------------------+

8 rows in set (0.05 sec)

1.8 有多少用户拥有超级权限,是否有密码为空（ROOT密码默认为空），密码为空马上处理

mysql> select * from information_schema.USER_PRIVILEGES where PRIVILEGE_TYPE='SUPER';

+--------------------+---------------+----------------+--------------+

+--------------------+---------------+----------------+--------------+

| 'root'@'localhost' | def | SUPER | YES |

| 'root'@'127.0.0.1' | def | SUPER | YES |

| 'root'@'::1' | def | SUPER | YES |

| 'root'@'%' | def | SUPER | YES |

+--------------------+---------------+----------------+--------------+

4 rows in set (0.00 sec)

mysql> select host,user,password from mysql.user where password='';

Empty set (0.00 sec)

这里没有密码为空的

1.9 查看数据的存放目录

mysql> show variables like '%datadir%';

+---------------+------------------+

| Variable_name | Value |

+---------------+------------------+

| datadir | /var/mysql/data/ |

+---------------+------------------+

1 row in set (0.00 sec)

1.10 查看重要的内存参数

mysql> show variables like 'innodb_buffer_pool_size%';

+-------------------------+-----------+

| Variable_name | Value |

+-------------------------+-----------+

| innodb_buffer_pool_size | 134217728 |

+-------------------------+-----------+

1 row in set (0.00 sec)

innodb_buffer_pool_size

innodb_log_file_size

innodb_log_buffer_size

innodb_log_files_in_group

max_connections

innodb_flush_log_trx_commit

innodb_max_dirty_pages_pct

innodb_flush_method

sync-binlog

1.11 执行一会show processlist，看看Mysql能有多少并发，一般都是什么sql。

mysql> show processlist;

+----+-------------+-----------+------+---------+------+-----------------------------------+------------------+

+----+-------------+-----------+------+---------+------+-----------------------------------+------------------+

+----+-------------+-----------+------+---------+------+-----------------------------------+------------------+

2 rows in set (0.00 sec)

1.12 更进一步,Mysql的备份方法和策略是什么？网络环境的配置是如何的？

1.13 跑几个性能分析报告，看看最近系统的运行状态如何，例如用mysqlreport。

1.14 查看机器型号

[ root@T2 ~]# yum install dmidecode

[ root@T2 ~]# dmidecode |grep "Product Name"

Product Name: KVM

1.15 查看cpu型号，及逻辑cpu数量

[root@T2 ~]# cat /proc/cpuinfo |grep name| cut -f2 -d: |uniq -c

2 QEMU Virtual CPU version (cpu64-rhel6)

1.16 查看内存大小，存储大小

[root@T2 ~]# free

total used free shared buffers cached

Mem: 3922572 3714640 207932 172 149372 1393384

-/+ buffers/cache: 2171884 1750688

Swap: 4194300 4412 4189888

[root@T2 ~]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/vda2 95G 5.1G 85G 6% /

tmpfs 1.9G 0 1.9G 0% /dev/shm

发歌的数据架构

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
快速熟悉mysql新环境

1.初识单个mysql服务器 1.1 一个全新的Mysql环境，要基本了解mysql版本、os平台、字符集等信息mysql> status--------------mysql Ver 14.14 Distrib 5.6.29-ndb-7.4.11, for Linux (x86_64) using EditLine wrapperConnection id
复制链接

扫一扫