… server is one huge innodb table with a set of TEXT fields. We’ve been trying to optimize this server before by… down to 8kb) new innodb plugin performs TEXT/BLOB/VARCHAR fields compression off-page so every large TEXT field could become as small as a… not so different because most of our data was in TEXT fields and there weren’t many other indexes aside from PRIMARY…
Post: Percona Server 5.5.15-21.0
August 31, 2011 By 10 Comments
…. This renders a VARCHAR field in a CHAR field in practice, making impossible to have a TEXT or BLOB field with that engine implementation… those columns and making possible BLOB and TEXT fields and real VARCHAR and VARBINARY. For performance reasons, a mixed solution is implemented: the…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… lookup up a row in another table based on a text field ( called email address ). Seems simple enough right? My two… simple, ensures that application is generally mean and lean and performs well. The issue is even this simple design can start… lookup up a row in another table based on a text field ( called email address ). Seems simple enough right? My two tables…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… InnoBD handles blobs/text fields (needs more info) According to the documentation, InnoDB put first 768 chars of each text/blob in the…(thread_concurrency, srv_thread_concurrency, PLUGIN_VAR_RQCMDARG, “Helps in performance tuning in heavily concurrent environments. Sets the max\ imum number…
Post: Analyzing air traffic performance with InfoBright and MonetDB
October 2, 2009 By 50 Comments
…(10) DEFAULT NULL ) ENGINE=BRIGHTHOUSE DEFAULT CHARSET=latin1; Last fields starting with “Div*” are not really used. Load procedure:… took some time to figure out how to load text data ( I really wish developers improve documentation), but finally…you want to compare or get info about air performance….
Comment: Why MySQL could be slow with large tables ?
May 23, 2007 By 141 Comments
… very large database , around 200,000 records , but with a TEXT FIELD that could be really huge….If I am looking for… about slow performance of mysql on large database surprises me….. By the way….on the other hard, Does Mysql support XML fields ?
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… storage engine or database About the cluster For best performance, there should be an even data distribution in the…the cluster and it uses a copy of this text on this page. To use it, ensure: That only… shown in the EC2 console. That the “private ip” field is selected in the list of columns to show …
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
… use many queries with ORDER BY, upping this can improve performance” which is cool but it does not really tell you…. Here is how it works: As sort is performed it can be performed having only row pointers together with key value – which… used and the fields which are being length can be converted to fixed size (basically everything but BLOB/TEXT) MySQL can use…
Post: Dynamic row format for MEMORY tables
September 6, 2011 By 5 Comments
… and, of course, if you have a performance-critical application depending on MEMORY tables, they… format delivers the memory savings for VARCHAR fields agains the fixed row format. For that…instead: for schemas containing large VARCHARs, BLOB, TEXT. Unfortunately, enabling this feature is not trivial,…
Comment: To UUID or not to UUID ?
April 15, 2008 By 28 Comments
… those problems with UUID’s in MySQL when stored as text. Ideally, MySQL would have a UUID column type to store… hex text and convert it to binary would be a must too. That’s the biggest problem with using binary fields: you can’t read them or copy and paste them without conversion. That change would provide better performance in…
