MySQL Forums
Forum List  »  Partitioning

How partitioning this table
Posted by: pascal boulesteix
Date: October 31, 2017 11:11AM

Hi all
Here my table :

CREATE TABLE wnat_inventaires (
UnikInv int(11) NOT NULL AUTO_INCREMENT,
Organisme varchar(15) NOT NULL,
Cpu varchar(2) NOT NULL,
NumObs bigint(20) UNSIGNED NOT NULL DEFAULT 0,
origine_inventaire int(1) NOT NULL COMMENT 'Origine de la citation',
num_file_import int(11) NOT NULL,
ref_inventaire_import varchar(50) DEFAULT NULL COMMENT 'Identification originelle (importation)',
Observateur int(11) DEFAULT NULL,
DateObs date DEFAULT NULL COMMENT 'Date<br>observation',
HeureObs time DEFAULT NULL COMMENT 'Heure<br>observation',
Duree time DEFAULT NULL COMMENT 'Durée',
unik_lieudit int(11) NOT NULL,
unik_gps int(11) NOT NULL,
Milieu varchar(30) DEFAULT NULL,
is_gps tinyint(1) DEFAULT NULL COMMENT 'Point<br>GPS',
Longitude decimal(8, 5) DEFAULT NULL,
Latitude decimal(8, 5) DEFAULT NULL,
Maj char(1) NOT NULL,
Date_Maj date DEFAULT NULL COMMENT 'Date de mise<br>à jour',
ObsAsso int(11) DEFAULT NULL COMMENT 'Observateur<br>associé',
etude varchar(50) DEFAULT NULL COMMENT 'Code<br>étude',
Confidentiel tinyint(1) NOT NULL COMMENT 'Inventaire<br>confidentiel',
bloque_export tinyint(1) DEFAULT NULL COMMENT 'Exportation bloquée',
Commentaire_inventaire varchar(2048) NOT NULL COMMENT 'Commentaire<br>inventaire',
Precision_Date varchar(1) NOT NULL COMMENT 'Précision de la date',
echantillon varchar(15) NOT NULL COMMENT 'Type d''échantillonnage',
nbr_echantillon int(11) NOT NULL COMMENT 'Nombre d''échantillons',
materiel int(11) DEFAULT NULL,
PRIMARY KEY (UnikInv),
INDEX IDX_ref_inventaire_import (ref_inventaire_import),
INDEX IDX_wnat_inventaires (Organisme, etude),
INDEX IDX_wnat_inventaires2 (Organisme, num_file_import),
INDEX UK_wnat_inventaires (Organisme, echantillon),
UNIQUE INDEX UNIQUE_INVENTAIRES (Organisme, Cpu, NumObs),
INDEX wnat_inventaires_index01 (Organisme),
INDEX wnat_inventaires_index012 (unik_lieudit, Organisme),
INDEX wnat_inventaires_index013 (Organisme, unik_lieudit),
INDEX wnat_inventaires_index014 (Organisme, unik_gps),
INDEX wnat_inventaires_index020 (unik_gps),
INDEX wnat_inventaires_index03 (Organisme, Observateur, DateObs)
)
ENGINE = MYISAM
AUTO_INCREMENT = 996107
AVG_ROW_LENGTH = 120
CHARACTER SET latin1
COLLATE latin1_swedish_ci
COMMENT = 'idx_echantillons';

I would like to make partitions over Organisme column.

I have try many solutions but without success !

An idea ?

Pascal

Options: ReplyQuote


Subject
Views
Written By
Posted
How partitioning this table
1814
October 31, 2017 11:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.