The resize2fs command fails to run on a 16TiB filesystem
The resize2fs command fails to run on a 16TiB filesystem Red Hat Enterprise Linux 5 x86_64 Symptoms resize2fs: File too large while trying to determine filesystem size 在准备扩容 ext3 文件系统时，resize2fs 命令执行报错，发现文件系统限制最大 16TB。 Cause 此为 resize2fs 程序 BUG，需要更新 e2fsprogs 软件包至 1.39-35 版本，具体请查看 RHBA-2013:0093。 Solution 由于用户不同意升级 e2fsprogs 软件包，无奈只能对 LV 进行收缩（此前 LV 已经扩容到了 36T），因为文件系统未扩容，所以无需对文件系统进行卸载、检查和缩容。 为防止意外发生，已让用户备份文件系统数据。 使用以下命令将 LV 收缩至 15TB： lvresize -L 15T /dev/newpacesvg/lvol0 # or use lvredu...
multipath
multipath Operating System - RHEL 8.7 ~]# rpm -qa | grep device-mapper~]# yum install device-mapper-multipath~]# mpathconf --enable~]# systemctl restart multipathd.service~]# systemctl status multipathd.service~]# systemctl enable multipathd.service~]# cat /etc/multipath/wwids/360060e802260b000504160b000000000/~]# cat > /etc/multipath.conf <<EOFdevices { device { vendor "HITACHI" product "^OPEN-" ...
Installing docker desktop on windows 11
Installing docker desktop on windows 11 Install Start-Process 'E:\Downloads\Docker Desktop Installer.exe' -Wait -ArgumentList 'install', '--accept-license', '--installation-dir="D:\Program Files\Docker"', '--wsl-default-data-root="D:\Program Files\Docker-data"' Migrate docker-desktop [deprecated] PS C:\Windows\system32> wsl -l -v NAME STATE VERSION* Ubuntu Running 2 docker-desktop-data Stopped 2 docker-desktop Sto...
Master-Slave Semisynchronous Replication on MySQL 5.7.13
Master-Slave Semisynchronous Replication on MySQL 5.7.13 Prerequisites 检查 have_dynamic_loading 系统变量值为 YES。 复制已经在正常运行。 不能配置多复制通道，半同步复制只能兼容默认的复制通道。 Procedure 检查动态加载插件要求。 mysql> show variables like 'have_dynamic_loading';+----------------------+-------+| Variable_name | Value |+----------------------+-------+| have_dynamic_loading | YES |+----------------------+-------+1 row in set (0.02 sec) 安装插件。 源端 mysql> INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';...
ERROR 1356
ERROR 1356 APPLIES TO: 5.7.x SYMPTOMS mysqldump 全备恢复后，无法查询 sys 库。 mysql> select * from sys.processlist; ERROR 1356 (HY000): View 'sys.processlist' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them CASE mysql> SELECT * FROM mysql.proc;Empty set (0.00 sec)mysql> SHOW PROCEDURE STATUS WHERE Db = 'sys';Empty set (0.00 sec)mysql> SHOW FUNCTION STATUS WHERE Db = 'sys';Empty set (0.00 sec) sys 库 functions 和 procedures 丢失了，mysq...
Master-Slave GTID Replication on MySQL 5.7.13
Master-Slave GTID Replication on MySQL 5.7.13 Architecture All database operations are copied to the master’s binary log. Salves connect to the master and asks for the data. The slave servers get the masters binary log. Slaves then apply the binary log to its realy log. The relay log is read by the SQL thread process and it applies all the operations/data to the slave’s database and its binary log. Setup on Master 配置主机名解析。 "/etc/hosts"172.17.0.3 38a497b84982 # master172.17.0.4 ...
ERROR 1396
ERROR 1396 APPLIES TO: mysql> show variables like '%version%'; +-------------------------+------------------------------+ | Variable_name | Value | +-------------------------+------------------------------+ | innodb_version | 5.7.13 | | protocol_version | 10 | | slave_type_conversions | | | tls_version | TLSv1,TLSv1.1 | | version ...
MySQL Database Performance Tuning
MySQL Database Performance Tuning Locks select * from information_schema.innodb_locks;select * from information_schema.innodb_lock_waits;select concat('KILL ',id,';') from information_schema.processlist where user='DBuser' and DB='app_dc';select * from information_schema.processlist where user='DBuser' and DB='app_dc'; Recreate Tables select table_rows,table_name,table_schema from information_schema.TABLES where table_name='XXX_COMMAND';use app_dc;create table XXX_COMMAND_new like XXX_COMM...
MySQL Database Inspection Commands
MySQL Database Inspection Commands
DellEMC Unity 380,480,680,880 Service Manual
DellEMC Unity 380,480,680,880 Service Manual DellEMC Unity/XT 380/F,480/F,680/F,880/F Port IP Username/Password Management dhcp admin/Password123# Maintenance 128.221.1.250-251/255.255.255.248 service/service Dynamic Pools a. Expand pool by a single drive unless crossing a Drive Partnership Group. b. The maximum number of drives contained within a drive partnership group is 64. Replacing a System Drive with traditional pools ・ Dell Unity_ With traditional pools, when a sys...
