本帖最后由 堡塔运维小林 于 2023-10-20 10:37 编辑
为了能快速了解并处理您的问题,请提供以下基础信息: 问题描述:我早上发现我的MYSQL暂停了,看了一下慢日志发现如下问题,是不是被人黑进来了?请问我要怎么办、 相关截图(日志、错误):Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id Command Argument /www/server/mysql/bin/mysqld, Version: 5.7.40-log (Source distribution). started with: Tcp port: 3306 Unix socket: /tmp/mysql.sock Time Id Command Argument # Time: 2023-10-20T00:43:06.469850Z # User@Host: www_xxxxx_com[www_xxxxx_com] @ localhost [] Id: 7 # Query_time: 30.694488 Lock_time: 10.899507 Rows_sent: 0 Rows_examined: 0 use www_jixedu_com; SET timestamp=1697762586; SELECT option_value FROM wp_options WHERE option_name = 'classic-editor-allow-users' LIMIT 1; # Time: 2023-10-20T00:44:14.129416Z # User@Host: www_xxxxxxxx_com[www_jxxxxxxx_com] @ localhost [] Id: 5 # Query_time: 109.576924 Lock_time: 0.000081 Rows_sent: 7 Rows_examined: 150832 SET timestamp=1697762654; SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND wp_posts.ID NOT IN (xxxxxxxxx) AND ( wp_term_relationships.term_taxonomy_id IN (2) ) AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish'))) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 7; # Time: 2023-10-20T00:44:20.099733Z # User@Host: www_xxxxxx_com[www_xxxxxxx_com] @ localhost [] Id: 9 # Query_time: 5.667417 Lock_time: 0.000243 Rows_sent: 0 Rows_examined: 39569 SET timestamp=1697762660; SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND ((wp_posts.post_title LIKE '%太原同城外围上门%') AND (wp_posts.post_title LIKE '%(微信xxxxxxxx%') AND (wp_posts.post_title LIKE '%电v同步xxxxxx)真实上门服务支持视频认证太原同城外围上门%') AND (wp_posts.post_title LIKE '%(微信xxxxxxxxx%') AND (wp_posts.post_title LIKE '%电v同步xxxxxxxxx)真实上门服务支持视频认证.9%')) AND (wp_posts.post_password = '') AND ((wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'page' AND (wp_posts.post_status = 'publish')) OR (wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'publish'))) ORDER BY (CASE WHEN wp_posts.post_title LIKE '%太原同城外围上门 (微信xxxxxxxx)真实上门服务支持视频认证太原同城外围上门 (微信xxxxxxxxx 电v同步xxxxxxxxx)真实上门服务支持视频认证.9%' THEN 1 WHEN wp_posts.post_title LIKE '%太原同城外围上门%' AND wp_posts.post_title LIKE '%(微信xxxxxxxxxxxxx%' AND wp_posts.post_title LIKE '%电v同步xxxxxxxxxx)真实上门服务支持视频认证太原同城外围上门%' AND wp_posts.post_title LIKE '%(微信xxxxxxxxxxx%' AND wp_posts.post_title LIKE '%电v同步xxxxxxxxxx)真实上门服务支持视频认证.9%' THEN 2 WHEN wp_posts.post_title LIKE '%太原同城外围上门%' OR wp_posts.post_title LIKE '%(微信xxxxxxxxxxx%' OR wp_posts.post_title LIKE '%电v同步xxxxxxxxxxx)真实上门服务支持视频认证太原同城外围上门%' OR wp_posts.post_title LIKE '%(微信xxxxxxxxxxx%' OR wp_posts.post_title LIKE '%电v同步xxxxxxxxxxx)真实上门服务支持视频认证.9%' THEN 3 WHEN wp_posts.post_excerpt LIKE '%太原同城外围上门 (微信xxxxxxxxx 电v同步xxxxxxx)真实上门服务支持视频认证太原同城外围上门 (微信xxxxxxxxxx电v同步xxxxxxxxxxx)真实上门服务支持视频认证.9%' THEN 4 WHEN wp_posts.post_content LIKE '%太原同城外围上门 (微信xxxxxxxxxx 电v同步xxxxxxxxxxx)真实上门服务支持视频认证太原同城外围上门 (微信xxxxxxxx电v同步xxxxxxxx)真实上门服务支持视频认证.9%' THEN 5 ELSE 6 END), wp_posts.post_date DESC
|
|