Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > 现在遇到个情况~主从同步中 从库老是会有慢查询日志

现在遇到个情况~主从同步中 从库老是会有慢查询日志

WBOY
Release： 2016-06-23 14:02:38
Original
992 people have browsed it

在从库上

比方有1000个人 运行了这个程序

总会有那么几个 需要2秒运行时间 而 其他人都是秒杀..

请问 这类情况 大家遇到过吗

...

我也想过是不是当时并发执行其他程序 导致 那个时间段的 那么几个人 运行受到影响...

但是还是不怎么能接受...


回复讨论(解决方案)

这很正常 
有可能正在查询的时候系统比较繁忙 所以记录了
如果语句本身没问题 还是可以接受的

这很正常 
有可能正在查询的时候系统比较繁忙 所以记录了
如果语句本身没问题 还是可以接受的

我是无法接受 嘿嘿 后来多加服务器 对平凡处理表 单独处理..

Related labels：
现在遇到个情况~主从同步中 从库老是会有慢查询日志
source：php.cn
Previous article：这个webservice地址怎么调用？ Next article：网站更换的问题
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
3
2187
How to display the mobile version of Google Chrome Hello teacher, how can I change Google Chrome into a mobile version?
From 2024-04-23 00:22:19
0
11
2333
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1961
There is no output in the parent window document.onclick = function(){ window.opener.document.write('I am the output of the child ...
From 2024-04-18 23:52:34
0
1
1846
Where is the courseware about CSS mind mapping? Courseware
From 2024-04-16 10:10:18
0
0
1899
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template