{"id":232829,"date":"2023-01-30T10:24:00","date_gmt":"2023-01-30T07:24:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=232829"},"modified":"2023-02-06T10:58:24","modified_gmt":"2023-02-06T07:58:24","slug":"como-imprimir-el-resumen-de-la-tabla-mysql-usando-php","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/es\/como-imprimir-el-resumen-de-la-tabla-mysql-usando-php\/","title":{"rendered":"\u00bfC\u00f3mo imprimir el resumen de la tabla MySQL usando PHP?"},"content":{"rendered":"<p>La tabla <a href=\"https:\/\/helloacm.com\/how-to-generate-100k-test-data-to-mysql-database\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">MySQL<\/a> tiene un comando <strong>Show Table Status<\/strong> que imprime un resumen de la tabla, pero contiene mucha informaci\u00f3n sobre todas las tablas en la base de datos actual (para cambiar la base de datos, use &#8216;use database_name&#8217;), que no es tan f\u00e1cil de usar.<\/p>\n<p>Lo que queremos saber es el tama\u00f1o de los datos y el tama\u00f1o del \u00edndice, puede usar el siguiente script <a href=\"https:\/\/helloacm.com\/the-php-bing-wallpaper-bot-crawler\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">PHP<\/a> para imprimir dicha informaci\u00f3n.<\/p>\n<pre><code>&lt;?php\n\u00a0 require('conn.php'); \/\/ connect your database using e.g. $connection = mysqli_connect(...)\n\u00a0 $query = \"show table status\";\n\u00a0 $result = mysqli_query($connection, $query);\n\u00a0 $ds = 0;\n\u00a0 $is = 0;\n\u00a0 echo \"&lt;table style='text-align:left;width:100%'&gt;\";\n\u00a0 echo \"&lt;tr \u00a0style='background:blue;color:yellow;'&gt;&lt;th&gt;Name&lt;\/th&gt;&lt;th&gt;Data&lt;\/th&gt;&lt;th&gt;Index&lt;\/th&gt;&lt;\/tr&gt;\";\n\u00a0 function format($c) {\n\u00a0 \u00a0 return (round($c \/ 1024, 2)). 'KB';\n\u00a0 }\n\u00a0 while ($row = mysqli_fetch_assoc($result)) {\n\u00a0 \u00a0 echo \"&lt;tr&gt;&lt;th&gt;\". ($row['Name']). '&lt;\/th&gt;';\n\u00a0 \u00a0 echo \"&lt;th&gt;\". format($row['Data_length']). \"&lt;\/th&gt;\";\n\u00a0 \u00a0 echo \"&lt;th&gt;\". format($row['Index_length']). \"&lt;\/th&gt;\";\n\u00a0 \u00a0 $ds += $row['Data_length'];\n\u00a0 \u00a0 $is += $row['Index_length'];\n\u00a0 \u00a0 echo \"&lt;\/tr&gt;\";\n\u00a0 }\n\u00a0 echo \"&lt;tr style='background:lightblue;'&gt;\";\n\u00a0 echo \"&lt;th&gt;\". format($ds + $is). \"&lt;\/th&gt;&lt;th&gt;\". format($ds). \"&lt;\/th&gt;&lt;th&gt;\". format($is). \"&lt;\/th&gt;\";\n\u00a0 echo \"&lt;\/tr&gt;&lt;\/table&gt;\";<\/code><\/pre>\n<p>Aqu\u00ed hay un ejemplo del uso de una base de datos t\u00edpica de <a href=\"https:\/\/wordpress.mediadoma.com\/es\/como-agregar-disqus-si-los-comentarios-estan-cerrados-en-wordpress\/\" title=\"wordpress\">wordpress<\/a>. Formateamos el tama\u00f1o usando KB. De esta manera, puede realizar un seguimiento del uso de la tabla de vez en cuando. Tambi\u00e9n puede modificar el estilo CSS en el c\u00f3digo anterior para formatear la salida.<\/p>\n<p>mysql-show-table-status-in-php-example<\/p>\n<p><div id=\"PostUnique_PostSource\" style=\"padding-top: 50px\">Fuente de grabaci\u00f3n:  <a target=\"_blank\" rel=\"noopener nofollow\" href=\"\/\/helloacm.com\" class=\"external external_icon\">helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00bfC\u00f3mo imprimir el resumen de la tabla MySQL usando PHP?<\/p>\n","protected":false},"author":1,"featured_media":224526,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[892,716,914,800],"tags":[1172],"class_list":["post-232829","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-codigo","category-desarrollador","category-otro","category-php-2","tag-affiai-es"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/posts\/232829","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/comments?post=232829"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/posts\/232829\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/media\/224526"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/media?parent=232829"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/categories?post=232829"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/es\/wp-json\/wp\/v2\/tags?post=232829"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}