MySQL管理 - 随笔分类 - HelonTian

MySQL安装过程报错处理

摘要：rhel8.10安装MySQL8.0.32， error while loading shared libraries: libncurses.so.5 $ mysql -uroot -p mysql: error while loading shared libraries: libncurses 阅读全文

posted @ 2025-01-24 13:44 HelonTian 阅读(52) 评论(0) 推荐(0)

【MySQL8.0.32安装】Windows Server2019安装MySQL8.0.32

摘要：安装包下载： https://downloads.mysql.com/archives/community/ 下载mysql-8.0.32-winx64.zip 1、制定目录配置 basedir=D:\\mysql8.0.32#mysql数据存放目录datadir=D:\\mysql8.0.32\\ 阅读全文

posted @ 2023-11-04 08:47 HelonTian 阅读(437) 评论(0) 推荐(0)

【MySQL日常管理】调整binlog和relaylog路径

摘要：迁移前的路径：binlog: /u01/mysql/logsrelaylog :/u01/mysql/logs 迁移的目标路径：binlog: /nasbackup/logsrelaylog :/nasbackup/logs 一、主库迁移binlog日志在可停库的场景下：1、首先停止mysql2、阅读全文

posted @ 2022-05-11 21:30 HelonTian 阅读(1681) 评论(0) 推荐(1)

【MySQL数据迁移】mydump&mydumper

摘要：mysqldump使用场景 1、导出表 mysqldump -u用户名 -p密码数据库名表名 > 表名.sql 备份单表：mysqldump -uroot -pdbpasswd dbname test1 > test1.sql 导出多张表: mysqldump -uroot -ppasswd - 阅读全文

posted @ 2022-05-05 20:35 HelonTian 阅读(225) 评论(0) 推荐(0)

MySQL技术内幕 SQL编程-逻辑查询处理

摘要：FROM： ON： JOIN： WHERE： GROUP BY： CUBE|ROLLUP 阅读全文

posted @ 2022-04-09 17:29 HelonTian 阅读(108) 评论(0) 推荐(0)

【MySQL Shell】MySQL Shell体验

摘要：二进制包下载：https://downloads.mysql.com/archives/shell/ Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select user,h 阅读全文

posted @ 2022-03-29 14:36 HelonTian 阅读(222) 评论(0) 推荐(0)

【MySQL8】参数文件my.cnf

摘要：[client]port = 3306socket = /u01/mysql_3306/tmp/mysql.sockmysqlx_socket = /data/mysql_3306/tmp/mysqlx.sock[mysql]#prompt="\u@mysql8 \R:\m:\s [\d]> "no 阅读全文

posted @ 2022-03-21 16:08 HelonTian 阅读(746) 评论(0) 推荐(0)

【MySQL8】ERROR 2059 (HY000): Authentication plugin 'caching_sha2_password' cannot be loaded:

摘要：mysql8.0.24初始化,并启动数据库实例之后，登录mysql shell提示报错 $ mysql -uroot -p'xxx' -S /data/mysql_3308/tmp/mysql.sockmysql: [Warning] Using a password on the command 阅读全文

posted @ 2022-03-21 15:51 HelonTian 阅读(588) 评论(0) 推荐(0)

【MySQL备份恢复】innobackupex 备份过程

摘要：# innobackupex --user=root --password="root" --socket=/home/mysql/run/mysql.sock /tmpxtrabackup: recognized server arguments: xtrabackup: recognized c 阅读全文

posted @ 2021-12-16 11:37 HelonTian 阅读(55) 评论(0) 推荐(0)

【MySQL管理】percona-toolkit工具

摘要：32个命令，可以分为7大类一、pt-query-digest分析慢日志 $ mysql -uadmin -p -S /u01/mysql/run/mysql.sock -BNe "show variables like 'long_query_time';"Enter password: long 阅读全文

