June 19, 2013

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

…table: 58GB and 244.980.192 records TokuDB table: 15GB and 232.927.460 records…, as TokuDB does time-based checkpoints….KEY (`hid`,`mid`,`id`) where `id` is sequential, …cache_type = 0 ft_min_word_len = 4 #default_table_type = InnoDB thread_stack = 192K tmp_table_size = 64M server-id = 10 #*** MyISAM…

Filed Under: Benchmarks, MySQL, Percona Server Tagged With: , , ,

Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?

January 24, 2008 By 30 Comments

…MyISAM; All cities_* tables have 1,5M records each and records…records starting from record #10000 making MySQL to discard first 10000 records. 1) Results for ENUM: select SQL_NO_CACHE city from cities_enum WHERE…

Filed Under: Benchmarks Tagged With: , , , , , , ,

Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1

January 8, 2007 By 117 Comments

…_record_memory=2GB –falcon_page_cache_size=1500M –max-connections=1500 –table-cache=512 –net_read_timeout=30 –net_write_timeout=30 –backlog=128 MyISAM… name FROM $tableName WHERE country_id = %d and state_id between %d and %d LIMIT 50 Again Falcon does not hanle LIMIT…

Filed Under: Benchmarks Tagged With: ,

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

…the lead consultant does. We want … there’s no record later that someone …| 205174 | | Aborted_connects | 29 | | Binlog_cache_disk_use | 0 | | Binlog_cache_use | 9630066 | | Bytes_received |…MyISAM tables to InnoDB. (But then again, it might not be.) Or maybe the client is doing queries like “… WHERE…

Filed Under: Insight for Developers Tagged With:

Post: InnoDB Full-text Search in MySQL 5.6 (part 1)

February 26, 2013 By 1 Comment

…records, each one containing the name, address, and some other public-records…tables created in 5.5.30 where, of course, the only difference is that the engine is MyISAM…_00000000000000ad_BEING_DELETED_CACHE.ibd -rw-rw—-. …table, or it can be a sequence value generated by InnoDB when the table does…

Filed Under: Insight for DBAs, Insight for Developers, MySQL Tagged With: , , , , ,

Post: Falcon Storage Engine Design Review

January 12, 2007 By 19 Comments

…where which are optimized for Innodb which does…table in database A and a while after accessed table in database B, you will see records…Does row ever split into multiple parts like with MyISAM…

Filed Under: Insight for DBAs Tagged With:

Post: Detailed review of Tokutek storage engine

April 28, 2009 By 21 Comments

…records then InnoDB / MyISAM. Actually in internal cache records are stored in uncompressed form, but OS Cache…SERIALIZABLE isolation level. Beside it TokuDB does not scale well on…backup, as it applied TABLE LOCK on copying table. When recovery …and slow inserts. This is where I think Tokutek appears …

Filed Under: Uncategorized Tagged With:

Post: PBXT benchmarks

April 8, 2007 By 14 Comments

… 8 cpu MHz : 3192.222 cache size : 8192 KB 32GB…MyISAM / InnoDB ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb Method of benchmark: 1. Prepare table with 1,000,000 records…does not need an extra lookup to access to data. READ_PK_RANGE_INDEX Query: SELECT count(id) FROM $tableName WHERE…

Filed Under: Benchmarks Tagged With:

Post: MySQL Users Conference - Innodb

May 9, 2007 By 6 Comments

…does it uses dynamic or static record format ? (static record format for sort used by MyISAM may cause sort files to be much larger than table… they do not match where clause (think for example… why battery backed up cache is so important. I…

Filed Under: Events and Announcements Tagged With:

Post: COUNT(*) vs COUNT(col)

April 10, 2007 By 45 Comments

…00 sec) As this is MYISAM table MySQL has cached number of rows in this table. This is why it is … different question. MySQL Optimizer does good job in this case doing full table scan only if it is…where i alter table fact drop key i, add key(i,val); Query OK, 7340032 rows affected (37.15 sec) Records…

Filed Under: Insight for Developers Tagged With: ,
« Older Posts