Differences

This shows you the differences between two versions of the page.

--- informatica:linux:mysql:instalacion [2015/03/14 11:53] – [Consultas utiles] javi
+++ informatica:linux:mysql:instalacion [2017/06/24 17:05] – jose
@@ Line 31: / Line 31: @@
   #mysql -u <usuario> -h <hostname> -p <password>
+===== Mostrar BBDD =====
+  mysql> show databases;
+<code>
++--------------------+
+| Database           |
++--------------------+
+| information_schema |
+| mysql              |
+| performance_schema |
+| phpmyadmin         |
+| pingpong           |
++--------------------+
+rows in set (0.00 sec)
+</code>
@@ Line 908: / Line 921: @@
 </code>
+===== Partitions =====
+  * Listar
+<code>
+SHOW CREATE TABLE zabbix2014.history\G
+*************************** 1. row ***************************
+       Table: history
+Create Table: CREATE TABLE `history` (
+  `itemid` bigint(20) unsigned NOT NULL,
+  `clock` int(11) NOT NULL DEFAULT '0',
+  `value` double(16,4) NOT NULL DEFAULT '0.0000',
+  `ns` int(11) NOT NULL DEFAULT '0',
+  KEY `history_1` (`itemid`,`clock`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8
+/*!50100 PARTITION BY RANGE (`clock`)
+(PARTITION p201503130000 VALUES LESS THAN (1426287600) ENGINE = InnoDB,
+ PARTITION p201503140000 VALUES LESS THAN (1426374000) ENGINE = InnoDB,
+ PARTITION p201503150000 VALUES LESS THAN (1426460400) ENGINE = InnoDB,
+ PARTITION p201503160000 VALUES LESS THAN (1426546800) ENGINE = InnoDB,
+ PARTITION p201503170000 VALUES LESS THAN (1426633200) ENGINE = InnoDB,
+ PARTITION p201503180000 VALUES LESS THAN (1426719600) ENGINE = InnoDB,
+ PARTITION p201503190000 VALUES LESS THAN (1426806000) ENGINE = InnoDB) */
+row in set (0.01 sec)
+</code>
 ===== Errores =====