![](https://img-blog.csdnimg.cn/20201014180756919.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Mysql
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 评论 -
Why the size of select is not so large but stuck at ‘sending data‘ status?
Symptom:Mysql Client want to fetch about 200 lines data from mysql server.From the mysql server end, it stuck at 'sending data' status for a long time.Solution:1. First, pls check the Netwerk IO and HW network status.-> low possibility2. Che原创 2021-11-24 11:00:16 · 495 阅读 · 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 评论 -
[ERROR] Failed to open log (file ‘/mysqllogs/logs/*****‘, errno 2)
Production:Mysql ServerSysptom:2021-11-18T02:41:00.473687Z 0 [Note] InnoDB: Buffer pool(s) load completed at 211118 10:41:00mysqld: File '/mysqllogs/logs/****' not found (Errcode: 2 - No such file or directory)2021-11-18T02:41:00.473953Z 0 [ERROR原创 2021-11-18 14:29:10 · 518 阅读 · 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 评论 -
Restart&Recovery Mysql after hit ‘missing MLOG_CHECKPOINT‘ error
1. shutdown the mysql service, make sure the service is not running2. backup the files in the data directory, you may just rename it and then create a new data directory3. You can find the data directory using the command below:select @@datadir;Or you原创 2021-10-12 13:03:08 · 69 阅读 · 0 评论 -
Mysql slave not synching with master
Got this case from "Duke University Health System, Inc"Sysmptom/IssueLast_Error: Could not execute Update_rows event on table redcap.redcap_data; Can't find record in 'redcap_data', Error_code: 1032; Can't find record in 'redcap_data', Error_code:原创 2021-09-27 15:33:06 · 72 阅读 · 0 评论 -
Mysql-Change Definer In Stored Procedure
Created from SR 3-7760169791 Applies to: MySQL Server - Version 5.0 and later Goal Change the definer of a stored procedure Solution It is possible to change the definer of a procedure by editing the mysql.proc table dir.原创 2021-08-24 16:19:25 · 86 阅读 · 0 评论