… Changes in MariaDB” Sergei Golubchik, VP Architecture, Monty Program Ab Topic: “Storage Engines and Other Plugins: What’s New?” The Percona Live MySQL Conference… Percona. The discussion will focus on MySQL 5.6 and how MySQL must evolve if it is to remain competitive in the new world…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
Post: How to change innodb_log_file_size safely
July 9, 2011 By 17 Comments
… need to change MySQL’s innodb_log_file_size parameter (see How to calculate a good InnoDB log file size), you can’t just change the parameter in the my.cnf file and restart the server. If you do, InnoDB will refuse to start… means that InnoDB hasn’t started, and MySQL is trying to access a table with the InnoDB storage engine, which is failing, of course.
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 be… other storage engines it often could be done simply by changing meta data (it is not implemented in MySQL anyway though). Very interesting to see how…
Post: Power of MySQL Storage Engines
March 5, 2007 By 3 Comments
… changed and different optimizations may change internal code paths dramatically. I know number of projects being interested in special techniques applying to…of MySQL Storage Engine interface, which means it is also has to be implemented through hacks. In any case this is very interesting how it…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… the default storage engine changed to Innodb in MySQL 5.5, meaning you might need to set storage_engine=MYISAM if you’re relaying on tables to be created… to have upgrade testing done in the environment which is maximally close to production. Q: How safe is it to upgrade from MySQL 5.5 to…
Post: Trying Archive Storage Engine
November 12, 2006 By 7 Comments
…to try how much archive storage engine could help me in this case. Original Table: *************************** 1. row *************************** Name: requests_061111 Engine…mysql mysql 19 Nov 12 11:31 requests_061111.ARM -rw-rw—- 1 mysql mysql… on the table changed from 5 min to about 4 minutes…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
…to understand what has changed and what exactly changed for worse. I am speaking about MySQL upgrade – version change… baseline. Do not change storage engine at the same …to get new version to pick the old plan no matter how you try and you might be forced to change your application by changing how…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
…query syntax may be hard. Query Cache Storage Engines MySQL Query Cache now stores queries in local …not want changing that to have complete invalidation. Having the option to have some updates not to …is available which makes it hard to understand how exactly MySQL Query Cache is working in many…
Post: MongoDB Approach to Availability
April 30, 2010 By 2 Comments
…to MySQL Server but MySQL Cluster, especially in newer versions which implement “sharding”. Same as commit to NDB Storage engine does not normally mean commit to…to stabilize as well as later develop tools around them. How to check if 2 MongoDB nodes are indeed in sync ? How to…
Post: MySQL Storage Engines - PBXT
May 14, 2007 By 6 Comments
… to be fixed before stable release but performance effect of it is yet unknown – how…of databases you may see partial changes. Same applies to multi-versioning – if you’re using…MySQL has finally got a storage engine which needs VACUUM” So overall PBXT is very interesting project to watch and to…
