…SSB Flight #2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB when the database … than InnoDB both cold and hot. SSB Flight #4 There is one query in this flight, Q4.3… recommended to prevent assorted security risks symbolic-links=0 innodb_stats_persistent innodb_stats_auto_update=off […
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…bounds. This is, however, only a hypothesis. vCache vs. FlashCache – dirty page threshold Finally, we examine the…size = 128M innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log_…= 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp_table_size…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…_Host: 127.0.0.1 Master_User: test Master_Port: 3306 Connect_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log…_Host: 127.0.0.1 Master_User: rsandbox Master_Port: 35301 Connect_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log…_Host: 127.0.0.1 Master_User: rsandbox Master_Port: 18675 Connect_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m…= 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 #default_table_type = InnoDB thread_stack…_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql….
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
….4 Single core VM 528M RAM Host-Only network 1 Box with http/php, 1…benchmark: // Identical config/code for memcached vs InnoDB $frontendOpts = array( ‘caching’ => true, ‘lifetime’ => 3600, …$totalTimeStore / 100000; $timer->start(); for ($i = 0; $i < 10; $i++) { for ($i = 0; $i < 100000; $i++) { $obj…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… 0.00 0.21 1052.67 0.41 8455.97 4.94 4227.98 2.47 8.03 1.01 0.96 0.96 101.44 dm-0 0.00 0… 0.20 526.77 1.01 130724.54 9.74 65362.27 4.87 247.70 0.27 0.52 0.52 27.22 dm-0 0.00 0.00 542.60 0…
Post: Watch out for Marketing benchmarks
August 23, 2006 By 7 Comments
… 5.0 Benchmarks Whitepaper and guess which type is this ? You can also compare it to my MySQL Performance 5.0 vs 4.1 presentation to have some fun. What can we see ? Out of all MySQL 4.1 vs 5.0 benchmarks which were done only benchmarks which show MySQL 5.0 is faster were selected and…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… execution time, the number of tmp tables created in memory vs on-disk, percentage of queries that needed full scan, InnoDB…_hits # 10 0x88BA308B9C0EB583 0.0905 1.1% 4 0.0226 1.00 0.01 SELECT poller_item # 11 0xD0A520C9DB2D6AC7 0.0850 1.0% 125 0.0007 1.00 0.00 SELECT wp_links…_taxonomy # 12 0x30DA85C940E0D491 0.0835 1.0% 542 0.0002 1.00 0.00 SELECT wp_posts # 13 0x8A52FE35D340A347 0.0767 0.9% 4 0.0192 1.00 0.00 TRUNCATE TABLE…
Comment: InnoDB benchmarks
January 3, 2007 By 15 Comments
Pete, I don’t think the reason of degradation is debug code. If you look at our peresentation 5.0 vs 4.1 http://www.mysqlperformanceblog.com/files/presentations/UC2006-MySQL-5.0-vs-4.1.pdf you will see 5.0 release has degradation comparing to 4.1.
Page: Presentations
May 3, 2006 By
… 5.0 vs 4.1 MySQL Users Conference 2006, Santa Clara, CA This presentation shows in numbers performance differences in MySQL 4.1 and 5.0, showing… application design practices. Download MySQL: New Features in versions 4.1, 5.0, 5.1 Open Source Forum 2005, Moscow, Russia Presentation speaks about…
