Re: [Maria-discuss] doubt about merge table (10000+) with same structure

2015-09-23 Thread Justin Swanhart
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 *

Re: [Maria-discuss] doubt about merge table (10000+) with same structure

2015-09-23 Thread Justin Swanhart
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

Re: [Maria-discuss] doubt about merge table (10000+) with same structure

2015-09-23 Thread Roberto Spadim
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

Re: [Maria-discuss] doubt about merge table (10000+) with same structure

2015-09-23 Thread Rhys.Campbell
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:

Re: [Maria-discuss] select using date_sub produces unwanted milliseconds in results

2015-09-23 Thread Dan Ragle
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

Re: [Maria-discuss] select using date_sub produces unwanted milliseconds in results

2015-09-23 Thread Alexander Barkov
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