You have a sharded table. You could probably use shard-query. If all tables
are in same schema, you will need to create a new "fake" schema for each table:
Create schema s1;
Create view s1.the_table as select * from real_schema.table1;
Create schema s2;
Create view s2.the_table as select *
Hi, I see the PK is the shard-key. In that case shard-query will search only
one table, but you will have to populate the mapping table so SQ knows in which
table to look.
Sent from my iPhone
> On Sep 23, 2015, at 7:55 AM, Justin Swanhart wrote:
>
> You have a sharded
Hi justin!
well, i have two options now... continue with many tables or create one big
table
my doubt is, show i continue with many tables, or create a big table and
use partition?
table have same create table struct
and the table have differ with the primary key value
for example primary key
Best thing to do it to try it but I suspect your hunch is correct.
Really, it would be a good idea to merge all your data into a single table.
Perhaps use partitioning
https://dev.mysql.com/doc/refman/5.5/en/partitioning.html which the optimizer
should be able to take advantage of.
From:
On 9/22/2015 5:12 PM, Alexander Barkov wrote:
On 09/23/2015 01:00 AM, Alexander Barkov wrote:
Hi Dan,
On 09/20/2015 12:53 AM, Dan Ragle wrote:
We're converting from MySQL 5.1 to MariaDB 5.5.44 and I'm hoping someone
can help clarify for me what's going on in the following scenario. In
Hi Dan,
On 09/24/2015 12:35 AM, Dan Ragle wrote:
On 9/22/2015 5:12 PM, Alexander Barkov wrote:
On 09/23/2015 01:00 AM, Alexander Barkov wrote:
Hi Dan,
On 09/20/2015 12:53 AM, Dan Ragle wrote:
We're converting from MySQL 5.1 to MariaDB 5.5.44 and I'm hoping
someone
can help clarify for
6 matches
Mail list logo