…specific tables; you can also configure the slave to replicate everything EXCEPT a specified set of databases and tables. With this method, every event is…a relay master (it can be on the same machine if you use the BLACKHOLE storage engine…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
…used to only get three characters after a dot in a… either something UNIREG specific or it’s…storage engine to InnoDB however, you will get an error message! The exact error message you get is…which is exactly the same as what I can create. That’s right folks, in MySQL 5.6 you can create a table with a…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…is a very fast PCIe SSD, would it make more sense to configure MySQL as if it were using SSD storage or to just use…specific…table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration A…
Post: The Doom of Multiple Storage Engines
May 8, 2010 By 22 Comments
…which prevents from having hot backup in many cases. Replication Support for different storage engines is a…using multiple storage engines in the query you need to test all kinds of combination such as running multi-table…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
…used to make was – it is not really MyISAM specific. key_buffer was also used by now retired ISAM storage engine and could be used…is which storage engines you’re really using. So for example if you only have Innodb tables…
Post: Announcing Percona XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
…storage engine is 1.0.2-1, which is forked from InnoDB-plugin-1.0.2. Percona XtraDB is released under GPL v2, as is…storage engine using our own ideas, as well as incorporate improvements specifically…
Post: MySQL Error Message Nonsenses
March 16, 2008 By 7 Comments
…is Got Error XYZ from storage engine which could mean all sort of things. For example this may be Operating system specific…which can be portable across storage engines – for example something with meaning of “Storage engine is out of resources” together with ability for storage engine…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 64 Comments
…is most useful for complex expensive queries, for which tracking exact rows used from query syntax may be hard. Query Cache Storage Engines…which can have application-specific tunings to prioritize which queries are more important to refresh for given applications. As a Summary I believe there is a…
Post: Thank you for joining us at Percona Live, NYC 2012
October 7, 2012 By 1 Comment
…specific topics. We also added an Expo Hall which allowed a…storage engine is…is quite respected number. Akiban Technologies have been showcasing their table…is also specially built for Multi-Tenant SaaS applications which is a…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…which resulted in an almost 8x speedup. having tmpdir on a fast storage is…used for a specific table. There’s also a number of cases when this optimization is not applicable: UNIQUE indexes in ALTER TABLE…
