informatica:linux:mysql:instalacion
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
informatica:linux:mysql:instalacion [2015/03/14 11:53] – [Consultas utiles] javi | informatica:linux:mysql:instalacion [2017/10/20 09:52] (current) – [Errores] javi | ||
---|---|---|---|
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 906: | Line 919: | ||
SHOW PROCEDURE STATUS; | SHOW PROCEDURE STATUS; | ||
SHOW FUNCTION STATUS; | SHOW FUNCTION STATUS; | ||
+ | </ | ||
+ | |||
+ | ===== 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) | ||
+ | </ | ||
+ | ===== Strict Mode ===== | ||
+ | |||
+ | He conocido de su existencia a través de django: | ||
+ | |||
+ | https:// | ||
+ | |||
+ | Django recomienda habilitar el modo estricto, con la configuración " | ||
+ | |||
+ | 1. Editar archivo de configuración: | ||
+ | |||
+ | < | ||
+ | sudo cp / | ||
+ | sudo vim / | ||
+ | </ | ||
+ | |||
+ | 2. Y añadir en la sección " | ||
+ | |||
+ | < | ||
+ | ... | ||
+ | [mysqld] | ||
+ | sql-mode = " | ||
+ | </ | ||
+ | |||
+ | 3. Reiniciar el servicio | ||
+ | |||
+ | sudo service mysql restart | ||
+ | | ||
+ | 4. Verificarlo | ||
+ | |||
+ | 4.1. Iniciar sesión como usuario " | ||
+ | |||
+ | sudo mysql -u root | ||
+ | | ||
+ | 4.2. Ver el valor de la variable " | ||
+ | |||
+ | SELECT @@SESSION.sql_mode; | ||
+ | |||
+ | Valor esperado: | ||
+ | |||
+ | < | ||
+ | +---------------------+ | ||
+ | | @@SESSION.sql_mode | ||
+ | +---------------------+ | ||
+ | | STRICT_TRANS_TABLES | | ||
+ | +---------------------+ | ||
</ | </ | ||
informatica/linux/mysql/instalacion.1426334019.txt.gz · Last modified: 2015/04/13 20:19 (external edit)