Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?

2014-10-30 Thread Jan Steinman
> From: Zbigniew > > Now to the point: considering, that the second column shall contain > about 100-200 different "labels" - so in average many of such labels > can be repeated one million times (or even more) What about using ENUMs? They have nearly the performance of INTEGERs, but you don't

Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?

2014-10-30 Thread Jan Steinman
> From: Zbigniew > > Now to the point: considering, that the second column shall contain > about 100-200 different "labels" - so in average many of such labels > can be repeated one million times (or even more) What about using ENUMs? They have essentially the performance of INTEGERs, but you

Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?

2014-10-30 Thread hsv
2014/10/29 20:56 +0100, Zbigniew Now to the point: considering, that the second column shall contain about 100-200 different "labels" - so in average many of such labels can be repeated one million times (or even more) - will it speed-up the selection done with something like "...WHERE la

Re: Which replication solution should I choose?

2014-10-30 Thread Heck, Walter
Hi Johan, it'll be a good ol' war story of the transition of a large 130k QPS MMM cluster to PXC, so come visit for sure. Here's the link to the session: http://www.percona.com/live/london-2014/sessions/moving-mysql-infrastructure-130k-qps-galera see you there :) cheers, On Thu, Oct 30, 2014 at

Re: Which replication solution should I choose?

2014-10-30 Thread Johan De Meersman
- Original Message - > From: "Walter Heck" > Subject: Re: Which replication solution should I choose? > > If you happen to be at the Percona Live conference next week in London I'm > speaking about Galera in a high performance setup as well. Ooo, very interested, especially if you're