posted @ 2021-12-08 15:37 HelonTian 阅读(60) 评论(0) 推荐(0)

【MySQL备份恢复】innobackupex使用过程报错

摘要：$ innobackupex --user=admin --password="xxxxxx" --socket=/u01/mysql/run/mysql.sock /data/backup/xtrabackup: recognized server arguments: --datadir=/va 阅读全文

posted @ 2021-12-06 10:50 HelonTian 阅读(2094) 评论(0) 推荐(0)

【MySQL管理】MySQL参数配置

摘要：[mysqld]#binlog configurationserver-id=1log-bin=/u01/mysql/logs/mysql-binbinlog_format=ROWbinlog_cache_size = 4Mmax_binlog_cache_size = 2Gmax_binlog_s 阅读全文

posted @ 2021-12-05 16:54 HelonTian 阅读(77) 评论(0) 推荐(0)

【MySQL备份恢复】mydumper使用说明

摘要：mydumper -u admin -p 'xxx' -h 127.0.0.1 -P 27415 -C -c --trx-consistency-only -t 10 -o /data/49backup.20211203/ myloader -t 15 -v 3 -C -o -u admin -p 阅读全文

posted @ 2021-12-05 16:36 HelonTian 阅读(43) 评论(0) 推荐(0)

【MySQL备份恢复】mydumper安装

摘要：# cat /etc/redhat-release Red Hat Enterprise Linux Server release 7.8 (Maipo) 安装MySQL数据库# yum install cmake[root@zedba mydumper-0.9.1]# cmake .-- The 阅读全文

posted @ 2021-12-05 16:33 HelonTian 阅读(331) 评论(0) 推荐(0)

【MySQL故障处理】[ERROR] Failed to open log (file '/data/mysql_3306/logs/mysql_bin.000012', errno 2)

摘要：【MySQL故障处理】[ERROR] Failed to open log (file '/data/mysql_3306/logs/mysql_bin.000012', errno 2)修改MySQL实例端口号3306到3307$ ll mysql_3306/total 4drwxrwxr-x 8 阅读全文

posted @ 2021-08-30 10:20 HelonTian 阅读(821) 评论(0) 推荐(0)

【MySQL集群MGR】MGR监控

摘要：Monitoring Group Replication https://dev.mysql.com/doc/refman/5.7/en/group-replication-monitoring.html Use the Perfomance Schema tables to monitor Gro 阅读全文

posted @ 2021-07-23 17:42 HelonTian 阅读(241) 评论(0) 推荐(0)

MySQL之MGR组件学习

摘要：1、The MySQL Group Replication plugin includes a set of APIs for capture, apply, and lifecycle, which control how the plugin interacts with MySQL Serve 阅读全文

posted @ 2021-07-22 17:01 HelonTian 阅读(69) 评论(0) 推荐(0)

MySQL体系架构

摘要：Innodb体系架构后台线程、内存池、数据文件阅读全文

posted @ 2021-06-12 08:51 HelonTian 阅读(39) 评论(0) 推荐(0)

centos7 systemctl 管理MySQL

摘要：[root@ze11 ~]# ll /usr/local/mysqllrwxrwxrwx. 1 mysql mysql 35 Dec 22 21:52 /usr/local/mysql -> mysql-5.7.25-linux-glibc2.12-x86_64[root@ze11 ~]# ps - 阅读全文

posted @ 2020-12-22 22:42 HelonTian 阅读(483) 评论(0) 推荐(0)

Docker部署MySQL

摘要：Docker安装MySQL os:CentOS7.3 一、安装docker Docker 要求 CentOS 系统的内核版本高于 3.10 ，查看本页面的前提条件来验证你的CentOS 版本是否支持 Docker 。# uname -r3.10.0-514.el7.x86_64 使用 root 权限阅读全文

posted @ 2018-12-27 10:17 HelonTian 阅读(244) 评论(0) 推荐(0)

随笔分类 - MySQL管理