mongo createUser
2024-07-25mongo createUser dropUser updateUser dropUser grantRolesToUser revokeRolesFromUser 阅读全文...
install mariadb 10.11 on rocky9
2024-07-251、清理旧版本mysql或者Mariadb 阅读全文...
galera cluster mariadb
2024-07-24galera为多主节点，并提供同步复制功能，不像master-slave异步有延迟 阅读全文...
mysqldump 设置导出字符集
2024-07-22default-character-set 阅读全文...
mysql information_schema tables update_time
2023-07-24mysql information_schema tables update_time 阅读全文...
discovery.seed_hosts
2023-07-18java.lang.IllegalArgumentException: unknown setting [discovery.zen.ping.unicast.hosts] please check that any required plugins are installed, or check the breaking changes documentation for removed settings 阅读全文...
purge_relay_logs
2023-07-121 [root@localhost ~]# yum -y install epel-release
[root@localhost ~]#yum install -y perl-DBD-MySQL perl-Config-Tiny perl-Log-Dispatch perl-Parallel-ForkManager perl-ExtUtils-CBuilder perl-ExtUtils-MakeMaker perl-CPAN 阅读全文...
mariadb vs mysql
2023-04-24Mariadb的10.6, 10.7, 10.8, 10.9, 10.10对应MySQL 8 阅读全文...
mongo查询某列
2022-07-06DBQuery.shellBatchSize = 300 阅读全文...
mongodb 6.0 增加密码认证
2022-06-19在启动认证前，先创建管理员用户，以防切换开启认证后无法登录；admin数据库创建需要的角色权限以方便对数据库进行管理，第一个创建的用户必须在admin库中创建。 阅读全文...
flashback table t1 to before drop;
2022-05-261、select 'drop table '||tname||';' from tab;
drop table t1;
2、flashback table t1 to before drop; 阅读全文...
mysql批量drop table
2021-12-07SELECT concat('DROP TABLE IF EXISTS ', table_name, ';') FROM information_schema.tables WHERE table_schema = 'dbdb'; 阅读全文...
阿里云oss云存储ossutil工具
2021-11-23ossfs挂载当磁盘rsync时候非常卡，替换ossutil工具 阅读全文...
alter index rebuild online
2021-11-06rebuild index online不阻塞DML操作，这是相对于rebuild index来说的，加上了online，只是在rebuild的期间不阻塞DML，但是在开始和结束阶段还是可能阻塞其他进程的DML的，系统负载飙升，甚至宕机。10G rebuild index online 会锁表 阅读全文...
oracle ALTER INDEX RENAME TO
2021-11-06ALTER INDEX [schema.]index RENAME TO