{"id":462,"date":"2011-12-19T11:21:25","date_gmt":"2011-12-19T14:21:25","guid":{"rendered":"http:\/\/stefano.salvatori.cl\/blog\/?p=462"},"modified":"2011-12-19T12:00:49","modified_gmt":"2011-12-19T15:00:49","slug":"matar-consultas-en-mysql","status":"publish","type":"post","link":"https:\/\/stefano.salvatori.cl\/blog\/2011\/12\/19\/matar-consultas-en-mysql\/","title":{"rendered":"Matar consultas en mysql"},"content":{"rendered":"<p>A quien no le ha pasado que realiza una consulta sobre una tabla muy grande y antes no revisa si existen \u00c3\u00adndices para realizar una b\u00c3\u00basqueda m\u00c3\u00a1s r\u00c3\u00a1pida.<\/p>\n<p>Existen dos comandos que nos pueden ayudar mucho.<br \/>\n<strong>SHOW PROCESSLIST<\/strong> (Muestra los proceso que tenemos corriendo (un proceso es una consulta).<br \/>\n<strong>kill <\/strong> (Mata un proceso).<\/p>\n<pre lang=\"sql\">\r\nSHOW PROCESSLIST;\r\nkill ;\r\n<\/pre>\n<p>Como recomendaci\u00c3\u00b3n siempre utilicen <strong>explain<\/strong> antes de realizar una consulta.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A quien no le ha pasado que realiza una consulta sobre una tabla muy grande y antes no revisa si existen \u00c3\u00adndices para realizar una b\u00c3\u00basqueda m\u00c3\u00a1s r\u00c3\u00a1pida. Existen dos comandos que nos pueden ayudar mucho. SHOW PROCESSLIST (Muestra los proceso que tenemos corriendo (un proceso es una consulta). kill (Mata un proceso). SHOW PROCESSLIST; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[11,33,26],"tags":[],"class_list":["post-462","post","type-post","status-publish","format-standard","hentry","category-mysql","category-programacion","category-tips"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p5Pxa3-7s","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/stefano.salvatori.cl\/blog\/wp-json\/wp\/v2\/posts\/462","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/stefano.salvatori.cl\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/stefano.salvatori.cl\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/stefano.salvatori.cl\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/stefano.salvatori.cl\/blog\/wp-json\/wp\/v2\/comments?post=462"}],"version-history":[{"count":2,"href":"https:\/\/stefano.salvatori.cl\/blog\/wp-json\/wp\/v2\/posts\/462\/revisions"}],"predecessor-version":[{"id":464,"href":"https:\/\/stefano.salvatori.cl\/blog\/wp-json\/wp\/v2\/posts\/462\/revisions\/464"}],"wp:attachment":[{"href":"https:\/\/stefano.salvatori.cl\/blog\/wp-json\/wp\/v2\/media?parent=462"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/stefano.salvatori.cl\/blog\/wp-json\/wp\/v2\/categories?post=462"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/stefano.salvatori.cl\/blog\/wp-json\/wp\/v2\/tags?post=462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}