- 博客(22)
- 收藏
- 关注
翻译 MySQL 8.0 配置InnoDB缓冲池大小
该 Innodb_buffer_pool_resize_status 变量报告一个字符串值,指示缓冲池大小调整进度;删除中的页面chunks(块大小由 定义 innodb_buffer_pool_chunk_size)添加页面chunks(块大小由 定义 innodb_buffer_pool_chunk_size)其中,只有对缓冲池进行碎片整理和撤回页面才允许其他线程并发访问缓冲池。调整大小操作由后台线程执行。当这些操作正在进行时,其他线程将被阻止访问缓冲池。转换哈希表、列表和指针以使用内存中的新地址。
2024-04-07 15:36:43 29 1
原创 linux虚拟机联网问题(三)--VMnet8
01.设置–>虚拟网络编辑器–>VMnet802.Win+R,打开运行,输入services.msc注意:查看VMware开头的服务,是否为正在运行,没有启动的启动即可03.虚拟机网卡–>网络连接–>选择VMnet8(NAT模式)04.虚拟机IP,网关配置注意:仅主机模式的网关不能修改,默认为xxx.xxx.xxx.2由于案例中的子网IP为192.168.148.0,故网关为192.168.148.2–第一步已修改网关为192.168.148.250# vi
2021-11-25 23:45:01 1136
原创 linux虚拟机联网问题(二)--VMnet1
01.设置–>虚拟网络编辑器–>VMnet102.Win+R,打开运行,输入services.msc注意:查看VMware开头的服务,是否为正在运行,没有启动的启动即可03.虚拟机网卡–>网络连接–>选择VMnet1(仅主机模式)04.虚拟机IP,网关配置注意:仅主机模式的网关不能修改,默认为xxx.xxx.xxx.2由于案例中的子网IP为10.10.10.0,故网关为10.10.10.2# vi /etc/sysconfig/network-scripts/i
2021-11-25 23:42:26 1194 1
原创 oracle相关资料整理
【安装部署】CentOS 6.5 静默安装Oracle11gR2数据库Oracle Linux 7.5安装oracle 12cR2数据库CentOS 6.8 安装Oracle11gR2 RAC数据库【基础概念】ORACLE集群概念和原理【Dataguard】Oracle11g 搭建DataGuard【OGG】
2021-11-24 13:11:21 697
原创 jdbc如何连接PDB
jdbc如何连接oracle 容器数据库(PDB)?//连接cdb和12c以下版本jdbc:oracle:thin:@192.168.1.82:1521:orcl//注:连接12c+版本的pdb需要把:改成/jdbc:oracle:thin:@192.168.1.82:1521/pdb
2021-11-09 22:42:01 954
原创 nginx代理转发mysql
环境描述:操作系统:Red Hat Enterprise Linux Server release 7.6 (Maipo)数据库:MySQL 5.7.22中间件:nginx 1.9.8IP地址:192.168.1.50–生产环境为公网,这里用内网IP代替实现目标:nginx代理mysql操作步骤:1.安装mysql相信大家都会,过程略2.编译安装nginx,这一步是关键2.1.下载并解压nginx安装包,这里使用 nginx 1.9.8cd /softtar zxvf nginx
2021-11-09 18:54:44 2237
原创 The innodb_system data file ‘./ibdata1‘ is of a different size 12800 pages
修改完my.cnf,mysql启动不了查看日志发现2021-11-09T05:16:20.814620Z mysqld_safe Logging to '/log/3306/db-error.err'.2021-11-09T05:16:20.861140Z mysqld_safe Starting mysqld daemon with databases from /mysql/data/3306/data2021-11-09T05:16:20.876861Z 0 [Warning] Could n
2021-11-09 13:31:39 1723
原创 Can‘t locate Email/Sender/Transport/SMTP/TLS.pm in @INC
【报错信息】perl -MEmail::Sender::Transport::SMTP::TLS -e "print\"module installed\n\""Can't locate Email/Sender/Transport/SMTP/TLS.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_pe
2021-11-08 12:08:57 208
转载 SLF4J: Found binding in
在运行sqlline.py,提示jar包冲突[hadoop@itpub81 ~]$ sqlline.py 192.168.1.91:2181......SLF4J: Class path contains multiple SLF4J bindings.SLF4J: Found binding in [jar:file:/data/phoenix-hbase-2.2-5.1.2-bin/phoenix-client-hbase-2.2-5.1.2.jar!/org/slf4j/impl/Static
2021-11-06 15:23:04 4243 2
原创 NotFoundException: org.apache.phoenix.jdbc.PhoenixDriver
[hadoop@itpub81 ~]$ sqlline.py 192.168.1.91:2181Setting property: [incremental, false]Setting property: [isolation, TRANSACTION_READ_COMMITTED]issuing: !connect jdbc:phoenix:192.168.1.91:2181 none none org.apache.phoenix.jdbc.PhoenixDriverConnecting to
2021-11-06 15:02:47 961
原创 如何在linux中获取进程名?
查看当前grid用户下的所有进程[root@racdb01 ~]# ps -ef |grep grid |grep -v greproot 24399 1 1 21:23 ? 00:00:03 /u01/app/11.2.0/grid/bin/ohasd.bin rebootgrid 24509 1 0 21:23 ? 00:00:01 /u01/app/11.2.0/grid/bin/oraagent.bingrid
2021-08-26 21:34:21 1241
原创 ORA-20011
Thu Jan 21 22:00:07 2021DBMS_STATS: GATHER_STATS_JOB encountered errors. Check the trace file.Errors in file /u01/app/oracle/diag/rdbms/esbdg/esb/trace/esb_j002_4027.trc:ORA-20011: Approximate NDV failed: ORA-29913: æ<89>§è¡<8c> ODCIEXTTABL
2021-01-22 10:59:15 243 1
原创 ORA-28003: password verification for the specified password failed
ERROR at line 1:ORA-28003: password verification for the specified password failedORA-20003: Password should contain at least one digit, one character and onepunctuation
2020-12-03 16:27:17 2363
原创 ORA-12012: error on auto execute of job “SYS“.“ORA$AT_OS_OPT_SY_32913“
今天早上,同事说连不上数据库,数据库版本18c,用的pdb,查看alter日志,一堆报错,摘了一段如下ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_32913"ORA-20001: Statistics Advisor: Invalid task name for the current userORA-06512: at "SYS.DBMS_STATS", line 49538ORA-06512: at "SYS
2020-11-30 10:33:48 307
原创 ORA-01565: error in identifying file ‘?/dbs/[email protected]‘
SQL> create pfile='/home/oracle/pfile_bup2_20201105.ora' from spfile;create pfile='/home/oracle/pfile_bup2_20201105.ora' from spfile*ERROR at line 1:ORA-01565: error in identifying file '?/dbs/[email protected]'ORA-27037: unable to obtain file statusLi.
2020-11-05 15:58:08 2641
翻译 ORA-02095: specified initialization parameter cannot be modified
SQL> alter system set sga_max_size=4G scope=both sid='*';alter system set sga_max_size=4G scope=both sid='*' *ERROR at line 1:ORA-02095: specified initialization parameter cannot be modified有些参数不能动态修改,需要使用alter system set paramet.
2020-11-05 10:49:55 2360
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人