…it‘s safer to set up a relay master (it can be on the same machine if you use the BLACKHOLE storage engine… of SHOW PROCESSLIST that might be a sign that trouble is brewing. Or if you watch your MySQL…, but it‘s always possible to build something more involved if that’s what you need. Q: What MySQL HA…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… 2005. It was not very clear what that would mean for the MySQL ecosystem. A lot of focus was placed on the storage engine API… State of MySQL AB is delivered by Marten Mickos. It is truly a year of storage engines, focused on showing what is on top is what really… his critique of MySQL Management. Monty is working on the Maria storage engine to replace Innodb for a number of use cases. The first…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…it make more sense to configure MySQL as if it were using SSD storage or to just use an optimized HDD storage… to see what‘s actually … vCache both show improvements, but it‘s …mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL…
Post: MySQL opening .frm even when table is in table definition cache
November 21, 2011 By 8 Comments
…how the Storage Engine API is called. But back to what the above strace shows. In MySQL 5…..e. what storage engine it is. We can ignore the upper limit on number of storage engines for MySQL and …used is that in the DROP TABLE code path, MySQL uses this magic byte to work out which Storage Engine…
Post: Falcon Storage Engine Design Review
January 12, 2007 By 19 Comments
… does not use Spinlocks. It has its …MySQL Storage Engine level for MySQL – reading rows in their physical order can be applied to most storage engines, it…show themselves in practice. The other interesting point which I have not found much information about is regarding handling fragmentation – what…
Post: Troubleshooting MySQL Upgrade Performance Regressions
February 15, 2012 By Leave a Comment
…MySQL Server version and observing the difference. Sometimes though it might not show…storage engines it is possible for stats to be different for the same data because it uses…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
…storage engine, “Percona XtraDB”, which is based on the InnoDB storage engine. It‘s 100% backwards-compatible with standard InnoDB, so you can use it… what your engine can do. documentation Improvements to SHOW …use as drop-in plugin for existing MySQL-5.1.30 installation http://www.percona.com/mysql…
Post: Thank you for joining us at Percona Live, NYC 2012
October 7, 2012 By 1 Comment
…storage engine is the level of integration between MySQL…storage engine. It was great to see TokuDB benchmarks shown for Flash storage showing it is not only rotating media where Fractal Trees technology can show…what…
Post: Detailed review of Tokutek storage engine
April 28, 2009 By 21 Comments
…it is improved, because the engine itself is closed source. Along with its “fractal tree indexesâ€, TokuDB also uses…launchpad.net/mysql-patch/mytools What makes …not expected to show the same …MySQL 6.0, but I can’t yet say how it will work with mix of storage engines. – The Tokutek engine…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
…storage engines It works with MyISAM and Innodb and BDB, It also should work with Solid, PrimeXT and Falcon storage engines…what exactly you need to do to perform backup of MySQL Database (or create slave) using LVM2 on Linux. 1) Connect to MySQL… need to use SHOW SLAVE STATUS instead of SHOW MASTER …
