informatica:linux:mysql:instalacion
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
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 < | #mysql -u < | ||
+ | ===== Mostrar BBDD ===== | ||
+ | mysql> show databases; | ||
+ | < | ||
+ | +--------------------+ | ||
+ | | Database | ||
+ | +--------------------+ | ||
+ | | information_schema | | ||
+ | | mysql | | ||
+ | | performance_schema | | ||
+ | | phpmyadmin | ||
+ | | pingpong | ||
+ | +--------------------+ | ||
+ | 5 rows in set (0.00 sec) | ||
+ | </ | ||
Line 908: | Line 921: | ||
</ | </ | ||
+ | ===== Partitions ===== | ||
+ | * Listar | ||
+ | < | ||
+ | SHOW CREATE TABLE zabbix2014.history\G | ||
+ | *************************** 1. row *************************** | ||
+ | | ||
+ | Create Table: CREATE TABLE `history` ( | ||
+ | `itemid` bigint(20) unsigned NOT NULL, | ||
+ | `clock` int(11) NOT NULL DEFAULT ' | ||
+ | `value` double(16, | ||
+ | `ns` int(11) NOT NULL DEFAULT ' | ||
+ | KEY `history_1` (`itemid`, | ||
+ | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 | ||
+ | /*!50100 PARTITION BY RANGE (`clock`) | ||
+ | (PARTITION p201503130000 VALUES LESS THAN (1426287600) ENGINE = InnoDB, | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | | ||
+ | 1 row in set (0.01 sec) | ||
+ | </ | ||
===== Errores ===== | ===== Errores ===== | ||
informatica/linux/mysql/instalacion.txt · Last modified: 2017/10/20 09:52 by javi