Percona's MySQL & InnoDB performance and scalability blog
… don’t actually need to merge sphinx indexes – it does that on the fly. If you are using sphinxql, you can actually… the index looks as if it was one index, you can create a virtual index with type = distributed that has all the… “merged”. See here for some explanation. And btw, you don’t want to run indexer for the virtual index, you want…
… engine innodb status: —TRANSACTION BB0E42A, ACTIVE 3 sec fetching rows, thread declared inside InnoDB 334 mysql tables in use 4, locked…(s) MySQL thread id 38, OS thread handle 0x2b3c1c776940, query id 16838101 localhost root Copying to tmp table create table t as SELECT ld…
… approximately 12GB of data in the largest table. You can find the individual SSB query definitions in my previous … machine with a Xeon E5-2680 (8 cores, 16 threads) with fast IO (OCZ R4 1.6TB) and 128GB … only when the buffer pool is cold. Please don’t take away that you should be using MyISAM for …
… deployed in several ways, and that means you can choose a tailor-made path that best meets your needs. … (which has some caveats). Also, because of asynchronous replication, you can end up having inconsistent data on the nodes and encounter… single-threaded replication is not enough, people can use Percona XtraDB Cluster, which has some of its own caveats, but you can also…
Hi Moazam, 1) no, you don’t have to export databases, you can use the existing mysql data dir. But check http…
… MySQL replication to using replication using GTIDs 1. Temporary tables – CREATE and DROP TEMPORARY tables are not supported inside transaction. 2…) with innodb tables within the same transaction. The same issue can arise if slave host is using different storage engine for… BINLOG_FORMAT is not consistent on master/slave db. 3. CREATE TABLE …. SELECT – It is not supported to perform such type…
… only stable illumos distro designed for server usage, and it can be bought with an optional tech support agreement. OpenIndiana is… that pretty much dead project. The only thing I don’t like about OmniOS is that the illumos base currently lacks… of Linux based MySQL Masters using Pacemaker. Maybe you guys can get Galera working on OmniOS to solve our lack of…
…. [Don’t try more than 2; the additional work that the kernel has to do in reordering TCP packets can actually result… specific database, a set of databases, or specific tables; you can also configure the slave to replicate everything EXCEPT a specified… to use MySQL on top of something like that? I can‘t imagine the performance being all that fantastic, and I could…
… about in a previous post, we are also running our new Moving to MySQL 5.6 class. This class covers… Jose, CA Begins Thursday, June 13, 2013 , 9am – 5pm New York City, New York, USA Begins Monday, June 17, 2013 , 9am – 5pm…, register early and save even more as the 10% discount can be applied to the early registration price. Just use discount…
… you define large schemas, and what do you mean by can‘t cope? * Is this a concern regarding crashes of the tool, or certain features don’t work past N number of tables? In my experience, the… than a couple minutes. I haven’t tried pulling this schema into Workbench so I can‘t comment as to how well it…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.