… developed an in-house database named UNIREG. UNIREG was a text-based program for entering records into an ISAM-style database… into the SQL based MySQL, with MySQL 1.0 being released in 1995. The FoRM file specified what fields where on what screen… bugs with small static rows in MySQL */ reclength=max(file->min_record_length(table_options),reclength); if (info_length+(ulong) create_fields.elements…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… 3.5.2pl1 32bit. Requires m1.small or greater. snap-073b6e68 shard-query-… from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_… it uses a copy of this text on this page. To use it, … EC2 console. That the “private ip” field is selected in the list of columns…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…Thus, the answer to the question is: for small tables, everything can reside within a single extent…/text fields (needs more info) According to the documentation, InnoDB put first 768 chars of each text/…HT: ha_innodb.cc in 5.1: static MYSQL_SYSVAR_ULONG(thread_concurrency, srv_thread_concurrency, …
Post: What exactly is read_rnd_buffer_size
July 24, 2007 By 4 Comments
… retrieved (good for small data lengths). In case sort with row pointer storage is used and the fields which are being length can be converted to fixed size (basically everything but BLOB/TEXT) MySQL can use read… this means since MySQL 4.1 this option is used in narrow range of cases – if you retrieve few fields (less than…
