June 19, 2013

Comment: Benchmarking Percona Server TokuDB vs InnoDB

May 22, 2013 By 32 Comments

… of InnoDB throughput down to ~1500 insert/sec (and counting) while TokuDB remained steadily around 20000 insert/sec. I inserted around 100Million rows… Xeon X5650 @2.7GHz, 96GB of RAM and a very fast LSI MegaRaid backed storage with SSD Cache. Aurimas worked on…

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

Post: Benchmarking Percona Server TokuDB vs InnoDB

May 7, 2013 By 32 Comments

… with 1bln of rows on this SSD, and projected InnoDB performance on …fast inserts, but it is suitable for range selects by `id`. However it will interesting how both InnoDB…innodb_use_native_aio=0 #not innodb options (fixed) port = 3306 back_log = 50 max_connections = 2000 max_prepared_stmt_count…

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

Post: Virident vCache vs. FlashCache: Part 2

May 17, 2013 By 3 Comments

… were conducted with approximately 78GiB of data (32 tables, 10M rows each) and a 4GiB buffer pool. The cache devices were…_commit = 1 innodb_log_file_size = 1G innodb_log_files_in_group = 2 innodb_purge_threads = 1 innodb_fast_shutdown = 1 #not innodb options (fixed) back_log = 50 wait_timeout = 120 max_connections = 5000 max_prepared_stmt_count…

Filed Under: Benchmarks, Hardware and Storage, MySQL Tagged With: , , , , , , ,

Post: MySQL Users Conference - Innodb

May 9, 2007 By 6 Comments

… days as Innodb user when I found out ALTERing Innodb tables may take a lot of time. Fast Index creation will allow Innodb to build indexes by sorting rather by row by row…’m not sure if Heikki will find a way to count exact number of auto increment values needed or if we…

Filed Under: Events and Announcements Tagged With:

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

February 26, 2013 By 1 Comment

… InnoDB FTS blazingly-fast, …innodb_ft_config; +—————————+———+ | KEY | VALUE | +—————————+———+ | optimize_checkpoint_limit | 180 | | synced_doc_id | 1028261 | | last_optimized_word | | | deleted_doc_count | 0 | | total_word_count…of rows in I_S.innodb…

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

Post: InnoDB: look after fragmentation

November 5, 2009 By 12 Comments

…count(distinct username) | +—————————+ | 5903053 | +—————————+ 1 row in set (2 min 8.92 sec) mysql> SHOW STATUS LIKE ‘Innodb_scan_pages%’; +——————————+——-+ | Variable_name | Value | +——————————+——-+ | Innodb…

Filed Under: Insight for DBAs, MySQL Tagged With:

Post: SHOW INNODB STATUS walk through

July 17, 2006 By 40 Comments

… counters – “reservation count” and “signal count” show how actively innodb uses internal sync array …as number of locked rows – there are normally many rows for each lock …writes these logs writes are pretty fast. ———————- BUFFER POOL AND MEMORY ———————- Total memory…

Filed Under: Insight for DBAs Tagged With:

Post: Extending Index for Innodb tables can hurt performance in a surprising way

May 22, 2010 By 10 Comments

…) ENGINE=InnoDB AUTO_INCREMENT=6029313 DEFAULT CHARSET=latin1 mysql> select count(*) from idxitest where a=5 and b=5; +———-+ | count(*) | +———-+ | 60434 | +———-+ 1 row …. Application also had another query which previously ran so fast it hardly could be noticed. It however became a …

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

Post: Shard-Query EC2 images available

May 11, 2011 By 2 Comments

…following row count (the first number is wall time, the second exec time, the third parse time). $ echo “select count(*) …innodb-open-files=1000 innodb_fast_checksum innodb-purge-threads=1 innodb-read-ahead=linear innodb-read-ahead-threshold=8 innodb-read-io-threads=16 innodb-recovery-stats innodb…

Filed Under: MySQL

Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1

January 8, 2007 By 117 Comments

… to retrieve rows (more details with Jim Starkey’s comments in Part 2). There MyISAM shows bad scalability with increasing count of… bad for Falcon. InnoDB is better than MyISAM by 87% in case with 4 threads but drops down very fast. READ_PK… $tableName The hardest query performs a scan of all million rows. InnoDB is better than MyISAM by ~30% with 4-16 threads…

Filed Under: Benchmarks Tagged With: ,
« Older Posts