… Units each) 1690 GB of instance storage 64-bit platform I/O Performance: …Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5…`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 /*!50100 PARTITION BY RANGE (transactionid) (PARTITION p0 VALUES LESS THAN (100000000) ENGINE =…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… MRR buffer size mrr_buffer_size. Both buffer sizes default to 256K in MySQL 5.6 and MariaDB 5.5 respectively, which… these lookups are performed in a single call to the storage engine and the counters Handler_read_key and Innodb_rows_read… used then there are two separate calls made to the storage engine to perform the index record read and then to perform…
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: 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: Filtered MySQL Replication
November 7, 2007 By 7 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…
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: XtraDB storage engine release 1.0.6-9
January 13, 2010 By 9 Comments
…_relax_table_creation Added extended statistics to slow log Adjust defaults with performance intention Added parameter to control checkpoint age Added…. Please report any bugs found on Bugs in Percona XtraDB Storage Engine for MySQL. For general questions use our Pecona-discussions group, and…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
…you got well performing baseline. Do not change storage engine at the same time eather. Make sure you…side load. Setting up 2 MySQL Servers side by side (for example with MySQL Sandbox) can especially be…because changes to the options (might be even defaults) or some more subtle plan changes which are…
