20% sounds too few to me, I made a benchmark of HandlerSocket no in the same conditions (not all data fit buffer pool) and the gains were around 65% with one thread and 3 times more with 10 threads: https://github.com/entering/miscellaneous/blob/master/benchmarks/handler-socket.md
Comment: Blob Storage in Innodb
February 10, 2010 By 13 Comments
… allocates memory for the entire blob to be returned to the user. So imagine a blob that is 1 GB in size… blob, innodb will need to allocate 25 GB of memory to satisfy this query. See: http://mysqlinsights.blogspot.com/2009/01/mysql-blobs… using a streaming blob protocol, but this requires a change to mysql client as far as i know: http://www.blobstreaming.org…
Comment: Heikki Tuuri to answer your in depth Innodb questions
September 28, 2007 By 51 Comments
… 8100 bytes InnoDB will not allocate additional space for blobs, even if each blob is larger than 768. 2. InnoDB will allocate additional space outside of the page for _each_ blob (if we have 8 blobs 8xN bytes will be allocated) Question: How much space InnoDB allocates for each blob outside of the page? Test case in: http…
Post: Innodb row size limitation
April 7, 2011 By 12 Comments
… page (this behavior is version specific, see http://www.mysqlperformanceblog.com/2010/02/09/blob-storage-in-innodb/ for further reference). It… solution. Combine all your variable length fields into a single BLOB and do the splitting at the application level. This will…, these approaches can be combined. For example, using the single BLOB field with COMPRESS/UNCOMPRESS can yield great results. Finally, let…
Post: How is join_buffer_size allocated?
July 5, 2010 By 9 Comments
… record in 14179 last record is stored with pointers to blobs to support very big 14180 records 14181 ******************************************************************************/ 14182 14183 static…_count) 14185 { … snip … 14268 cache->length=length+blobs*sizeof(char*); 14269 cache->blobs=blobs; 14270 *blob_ptr=0; /* End sequentel */ 14271 size=max(thd… and nothing bad happens, you might be seeing this bug: http://bugs.mysql.com/55002
Comment: Blob Storage in Innodb
February 16, 2010 By 13 Comments
…. We tried to make some improvements in the discussion. See: http://dev.mysql.com/doc/refman/5.1/en/innodb-file… maximum row length, except for variable-length columns (VARBINARY, VARCHAR, BLOB and TEXT), is slightly less than half of a database… be less than 4GB, and the total row length, including BLOB and TEXT columns, must be less than 4GB. If a…
Comment: What's up with HandlerSocket?
March 28, 2011 By 43 Comments
…! @Patrick I’m not a Java guy, but according to https://github.com/ahiguti/HandlerSocket-Plugin-for-MySQL there are two java client libraries for HandlerSocket: http://code.google.com/p/hs4j/ http://code.google.com/p/handlersocketforjava/ I haven… either, so YMMV. Also, the protocol (https://github.com/ahiguti/HandlerSocket-Plugin-for-MySQL/blob/master/docs-en/protocol.en.txt) is…
Comment: What's up with HandlerSocket?
March 28, 2011 By 43 Comments
…! @Patrick I’m not a Java guy, but according to https://github.com/ahiguti/HandlerSocket-Plugin-for-MySQL there are two java client libraries for HandlerSocket: http://code.google.com/p/hs4j/http://code.google.com/p/handlersocketforjava/ I haven… either, so YMMV. Also, the protocol (https://github.com/ahiguti/HandlerSocket-Plugin-for-MySQL/blob/master/docs-en/protocol.en.txt) is…
Comment: kernel_mutex problem. Or double throughput with single variable
December 3, 2011 By 17 Comments
…: 1. http://lwn.net/images/conf/rtlws11/papers/proc/p10.pdf See introduction. 2. http://repo.or.cz/w/glibc.git/blob/HEAD…
Comment: Percona XtraDB Cluster / Galera Tutorial at Percona Live NY 2012
September 12, 2012 By 4 Comments
Valerii: valid point. See if this helps: https://github.com/jayjanssen/percona-xtradb-cluster-tutorial/blob/master/doc/00-Initial%20Setup.rst#can-my-machine-handle-this
