MySQL Forums
Forum List  »  Optimizer & Parser

Re: low query
Posted by: ben hakim
Date: February 16, 2007 08:28AM

Hi Toa Sty

here the comman explain :
 

table 	type 	possible_keys 	key 	key_len ref 	rows 	Extra
Co 	ALL 	NULL 	NULL 	NULL 	NULL 	458 	Using temporary; Using filesort
Pl 	ALL 	NULL 	NULL 	NULL 	NULL 	768 	 
A 	eq_ref 	PRIMARY PRIMARY 4 	Co.id 	1 	 
P 	ALL 	NULL 	NULL 	NULL 	NULL 	768 	where used
C 	eq_ref 	PRIMARY PRIMARY 4 	P.id_audio 	1 	where used
Cs 	eq_ref 	PRIMARY PRIMARY 4 	C.id_support 	1 	 
U 	eq_ref 	PRIMARY PRIMARY 4 	P.id_user 	1 	where used

output for show table:
 
 Table  	 Create Table

playlist_user  	CREATE TABLE `playlist_user` (
 `id_playlist` int(5) NOT NULL auto_increment,
 `id_user` int(5) NOT NULL default '0',
 `id_audio` int(5) NOT NULL default '0',
 `date_playlist` date NOT NULL default '0000-00-00',
 `note_audio` char(1) NOT NULL default '',
 PRIMARY KEY  (`id_playlist`)
) TYPE=MyISAM

catalogue_audio  	CREATE TABLE `catalogue_audio` (
 `id_audio` int(5) NOT NULL auto_increment,
 `id_artiste` int(5) NOT NULL default '0',
 `id_support` int(5) NOT NULL default '0',
 `nom_audio` varchar(255) NOT NULL default '',
 `prix_audio` decimal(4,2) NOT NULL default '0.00',
 `genre_audio` varchar(8) NOT NULL default '',
 `urlMp3` varchar(255) NOT NULL default '',
 `online` char(3) NOT NULL default '',
 PRIMARY KEY  (`id_audio`)
) TYPE=MyISAM

catalogue_support  	CREATE TABLE `catalogue_support` (
 `id_support` int(5) NOT NULL auto_increment,
 `id_artiste` int(5) NOT NULL default '0',
 `titre_support` varchar(255) NOT NULL default '',
 `label_support` varchar(255) NOT NULL default '',
 `annee_support` varchar(4) NOT NULL default '',
 `cover_support` varchar(255) NOT NULL default '',
 PRIMARY KEY  (`id_support`)
) TYPE=MyISAM

artistes  	CREATE TABLE `artistes` (
 `id_artiste` int(11) NOT NULL auto_increment,
 `nom_artiste` varchar(255) NOT NULL default '',
 `site_artiste` varchar(255) NOT NULL default '',
 `description_artiste` varchar(255) NOT NULL default '',
 `bio_artiste` longtext NOT NULL,
 `genre_artiste` varchar(8) NOT NULL default '',
 `typeCompte_artistique` int(1) NOT NULL default '0',
 `typeContrat_artiste` int(1) NOT NULL default '0',
 `sacem_artiste` int(1) NOT NULL default '0',
 `inscription_artiste` varchar(20) NOT NULL default '0',
 `urlMp3_artiste` varchar(255) NOT NULL default '',
 `uploadMp3_artiste` varchar(255) NOT NULL default '',
 `online` char(3) NOT NULL default 'non',
 PRIMARY KEY  (`id_artiste`)
) TYPE=MyISAM

comptes  	CREATE TABLE `comptes` (
 `id_compte` int(5) NOT NULL auto_increment,
 `nom_compte` varchar(255) NOT NULL default '',
 `email_compte` varchar(255) NOT NULL default '',
 `pass_compte` varchar(32) NOT NULL default '',
 `type_compte` int(1) NOT NULL default '1',
 `url` varchar(255) NOT NULL default '',
 `id` int(5) NOT NULL default '0',
 `dateInscription_compte` date NOT NULL default '0000-00-00',
 `avatar_compte` varchar(255) NOT NULL default '',
 `last_connexion` timestamp(14) NOT NULL,
 `online` char(3) NOT NULL default 'oui',
 PRIMARY KEY  (`id_compte`)
) TYPE=MyISAM

Thank for your help

Options: ReplyQuote


Subject
Views
Written By
Posted
4517
February 16, 2007 03:49AM
2036
February 16, 2007 04:44AM
Re: low query
1984
February 16, 2007 08:28AM
1827
February 25, 2007 11:55PM


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.