This blog post is part two in what is now a continuing series on the Star Schema Benchmark. In … #2 is similar to Flight #1. MyISAM is faster than InnoDB when the database is cold, but the opposite is true when the database is hot… join_buffer_size=8M default_tmp_storage_engine=myisam tmpdir=/dev/shm innodb_undo_logs=32 innodb_old_blocks_time=0 table…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…what to do with it. The other approach is to filter what gets written to the binary log… (what is reasonable is determined by your environment), it’s a safe bet that MySQL is up…is a “shared everything” system; there really isn’t anything quite like that in the MySQL world, except maybe MyISAM…
Post: Percona Server for MySQL 5.5.31-30.3 now available
May 24, 2013 By Leave a Comment
…. This feature implementation is considered BETA quality….log enabled and then restarted with the binary log disabled, Crash-Resistant Replication could overwrite the relay log info log…remote attacker to detect what user accounts exist …6 version, which removed MyISAM internal temporary table mutex …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… is, our PRIMARY KEY is not sequential anymore, which is bad for InnoDB, but this is what… innodb_log_file_size = 4G innodb_log_files_in_group = 2 innodb_log_block_size…myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G #myisam_max_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… that’s the case or at what point the performance is going to level off since… innodb_log_buffer_size = 128M innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log…_insert_buffer_size = 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam…
Post: Binary log file size matters (sometimes)
May 24, 2012 By 6 Comments
… MyISAM/InnoDB mix, not heavily loaded. We used pt-stalk (at that time it was aspersa stalk) trying to figure out what is…/db1-bin-log.003233 -rw-rw—- 1 mysql mysql 1073742566 Nov 3 08:35 /var/lib/mysqllogs/db1-bin-log.003234 What is happening here? Apparently, every time current binary log gets close to max_binlog_size in size, new binary log is created…
Post: Should you move from MyISAM to Innodb ?
January 12, 2009 By 59 Comments
… one is COUNT(*) without where clause which is often the show stopper for them move until it is worked around. Operations What is good for MyISAM kills Innodb, such as copying binary tables between the servers. It is important the… but I can perfectly use MyISAM (or Archive) for logging. Innodb Needs Tuning As a final note about MyISAM to Innodb migration I…
Post: What MySQL buffer cache hit rate should you target
June 29, 2006 By 5 Comments
…What cache hit rate is good for optimal MySQL Performance” is typical question I’m asked. It could by MyISAM…% for what would be 0% in many peoples mind. But what is even more important is hit ratio is not directly … are done and where do they come from (log writes, data/index reads etc) but you would…
Post: What is the longest part of Innodb Recovery Process ?
December 20, 2007 By 1 Comment
…always could be regulated by size of your Innodb log files so you could have it as large … amount of time. Plus worst of all there is serialization in the table cache and only one …if Innodb would finally optionally store stats, same as MyISAM so one could recompute them in background. Also …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…what is…myisam_recoverblogpercona.commanual myisam_recover_optionsblogpercona.commanual myisam_recover_optionsblogpercona.commanual myisam_repair_threadsblogpercona.commanual myisam_sort_buffer_sizeblogpercona.commanual myisam_stats_methodblogpercona.commanual myisam…
