… things like NEXT_NUMBER fields (what we know today as auto_increment), CASEUP and CASEDN fields which although not implemented in MySQL… to avoid bugs with small static rows in MySQL */ reclength=max(file->min_record_length(table_options),reclength); if (info_length… */ /* from rem0types.h */ #define REC_MAX_N_FIELDS (1024 – 1) #define REC_MAX_N_USER_FIELDS (REC_MAX_N_FIELDS – DATA_N_SYS…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
…_row_length: 7 Data_length: 14680064 Max_data_length: 1970324836974591 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time: 2008-04…_row_length: 11 Data_length: 23068672 Max_data_length: 3096224743817215 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time: 2008-04…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…auto_increment_incrementblogpercona.commanual auto_increment…
Post: How much space does empty Innodb table take ?
December 16, 2008 By 7 Comments
…_row_length: 16384 Data_length: 16384 Max_data_length: 0 Index_length: 32768 Data_free: 0 Auto_increment: NULL Create_time: 2008-12…_row_length: 199 Data_length: 212992 Max_data_length: 0 Index_length: 360448 Data_free: 0 Auto_increment: NULL Create_time: 2008-12…_row_length: 147 Data_length: 393216 Max_data_length: 0 Index_length: 671744 Data_free: 0 Auto_increment: NULL Create_time: 2008-12…
Post: Edge-case behavior of INSERT...ODKU
October 27, 2012 By 6 Comments
… majority of the database was a single table with an auto-incrementing integer PK and a secondary UNIQUE KEY. The queries being… situation: CREATE TABLE update_test ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, username VARCHAR(20) NOT NULL, host_id TINYINT UNSIGNED NOT… ROW, the one where the id is equal to the auto-increment max value, which is the one that got updated. The secondary…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…_row_length: 29 Data_length: 125452288 Max_data_length: 0 Index_length: 278839296 Data_free: 1838153728 Auto_increment: 4587468 Create_time: 2011-11…_row_length: 29 Data_length: 125452288 Max_data_length: 0 Index_length: 187465728 Data_free: 1930428416 Auto_increment: 4587468 Create_time: 2011-11…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…=mysql,test #replicate_do_db=crmdb #replicate_do_db=newcrmdb #auto-increment-increment = 3 #auto-increment-offset = 1 #log-slave-updates skip_name_resolve #master…_timeout = 60 tmp_table_size = 192M max_heap_table_size = 192M max_allowed_packet = 64M #max_connect_errors = 10000 read_rnd_buffer_size…
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
…_row_length: 252 Data_length: 2030206088 Max_data_length: 4294967295 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time: 2006-11…_row_length: 0 Data_length: 0 Max_data_length: NULL Index_length: 0 Data_free: 0 Auto_increment: NULL Create_time: NULL Update… I got this table by converting MyISAM table rather than incremental insertions. I also compared it to compressed MyISAM – this would…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…, auto increment primary key and couple of extra indexes. CREATE TABLE IF NOT EXISTS `$tableName` ( `id` int(10) unsigned NOT NULL auto_increment, `name…=1500M –innodb-log-file-size=100M –innodb-thread-concurrency=8 –max-connections=1500 –table-cache=512 –net_read_timeout=30 –net…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
…trx_commit = 2 innodb_flush_method = O_DIRECT innodb_max_dirty_pages_pct = 50 innodb_io_capacity = 800 …cashregisterid`,`price`,`customerid`), KEY `pdc` (`price`,`dateandtime`,`customerid`) ) ENGINE=InnoDB AUTO_INCREMENT=11073789 DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (transactionid) …
