![](https://img-blog.csdnimg.cn/20201014180756738.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Linux
文章平均质量分 62
qyt_2010
这个作者很懒,什么都没留下…
展开
-
Some lazy tips for Mysql about calculation
1.select * from information_schema.innodb_trx where TIME_TO_SEC(timediff(now(),trx_started))>60;-> can calculate the trx which exceed the indicated time(60s is from the example)(To Be Continued)原创 2022-01-13 09:39:57 · 262 阅读 · 0 评论 -
The difference between actual installed memory and the output from free command
Symptom:Why less memory is seen from the 'free' command output compared to what has been actually allocated to the server?Solution:Pls see the dmesg as bellowMemory: 131417224K/134082252K available (7571K kernel code, 1587K rwdata, 3900K rodata, 202原创 2021-12-08 10:47:27 · 115 阅读 · 0 评论 -
Mysql---terminate called after throwing an instance of ‘std::bad_alloc
Sysptom:InnoDB: page_cleaner: 1000ms intended loop took 7119ms. The settings might not be optimal. (flushed=208 and evicted=0, during the time.)InnoDB: page_cleaner: 1000ms intended loop took 10336ms. The settings might not be optimal. (flushed=208 and原创 2021-11-18 15:28:35 · 1007 阅读 · 0 评论 -
Recover Corrupted Root Partition from Rescue Mode
Issue:Recover the root partition, this is a critical issue.Solution:Checking all file systems.[/sbin/fsck.ext3 (1) -- /] fsck.ext3 -a /dev/VolGroup00/LogVol00/dev/VolGroup00/LogVol00 contains a file system with errors, check forced./dev/VolGroup原创 2021-11-18 09:06:30 · 60 阅读 · 0 评论 -
kernel: [ 3166.869181] EDAC MC2: 1 CE memory read error on CPU_SrcID#1_Ha#1_Chan#1_DIMM#0
Sysptom:Sun Nov 14 19:08:17 2021 ID ffff P1 ECC CE /SYS/MB/P1/D3, 1 errors on MC1-CH1, dimm 0, rank 0.Sun Nov 14 19:08:17 2021 ID ffff ******** Home Agent(HA1) Shadow Errors ********Sun Nov 14 19:15:08 2021 ID ffff P1 ECC CE /SYS/MB/P1/D3, 1 errors on.原创 2021-11-15 09:41:08 · 1878 阅读 · 0 评论 -
Server Crash with Error “sysrq: SysRq : Trigger a crash“
Linux Server crashed, We always need vmcore to do the further investigation.The vmcore file shows below;WARNING: kernel relocated [928MB]: patching 89859 gdb minimal_symbol valuesKERNEL: /share/linuxrpm/vmlinux_repo/64/4.14.35-1818.3.3.el7uek.x86原创 2021-10-20 11:03:23 · 834 阅读 · 0 评论 -
How to calculate the whole physical memory has been used by progress.
Goal:How to calculate the whole physical memory has been used by progress? In the other word, how to calculate the sum of whole progress used physical memory ?I got this SR or ticket from one customer and I would like to do it with the method bellow.原创 2021-10-19 18:19:41 · 51 阅读 · 0 评论 -
Is There a Way to Prevent MySQL From Crashing When There is No Memory Available
Sometimes Mysql service will be killed by OOM Killer for lack of memory.But unfortunately, there is no way to prevent the OOM killing the mysql.There is no way is to monitor the mysql time by time, and set alter to it.If it exceed the threshold, you原创 2021-10-15 12:24:42 · 66 阅读 · 0 评论 -
Some user use Tape driver to backup and server always crash
When the user is using tape device, always meet io high situation.So if you enable hung_task_panic, mean hung_task_panic=1, when the device time out, the server will be reboot for the time_outLike:[1817156.683888] INFO: task tldd:53185 blocked for mo原创 2021-10-12 16:31:34 · 132 阅读 · 0 评论 -
Server reboot by Oracle RMAN backup
우선 HW 상 확인되는대로 모두 정상입니다.==-bash-4.2$ less megacli64-FwTermLog.out | grep -i 'fatal'39_2 2021-08-30T03:44:27+09:00 clear "Check for configuration of DiskController is successful." >>> 관련된 disk controller fatal error 발견되지 않습니다...原创 2021-10-09 12:09:54 · 1005 阅读 · 0 评论 -
HBA card got the OCR - Online Controller reset
-- Server details;FRU Device Description : TOP_LEVEL_PROD (LUN 0, ID 250)Product Manufacturer : Oracle CorporationProduct Name : Exadata X8-2Product Part Number : Exadata X8-2Product Serial : AK00635988FRU Device Description : /SYS...原创 2021-10-01 10:12:14 · 669 阅读 · 0 评论 -
Exadata Storage Cell 로 부터 ONLINE 디스크를 교체할 때 ASM 에서 확인하여야 할 항목들
적용 대상:Oracle Exadata Storage Server Software - 버전 11.1.0.3.0 과(와) 그 후속Exadata Database Machine X2-2 Hardware - 버전 All Versions to All Versions [릴리즈 All Releases]Oracle Solaris on x86-64 (64-bit)Linux x86-64목적다양한 이유로 인하여 (예를 들어 미디어 오류 카운트 증가) 엑사데이터原创 2021-09-30 08:58:13 · 426 阅读 · 0 评论 -
Oracle Linux: How to Provide “sudo“ Access to non-root User for all Commands
Applies to:Linux OS - Version Oracle Linux 5.0 and laterLinux x86GoalThis document explains how to provide sudo access for non-root user for all commandsSolutionRun "visudo" and uncomment the following line (if commented): # %wheel ALL=(...原创 2021-08-25 14:13:08 · 54 阅读 · 0 评论