sql - MySQL if where not found then insert -

-

as appear classic "on duplicate key update" question - not.

i have table meta values goes like:

meta_id   |   user_id   |   meta_type   |   meta_value

thing there can more entries same user_id&&meta_type must not repeat entries same user_id&&meta_type&&meta_value. add unique index these, afraid of 1 thing - meta_value longtext contain larger data.
so when want create unique key (so use on duplicate key update), error:

#1170 - blob/text column 'meta_hodnota' used in key specification without key length

and when tried add limit popped out:

#1071 - specified key long; max key length 767 bytes

that low possible entry. question how key work:

  1. it saying how long part of column mysql check duplicity , not modify posibility of having max. column value size (max(longtext))
    note: care tripple duplicity smaller entries, dont care duplicity big entries (not in place)
  2. it cutting possibility of having max. column value size(max(longtext)) , leaving 767bytes maximum value of column though column longtext. - not acceptable => here query neccessary? or there way? (e.g.sql-side search , variable save => chosing action according result)

any help/tips on this?

any chance 3072 bytes enough? can use innodb_large_prefix parameter in mysql configuration in case.

if 3072 bytes not enough adding fixed lenght column (something varchar(256)) , use 1 create index. when inserting/updating record can use substr() trim long text 256 char , populate column value.

this of course works if care smaller entries in meta_* said. depending on number of rows disc usage increase little shouldn't issue in cases.


Comments

Post a Comment

Popular posts from this blog

python - Subclassed QStyledItemDelegate ignores Stylesheet -

-
i'm trying subclass qstyleditemdelegate remove focus rectangle in qcombobox . even though i'm calling base implementation of paint function , nothing else, result different. looks if parts of style-sheet influence bounding box of item taken consideration. class pstyleditemdelegate(qstyleditemdelegate): def __init__(self, *args, **kwds): super(pstyleditemdelegate, self).__init__(*args, **kwds) def paint(self, *args, **kwargs): qstyleditemdelegate.paint(*args, **kwargs) what have paint unmodified qstyleditemdelegate ? as suggested tried replacing pyside pyqt4 , works, appears bug. update pyside 1.1.2 1.2.1 result same. unfortunately switch breaks other parts of code, if there no other suggestions i'm going accept answer. edit bug tracked here
Read more

java - HttpClient 3.1 Connection pooling vs HttpClient 4.3.2 -

-
i have used httpclient3.1(java) connection pooling below : import org.apache.commons.httpclient.httpclient; import org.apache.commons.httpclient.multithreadedhttpconnectionmanager; import org.apache.commons.httpclient.params.httpclientparams; import org.apache.commons.httpclient.params.httpmethodparams; import org.apache.log4j.logger; public class httpclientmanager { private static logger logger = logger.getlogger(httpclientmanager.class); private static multithreadedhttpconnectionmanager connectionmanager = new multithreadedhttpconnectionmanager(); private static httpclientparams clientparams = new httpclientparams(); static { try { clientparams.makelenient(); clientparams.setauthenticationpreemptive(false); clientparams.setparameter(httpmethodparams.so_timeout, new integer(30000)); // set so_timeout clientparams.setparameter(httpmethodparams.head_body_check_timeout, new integer(3000)); // head responses ...
Read more

node.js - StackOverflow API not returning JSON -

-
i using node.js script gather data stackoverflow. know responses gzipped, put code in should take care of that. script follows: var request = require('request'); var zlib = require('zlib'); function getstackoverflowresponse(url, callback){ request(url, {encoding: null}, function(err, response, body){ if(response.headers['content-encoding'] == 'gzip'){ zlib.gunzip(body, function(err, dezipped) { callback(dezipped); }); } else { callback(body); } }); } var url = "https://api.stackexchange.com/docs/questions#pagesize=2&order=desc&min=2014-01-04&max=2014-02-02&sort=activity&tagged=apigee&filter=default&site=stackoverflow&run=true"; getstackoverflowresponse(url, function(questions) { console.log(questions); }); instead of getting json output, i'm getting following response: buffer 0d 0a 0d 0a 0d 0a 0d 0a 3c 21 44 4f 43 54 59 50 45 20 48...
Read more