…auto increment primary key and couple of extra indexes. CREATE TABLE IF NOT EXISTS `$tableName` ( `id` int(10) unsigned NOT NULL auto_increment… in terms of CPU usage. In real life workload…MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql…
Post: How much memory Innodb locks really take ?
July 13, 2006 By 11 Comments
… locks are relly as efficient in terms of low resource usage as they are advertised. Lets start with a bit of… NOT NULL auto_increment, `j` varchar(255) default NULL, PRIMARY KEY (`i`), KEY `j` (`j`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 mysql> show table… Max_data_length: 0 Index_length: 128974848 Data_free: 0 Auto_increment: 1638401 Create_time: 2006-07-12 07:31:51 Update…
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…auto increment primary key and couple of extra indexes. CREATE TABLE IF NOT EXISTS `$tableName` ( `id` int(10) unsigned NOT NULL auto_increment…storage engines are in terms of CPU usage. In real life workload results are …: 1024 KB 4GB of RAM MySQL version We used MySQL 5.1.16-beta sources for MyISAM…
Comment: Duplicate indexes and redundant indexes
January 19, 2012 By 38 Comments
…auto_increment primary key, deptname varchar(20) ); create table emp ( empid integer auto_increment…at the end) mysql> source list.sql +————–+————+—————–+—————–+————-+———————–+————————+ | table_schema…key_column_usage b ON a…
Post: Percona testing: Quick test clusters with kewpie!
January 13, 2012 By Leave a Comment
… for randgen usage… 20120113-125552 INFO Using –no-shm, will not link workdir to shm 20120113-125552 INFO Using mysql source tree… statement. mysql> create table t1 (a int not null auto_increment, primary key(a)); Query OK, 0 rows affected (0.11 sec) mysql> insert… –mode=cleanup Setting –no-secure-file-priv=True for randgen usage… Setting –start-dirty=True for cleanup mode… 20120113-132229 INFO…
Comment: COUNT(*) vs COUNT(col)
April 25, 2007 By 45 Comments
… TABLE `wp_comments` ( `comment_ID` bigint(20) unsigned NOT NULL auto_increment, `comment_post_ID` int(11) NOT NULL default ’0′, `comment…(*) | +———-+ | 230120 | +———-+ 1 row in set (1.19 sec) mysql> and the buffer pool usage: Total memory allocated 589194920; in additional pool allocated…
Post: Moving from MyISAM to Innodb or XtraDB. Basics
November 22, 2010 By 2 Comments
…backup. Full text search indexes, GIS, multi-column auto increment keys are great examples. There are also … while as depending on the schema and usage Innodb tables may increase in size significantly … about defaults for Innodb. First Depending on MySQL version they may be somewhere from suboptimal …
