June 20, 2013

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

…2.8x better throughput, and on data size: InnoDB table: 58GB and 244.980.192 records TokuDB table: 15GB and 232.927.460 records…TokuDB does time-…mid`,`id`) where `id` is…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…WHERE state=’Minnesota’ limit 10000,5; Result time(mean): 0.082196 2) Results for VARCHAR: select SQL_NO_CACHE city from cities_varchar 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…Starkey’s comments in Part 2). There MyISAM shows bad scalability …WHERE country_id = %d and state_id between %d and %d LIMIT 50 Again Falcon does…

Filed Under: Benchmarks Tagged With: ,

Post: How Percona does a MySQL Performance Audit

November 24, 2008 By 17 Comments

… with what the lead consultant does. We want two sets of… it. If there’s no record later that someone else can …R) CPU L5335 @ 2.00GHz stepping : 11 cpu MHz : 1995.022 cache size : 4096 KB…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…_BEING_DELETED_CACHE.ibd -rw-rw…table, or it can be a sequence value generated by InnoDB when the table does…. In part 2 of this …

Filed Under: Insight for DBAs, Insight for Developers, MySQL 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…2), and the number of inserts/sec is almost linear even when table…SERIALIZABLE isolation level. Beside it TokuDB does not scale well on…and slow inserts. This is where I think Tokutek appears…

Filed Under: Uncategorized Tagged With:

Post: PBXT benchmarks

April 8, 2007 By 14 Comments

…2210 stepping : 2 cpu MHz : 1800.163 cache size…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… out where already which may come in MySQL 5.2 or … 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: ,

Post: Top 5 Wishes for MySQL

June 29, 2007 By 10 Comments

…plugins instead of patches. 2. Be Scalable I’… amount of issues with MyISAM and generally on MySQL…tables and other tricks we use when such need arises but we still can’t deny – MySQL does…has very good stability track record, with exception of …stays where for very long time. For example Query Cache…

Filed Under: Insight for DBAs Tagged With: