[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_66":67,"_68":-5,"_69":70,"_71":25,"_72":31,"_73":31},"routes/article.$id",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5,"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":25,"_30":31,"_32":33,"_34":35},"id",365,"user",{"_9":49,"_50":51,"_52":21,"_53":21,"_54":21,"_55":-5,"_56":25,"_24":25,"_57":25,"_58":25,"_59":25,"_60":25,"_40":25,"_61":21,"_48":62,"_27":63,"_64":31,"_65":31},"tags",[44],"title","SQLyog、Navicat保持与MySQL的心跳","summary","用MySQL的小伙伴常用的工具SQLyog、Navicat 这两个工具，会发现如果一段时间不使用再次查询的情况下回很慢。因此可以使用心跳机制保证客户端跟MySQL服务器链接。 SQLyog Navicat","cover","sourceUrl","","viewCount",214,"commentCount",0,"likeCount","createTime",1516266832000,"status","favorited",false,"content","

\n
用MySQL的小伙伴常用的工具SQLyog、Navicat 这两个工具，会发现如果一段时间不使用再次查询的情况下回很慢。因此可以使用心跳机制保证客户端跟MySQL服务器链接。
\n

SQLyog

$\"SQLyog保持心跳\"$

Navicat

$\"Navicat保持心跳\"$

\n","toc",[36,37],{"_9":42,"_15":43,"_40":41},{"_9":38,"_15":39,"_40":41},"topic-heading-navicat","Navicat","level",4,"topic-heading-sqlyog","SQLyog",{"_9":45,"_46":47,"_48":21},12,"name","MySQL","description","KkQASP8fTCC","nickname","匿名用户157","avatar","smallAvatar","gender","birthday","topicCount","fansCount","followCount","score","exp","levelTitle","这家伙很懒，什么都没留下",1789024623810,"forbidden","followed","config",{"_74":31,"_75":76,"_77":78,"_79":31,"_80":31,"_81":31,"_82":83,"_84":25,"_85":31,"_86":87,"_88":89,"_90":87,"_91":70,"_92":93,"_94":95,"_96":25,"_97":25,"_98":31,"_99":-5,"_100":101,"_102":103,"_104":105,"_106":107,"_108":109,"_110":111,"_112":21,"_113":114,"_115":10,"_116":87,"_117":118,"_119":31,"_120":31,"_121":25,"_122":123},"currentUser","locale","zh-CN","unreadMessageCount","websiteHost","websiteNav","articlePending","attachmentConfig",{"_153":87,"_203":204,"_205":206,"_207":208},"baseURL","https://www.studyjava.cn","createArticleEmailVerified","createCommentEmailVerified","createTopicEmailVerified","defaultCategoryId",1,"emailNoticeIntervalSeconds","enableHideContent","enableQaBounty",true,"footerLinks",[181,182,183,184],"installed","language","loginConfig",{"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":-5},"modules",{"_164":87,"_165":87,"_166":87,"_167":87},"qaBountyMax","qaBountyMin","qaBountyRequired","recommendTags","scriptInjections",[152],"siteDescription","StudyJava 专注 Java 学习与进阶，提供 Java 基础、Spring Boot、微服务、数据库、面试题等系统教程与实战案例，帮助初学者和开发者快速掌握 Java 编程技能，提升技术水平。","siteIcon","/res/uploads/images/2026/07/31/019fb8110cb572e0b51358b40eee9903.jpg","siteKeywords",[114,146,147,148,149,150,151],"siteLogo","/res/uploads/images/2026/07/30/019fb1cb71447c6a9a304b25022ac979.png","siteNavs",[126,127,128,129,130,131],"siteNotification","siteTitle","Java学习者","tokenExpireDays","topicCaptcha","topicListStyle","default","topicPending","urlRedirect","userObserveSeconds","wxMpConfig",{"_124":125},"auditVersion","3.0.0",{"_15":144,"_133":145,"_135":31},{"_15":142,"_133":143,"_135":31},{"_15":140,"_133":141,"_135":87},{"_15":138,"_133":139,"_135":31},{"_15":136,"_133":137,"_135":87},{"_15":132,"_133":134,"_135":87},"游戏","url","/games","openInNewWindow","工具箱","https://tool.studyjava.cn","导航","/website","笔记","https://note.studyjava.cn","文章","/articles","话题","/topics","Java","Java学习","Java教程","Java入门","Java进阶","StudyJava",{"_153":87,"_154":155,"_156":157,"_158":21,"_159":160,"_161":31,"_162":31,"_163":21},"enabled","scriptName","百度统计","type","inline","src","code","var _hmt = _hmt || [];\n(function() {\n var hm = document.createElement(\"script\");\n hm.src = \"https://hm.baidu.com/hm.js?6062c55927ace17acb0e8847a6716bd3\";\n var s = document.getElementsByTagName(\"script\")[0]; \n s.parentNode.insertBefore(hm, s);\n})();","async","defer","crossorigin","tweet","topic","qa","article","passwordLogin",{"_153":87},"weixinLogin",{"_153":31},"weixinMpLogin",{"_153":87},"smsLogin",{"_153":31},"googleLogin",{"_153":31},"githubLogin",{"_153":31},"oidcProviders",{"_185":199,"_133":200,"_135":31,"_187":87},{"_185":195,"_133":196,"_135":31,"_187":87},{"_185":191,"_133":192,"_135":87,"_187":87},{"_185":186,"_133":21,"_135":87,"_187":31},"text",{"_188":189,"_70":190},"visible","en-US","Public Security Filing","公安网备信息",{"_188":193,"_70":194},"https://beian.miit.gov.cn","ICP Filing: 京ICP备15046882号-4","京ICP备15046882号-4",{"_188":197,"_70":198},"/links","Links","友情链接",{"_188":201,"_70":202},"/about","About","关于","allowedTypes",[209,210,211,212,213,214,215,216,217,218,219,220,221,222,223],"maxSizeMB",10,"maxCount",5,".pdf",".doc",".docx",".xls",".xlsx",".ppt",".pptx",".txt",".md",".csv",".zip",".rar",".7z",".tar",".gz"]