【待反馈】mysql5.7的问题1

配置文件信息正确，服务器配置也都够用（16G）内存

站点运行一段时间就会出现“wordpress建立数据库连接时出错”

重启服务器会好一段时间,一天重挂掉个3、5次，求助运维大佬
JR]UA3UD96`P15C3J5NCXD7.png

宝塔用户_gcckhy · 发表于 2022-10-18 21:08:58

本帖最后由宝塔用户_gcckhy 于 2022-10-18 21:14 编辑

2022-10-18T12:28:55.936522Z 43 [ERROR] /www/server/mysql/bin/mysqld: Table './tumengcom/wp_options' is marked as crashed and should be repaired
2022-10-18T12:29:11.970590Z 62 [ERROR] /www/server/mysql/bin/mysqld: Table './tumengcom/wp_options' is marked as crashed and should be repaired
2022-10-18T12:29:11.997096Z 46 [Note] Found 705 of 707 rows when repairing './tumengcom/wp_options'
Status information:
Current dir: /www/server/data/
Running threads: 3 Stack size: 524288
Current locks:
lock: 0x2b52401b6810:
lock: 0x2b52401b9e30:
lock: 0x2b524c09df20:
lock: 0x2b524c0959c0:
lock: 0x2b524c08bc40:
lock: 0x2b524c088c40:
lock: 0x2b524c07a9d0:
lock: 0x2b524c073c40:
lock: 0x2b524c0211b0:
lock: 0x2b524c010410:
lock: 0x2b52440069f0:
lock: 0x2b524426bc30:
lock: 0x2b52445f8ac0:
lock: 0x2b52445e0c80:
lock: 0x2b52445d9c30:
lock: 0x2b52445d4bb0:
lock: 0x2b52445ceef0:
lock: 0x2b52445c01a0:
lock: 0x2b52445b4f20:
lock: 0x2b52445af410:
lock: 0x2b52445a8c50:
lock: 0x2b52445a1db0:
lock: 0x2b5244593320:
lock: 0x2b524458e610:
lock: 0x2b524417f950:
lock: 0x2b5244178af0:
lock: 0x2b5244171120:
lock: 0x2b524416b930:
lock: 0x2b52440e2050:
lock: 0x2b5240193530:
lock: 0x2b5234b19e70:
lock: 0x2b5234b712a0:
lock: 0x2b5234b623d0:
lock: 0x2b5234b5c590:
lock: 0x2b5234b53990:
lock: 0x2b5240148c30:
lock: 0x9d45bb0:
lock: 0x9cdb500:
lock: 0x9cbde30:
lock: 0x9cccfb0:
lock: 0x9cac1e0:
lock: 0x9ca57b0:
lock: 0x9c9dd60:
lock: 0x1de8460:
lock: 0x1deb800:
lock: 0x1deb720:
lock: 0x1deb640:
lock: 0x1deb560:
lock: 0x1deb480:
lock: 0x1deb3a0:
lock: 0x1deb2c0:
lock: 0x1deb1e0:
lock: 0x1deb100:
lock: 0x1debe20:
lock: 0x1de8380:
lock: 0x1dec6e0:
lock: 0x1dec600:
lock: 0x1dec520:
lock: 0x1dec440:
lock: 0x1dec360:
lock: 0x1dec280:
lock: 0x1dec1a0:
lock: 0x1dec0c0:
lock: 0x1de9ce0:
lock: 0x1deb8e0:
lock: 0x1dea140:
lock: 0x1dea060:
lock: 0x1de9f80:
lock: 0x1de9ea0:
lock: 0x1de9dc0:
lock: 0x1debfe0:
lock: 0x1debf00:
lock: 0x1dea5a0:
lock: 0x1dea4c0:
lock: 0x1dea3e0:
lock: 0x1dea760:
lock: 0x1de7ac0:
lock: 0x1debd40:
lock: 0x1de8b60:
lock: 0x1de88c0:
lock: 0x1de8a80:
lock: 0x1de87e0:
lock: 0x1de89a0:
lock: 0x1de9180:
lock: 0x1de9260:
lock: 0x1de9340:
lock: 0x1de82a0:
lock: 0x1de81c0:
lock: 0x1de8700:
lock: 0x1de80e0:
lock: 0x1de8620:
lock: 0x1de8000:
lock: 0x1de8540:
lock: 0x1de8ee0:
lock: 0x1de8fc0:
lock: 0x1de90a0:
lock: 0x1de7f20:
lock: 0x1de7c80:
lock: 0x1de7e40:
lock: 0x1de7ba0:
Key caches:
default
Buffer_size: 1073741824
Block_size: 1024
Division_limit: 100
Age_limit: 300
blocks used: 57914
not flushed: 0
w_requests: 685
writes: 683
r_requests: 4681815
reads: 173743
handler status:
read_key: 5343984
read_next: 8281215
read_rnd 681643
read_first: 825
write: 2860189
delete 29
update: 1921
Table status:
Opened tables: 633
Open tables: 409
Open files: 360
Open streams: 0
Memory status:
<malloc version="1">
<heap nr="0">
<sizes>
<size from="17" to="32" total="64" count="2"/>
<size from="33" to="48" total="144" count="3"/>
<size from="97" to="97" total="3201" count="33"/>
<size from="113" to="113" total="3729" count="33"/>
<size from="193" to="193" total="193" count="1"/>
<size from="225" to="225" total="450" count="2"/>
<size from="241" to="241" total="241" count="1"/>
<size from="609" to="609" total="609" count="1"/>
<size from="6881" to="6881" total="6881" count="1"/>
<size from="16369" to="16369" total="49107" count="3"/>
<size from="16433" to="16433" total="16433" count="1"/>
<size from="24529" to="24529" total="98116" count="4"/>
<size from="32689" to="32689" total="32689" count="1"/>
<unsorted from="65" to="65" total="65" count="1"/>
</sizes>
<total type="fast" count="5" size="208"/>
<total type="rest" count="82" size="211714"/>
<system type="current" size="122257408"/>
<system type="max" size="122257408"/>
<aspace type="total" size="122257408"/>
<aspace type="mprotect" size="122257408"/>
</heap>
<heap nr="1">
<sizes>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="0" size="0"/>
<system type="current" size="364544"/>
<system type="max" size="364544"/>
<aspace type="total" size="364544"/>
<aspace type="mprotect" size="364544"/>
</heap>
<heap nr="2">
<sizes>
<size from="81" to="96" total="192" count="2"/>
<size from="33" to="33" total="33" count="1"/>
<size from="65" to="65" total="195" count="3"/>
<size from="113" to="113" total="113" count="1"/>
<size from="273" to="273" total="273" count="1"/>
<size from="289" to="289" total="578" count="2"/>
<size from="593" to="593" total="593" count="1"/>
<size from="625" to="625" total="625" count="1"/>
<size from="737" to="737" total="737" count="1"/>
<size from="913" to="913" total="913" count="1"/>
<size from="929" to="929" total="1858" count="2"/>
<size from="1009" to="1009" total="2018" count="2"/>
<size from="1025" to="1025" total="1025" count="1"/>
<size from="1153" to="1201" total="2354" count="2"/>
<size from="1345" to="1345" total="1345" count="1"/>
<size from="8209" to="8209" total="8209" count="1"/>
<size from="180721" to="180721" total="180721" count="1"/>
<unsorted from="8209" to="8209" total="8209" count="1"/>
</sizes>
<total type="fast" count="2" size="192"/>
<total type="rest" count="23" size="209799"/>
<system type="current" size="18067456"/>
<system type="max" size="18067456"/>
<aspace type="total" size="18067456"/>
<aspace type="mprotect" size="18067456"/>
</heap>
<heap nr="3">
<sizes>
<size from="49" to="64" total="64" count="1"/>
<size from="81" to="96" total="288" count="3"/>
<size from="33" to="33" total="33" count="1"/>
<size from="273" to="273" total="273" count="1"/>
<size from="353" to="353" total="353" count="1"/>
<size from="385" to="385" total="385" count="1"/>
<size from="449" to="449" total="449" count="1"/>
<size from="481" to="481" total="481" count="1"/>
<size from="721" to="721" total="721" count="1"/>
<size from="769" to="769" total="769" count="1"/>
<size from="929" to="929" total="929" count="1"/>
<size from="977" to="977" total="977" count="1"/>
<size from="1025" to="1025" total="2050" count="2"/>
<unsorted from="49" to="40497" total="67896" count="8"/>
</sizes>
<total type="fast" count="4" size="352"/>
<total type="rest" count="20" size="75316"/>
<system type="current" size="18542592"/>
<system type="max" size="18542592"/>
<aspace type="total" size="18542592"/>
<aspace type="mprotect" size="18542592"/>
</heap>
<heap nr="4">
<sizes>
<size from="33" to="48" total="240" count="5"/>
<size from="49" to="64" total="192" count="3"/>
<size from="113" to="128" total="128" count="1"/>
<size from="129" to="129" total="129" count="1"/>
<size from="145" to="145" total="145" count="1"/>
<size from="289" to="289" total="289" count="1"/>
<size from="305" to="305" total="305" count="1"/>
<size from="401" to="401" total="401" count="1"/>
<size from="417" to="417" total="834" count="2"/>
<size from="433" to="433" total="1299" count="3"/>
<size from="497" to="497" total="497" count="1"/>
<size from="529" to="529" total="529" count="1"/>
<size from="561" to="561" total="1122" count="2"/>
<size from="609" to="609" total="1827" count="3"/>
<size from="641" to="641" total="1923" count="3"/>
<size from="657" to="657" total="657" count="1"/>
<size from="689" to="689" total="689" count="1"/>
<size from="705" to="705" total="1410" count="2"/>
<size from="737" to="737" total="737" count="1"/>
<size from="769" to="769" total="769" count="1"/>
<size from="785" to="785" total="785" count="1"/>
<size from="801" to="801" total="1602" count="2"/>
<size from="817" to="817" total="1634" count="2"/>
<size from="833" to="833" total="833" count="1"/>
<size from="849" to="849" total="849" count="1"/>
<size from="865" to="865" total="1730" count="2"/>
<size from="881" to="881" total="1762" count="2"/>
<size from="897" to="897" total="1794" count="2"/>
<size from="913" to="913" total="913" count="1"/>
<size from="929" to="929" total="1858" count="2"/>
<size from="945" to="945" total="945" count="1"/>
<size from="977" to="977" total="977" count="1"/>
<size from="993" to="993" total="993" count="1"/>
<size from="2113" to="2113" total="2113" count="1"/>
<size from="5873" to="5873" total="5873" count="1"/>
<size from="55153" to="56161" total="111314" count="2"/>
<size from="100641" to="100641" total="100641" count="1"/>
<size from="3250625" to="3250625" total="3250625" count="1"/>
<unsorted from="33" to="262193" total="465711" count="47"/>
</sizes>
<total type="fast" count="9" size="560"/>
<total type="rest" count="98" size="3966514"/>
<system type="current" size="23040000"/>
<system type="max" size="23040000"/>
<aspace type="total" size="23040000"/>
<aspace type="mprotect" size="23040000"/>
</heap>
<heap nr="5">
<sizes>
<size from="81" to="96" total="192" count="2"/>
<size from="49" to="49" total="98" count="2"/>
<size from="65" to="65" total="325" count="5"/>
<size from="97" to="97" total="97" count="1"/>
<size from="129" to="129" total="129" count="1"/>
<size from="257" to="257" total="257" count="1"/>
<size from="289" to="289" total="289" count="1"/>
<size from="385" to="385" total="385" count="1"/>
<size from="449" to="449" total="898" count="2"/>
<size from="465" to="465" total="1395" count="3"/>
<size from="513" to="513" total="2052" count="4"/>
<size from="529" to="529" total="529" count="1"/>
<size from="561" to="561" total="2805" count="5"/>
<size from="577" to="577" total="1154" count="2"/>
<size from="593" to="593" total="1186" count="2"/>
<size from="609" to="609" total="1218" count="2"/>
<size from="625" to="625" total="625" count="1"/>
<size from="641" to="641" total="1923" count="3"/>
<size from="657" to="657" total="2628" count="4"/>
<size from="673" to="673" total="673" count="1"/>
<size from="721" to="721" total="721" count="1"/>
<size from="753" to="753" total="3012" count="4"/>
<size from="769" to="769" total="769" count="1"/>
<size from="785" to="785" total="1570" count="2"/>
<size from="817" to="817" total="817" count="1"/>
<size from="833" to="833" total="2499" count="3"/>
<size from="849" to="849" total="849" count="1"/>
<size from="865" to="865" total="865" count="1"/>
<size from="897" to="897" total="897" count="1"/>
<size from="913" to="913" total="1826" count="2"/>
<size from="929" to="929" total="3716" count="4"/>
<size from="945" to="945" total="945" count="1"/>
<size from="977" to="977" total="977" count="1"/>
<size from="1025" to="1025" total="1025" count="1"/>
<size from="1201" to="1201" total="3603" count="3"/>
<size from="20881" to="20881" total="20881" count="1"/>
<size from="32817" to="32817" total="32817" count="1"/>
<size from="54209" to="61857" total="290133" count="5"/>
<size from="67537" to="91761" total="328324" count="4"/>
<size from="127633" to="127633" total="127633" count="1"/>
<size from="147377" to="149009" total="296386" count="2"/>
<unsorted from="9425" to="9425" total="9425" count="1"/>
</sizes>
<total type="fast" count="2" size="192"/>
<total type="rest" count="84" size="1148356"/>
<system type="current" size="19714048"/>
<system type="max" size="19714048"/>
<aspace type="total" size="19714048"/>
<aspace type="mprotect" size="19714048"/>
</heap>
<heap nr="6">
<sizes>
<size from="33" to="48" total="48" count="1"/>
</sizes>
<total type="fast" count="1" size="48"/>
<total type="rest" count="0" size="0"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<heap nr="7">
<sizes>
<size from="33" to="48" total="48" count="1"/>
</sizes>
<total type="fast" count="1" size="48"/>
<total type="rest" count="0" size="0"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<heap nr="8">
<sizes>
<size from="33" to="48" total="48" count="1"/>
<size from="49" to="64" total="256" count="4"/>
<size from="113" to="128" total="128" count="1"/>
<size from="417" to="417" total="417" count="1"/>
<size from="433" to="433" total="433" count="1"/>
<size from="449" to="449" total="898" count="2"/>
<size from="465" to="465" total="465" count="1"/>
<size from="497" to="497" total="994" count="2"/>
<size from="577" to="577" total="577" count="1"/>
<size from="609" to="609" total="609" count="1"/>
<size from="625" to="625" total="625" count="1"/>
<size from="657" to="657" total="1971" count="3"/>
<size from="753" to="753" total="753" count="1"/>
<size from="769" to="769" total="769" count="1"/>
<size from="865" to="865" total="865" count="1"/>
<size from="881" to="881" total="881" count="1"/>
<size from="897" to="897" total="897" count="1"/>
<size from="913" to="913" total="913" count="1"/>
<size from="929" to="929" total="929" count="1"/>
<size from="945" to="945" total="945" count="1"/>
<size from="961" to="961" total="961" count="1"/>
<size from="977" to="977" total="1954" count="2"/>
<size from="1025" to="1025" total="1025" count="1"/>
<size from="18817" to="18817" total="18817" count="1"/>
<unsorted from="33" to="119185" total="188911" count="47"/>
</sizes>
<total type="fast" count="6" size="432"/>
<total type="rest" count="73" size="225609"/>
<system type="current" size="41517056"/>
<system type="max" size="41517056"/>
<aspace type="total" size="41517056"/>
<aspace type="mprotect" size="41517056"/>
</heap>
<heap nr="9">
<sizes>
<unsorted from="497" to="497" total="497" count="1"/>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="1" size="497"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<heap nr="10">
<sizes>
<size from="113" to="113" total="113" count="1"/>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="1" size="113"/>
<system type="current" size="147456"/>
<system type="max" size="147456"/>
<aspace type="total" size="147456"/>
<aspace type="mprotect" size="147456"/>
</heap>
<heap nr="11">
<sizes>
<size from="113" to="113" total="113" count="1"/>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="1" size="113"/>
<system type="current" size="147456"/>
<system type="max" size="147456"/>
<aspace type="total" size="147456"/>
<aspace type="mprotect" size="147456"/>
</heap>
<heap nr="12">
<sizes>
<size from="113" to="113" total="113" count="1"/>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="1" size="113"/>
<system type="current" size="147456"/>
<system type="max" size="147456"/>
<aspace type="total" size="147456"/>
<aspace type="mprotect" size="147456"/>
</heap>
<heap nr="13">
<sizes>
<size from="113" to="113" total="113" count="1"/>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="1" size="113"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<heap nr="14">
<sizes>
</sizes>
<total type="fast" count="0" size="0"/>
<total type="rest" count="0" size="0"/>
<system type="current" size="135168"/>
<system type="max" size="135168"/>
<aspace type="total" size="135168"/>
<aspace type="mprotect" size="135168"/>
</heap>
<total type="fast" count="30" size="2032"/>
<total type="rest" count="385" size="5838257"/>
<total type="mmap" count="83" size="2017091584"/>
<system type="current" size="244621312"/>
<system type="max" size="244621312"/>
<aspace type="total" size="244621312"/>
<aspace type="mprotect" size="244621312"/>
</malloc>
Events status:
LLA = Last Locked At LUA = Last Unlocked At
WOC = Waiting On Condition DL = Data Locked
Event scheduler status:
State : INITIALIZED
Thread id : 0
LLA : n/a:0
LUA : n/a:0
WOC : NO
Workers : 0
Executed : 0
Data locked: NO
Event queue status:
Element count : 0
Data locked : NO
Attempting lock : NO
LLA : init_queue:103
LUA : init_queue:111
WOC : NO
Next activation : never

复制代码

南南呦 · 发表于 2022-10-18 21:27:09

您好！服务器命令行执行以下命令查看MySQL错误日志, 截图看一下结果

cat /www/server/data/*.err|grep -i -C 10 error

复制代码

█菠萝云买2送1活动！12G内存99元	阿里云国际低折扣多云自助平台	APP分发-无行业限制免审核	A4招租，联系qq394030111	A5招租，联系qq394030111
高防服务器，无视一切流量攻击	【阿里云】宝塔一键部署，低至5折	A8招租，联系qq394030111	【阿里云】宝塔一键部署，低至5折	OV/EV SSL证书，可当日签发
█ 易探云·香港/美国vps仅9元 █	▶CPS云◀海外大带宽vps服务器	OV/EV SSL证书，可当日签发	【云防护】专注域名和网站安全防护	A15招租，联系qq394030111