MYSQL index with text fileds -


i try build index article (own_a) table because can't use exist index.

the select contain 6 fileds article table, 3 integer, 1 varchar (30) , 2 text. if delete 2 text filed query, use index succesfully. how build index 2 large text filed? error: "specified key long; max key length 1000 bytes".

select                                 own_a.id article_id,                                 own_a.article_number,                                 own_d.id dealer_id,                                 own_d.name dealer,                                 own_a.tecdoc_article_id,                                 own_a.description,                                 own_a.extra_description,                                 'art' type,                                 al.genart_id,                                 1 own                         own_db.article own_a                         join own_db.dealer own_d on own_a.dealer_id = own_d.id                   join `common_db`.`article` on a.id = own_a.t_article_id                  join `common_db`.`article_linkage` al on al.article_id = a.id                                                         own_a.id not null                                 , 1=1                                 , al.genart_id in (273,251,2462,3229,1334,1080,854,919,188,1632,1626,1213,12,3845,51,191,1547,653,2070,572,654,188,854)                                 , ( 1=0 or a.dealer_id in (10,101,110,134,140,156,161,192,301,316,317,32,35,55,6,85,89,9,95) )                                 , al.type_type = 2                                 , al.type_id = 19799                         group own_a.id                         order  own_a.id

explain select...:

    id  select_type table   type    possible_keys                                           key     key_len ref     rows        1   simple      own_a       primary,article_number,id,idx_id_an,idx_id_did,idx...   null    null    null    20088   using where; using temporary; using filesort     1   simple      al      ref     artid                                                   artid   17      commondb.own_a.t_article_id,const,con...    2   using     1   simple      own_d   eq_ref  primary                                                 primary 8       own_db.own_a.dealer_id       1   simple            eq_ref  primary,dealer_id,dealer_id_index                       primary 8       own_db.own_a.t_article_id   1   using

use index (..) didn't work.

thx help


Comments

Post a Comment

Popular posts from this blog

toolbar - How to add link to user registration inside toobar in admin joomla 3 custom component -

im trying write component admin side , need add user creation. dont want duplicate existing codes add link. know how add task not simple link toolbar. thx help. if wanting button opens new user screen can try in component: $bar = jtoolbar::getinstance('toolbar'); $bar->appendbutton('link', 'users', 'new user','index.php?option=com_users&task=user.add'); you need add view.html.php file wherever you're creating toolbar. is need?
Read more

linux - disk space limitation when creating war file -

i have 1 gb disk space limitation hosting app , have used 700mb of it. however want create war file directory big (around 600mb) using command : jar -cvf root.war folderpath that's why encounter quota limitation , can't following. i'm looking way delete folder content when it's applying archive conserve disk space take note can't install zip tool in ssh shell ~ the code works on test directories, test first anyway, deletes files. it's not efficient. assumptions: 300mb free space, in destructively compress 600mb folderpath directory. none of files big -- if file in folderpath 300mb or larger, fail. notes: if ' $out ' file exists, nothing. first find pipes file list while , if ' $out ' doesn't exist in loop, create it, don't update -- if does exist, update it. each pass adds 1 more file, deletes unless file directory. after loop finishes delete empty directories too. unset u ; in=folderpath ; out=roo...
Read more