… post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the InnoDB storage engine. In my testing… [mysqld] datadir=/mnt/mysql56/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_buffer_pool_size=64G innodb…=128k read_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage_engine=myisam tmpdir=/dev/shm innodb_undo_logs=32 innodb…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… modular system where the storage engines themselves owned their own metadata. This was a radical departure from the MySQL philosophy, and one that… in MySQL, the defines can still found in the source. Basically, it’s why we can’t have nice things (like default… of columns you can create. If you try setting the storage engine to InnoDB however, you will get an error message! The…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…storage configuration? After creating a vCache device with the default configuration, I started with a baseline HDD configuration for MySQL…percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration …
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…engine_logsblogpercona.commanual Com_show_engine_mutexblogpercona.commanual Com_show_engine…default_storage_engineblogpercona.commanual default_time_zoneblogpercona.commanual default_week_formatblogpercona.commanual defaults_extra_fileblogpercona.commanual defaults_fileblogpercona.commanual defaults…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… Innodb storage engine got dramatic performance improvements and is getting better in each new release. Also note the default storage engine changed to Innodb in MySQL 5.5, meaning you might need to set storage_engine=MYISAM if you’re…
Post: Should MySQL update the default innodb_log_file_size?
November 21, 2011 By 37 Comments
Now that InnoDB is the default storage engine in MySQL, is it time to update the default configuration for the InnoDB log file size (innodb…’t be left at their historical defaults for a production installation. MySQL 5.5 increased the default buffer pool size to something more… times two is okay as a default. What do you think? Write your suggestion for a default log file size into the…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… the demos, if you want to reload on your favorite storage engine or database About the cluster For best performance, there should….cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer-pool-instances=2 innodb…
Post: MySQL Northern European Customer Conference
October 17, 2007 By 7 Comments
… will be default transactional storage engine in MySQL 6.0 – I did not truly understand if it will be recommended transactional storage engine or just default storage engine will switch from MyISAM to Falcon. It was rather interesting to hear a lot about features of new storage engines…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
…been implemented outside of MySQL Storage Engine level for MySQL – reading rows in their physical order can be applied to most storage engines, it certainly can…about this feature, for example changing default value needs table rebuild even though for other storage engines it often could be done …
Post: Filtered MySQL Replication
November 7, 2007 By 8 Comments
… not a big fan of filtered or partial MySQL Replication (as of version MySQL 5.0) – there is enough gotchas with replication… when BLACKHOLE storage engine can come into the play. In the nutshell you can create intermediately slave which has BLACKHOLE as default-storage engine which…
