Stack Overflow
Stack Overflow

Questions tagged [database-partitioning]

Database partitioning is the act of splitting a database into separate parts, usually for manageability, performance or availability reasons.

Database partitioning is done in one of two ways:

  1. vertically - reducing the number of columns in tables while increasing the number of tables

  2. horizontally (also called sharding) – splitting rows up into multiple tables based on key values. An example would be moving all the rows for each geographic region (such as a country) into their own tables.

Related questions:

Related tags:

1096 questions
0
votes
1 answer

mysqldump with partitioned table

I have a large MyiSam table and I recently partitioned it. I backup the db every day usng mysqldump but rather than bakcup the entire large table, I'd like to just backup certain partition(s). Is there any way that I can specify which partitions to…
Russ
  • 115
  • 1
  • 2
  • 9
0
votes
2 answers

Performance in a 1 million row MySQL-table in a chess game scenario

Say I run a game website where the users play chess to each other. I have a MySQL-table that contain all the games with their individual chess moves: Games table (psuedo syntax): gameId INT player1Id INT player2Id INT gameEnded DATETIME…
cederlof
  • 7,206
  • 4
  • 45
  • 62
0
votes
1 answer

postgresql partition check on hstore field

i have a master table that i am partitioning. everything is fine, except that one of the fields is a hstore type and i would like the CHECK on the partition creation to check against that hstore key's value: CREATE TABLE master_table ( id…
yee379
  • 6,498
  • 10
  • 56
  • 101
0
votes
1 answer

how to use vars in the command "create partition" with mysql

I want to create an event that every 15 days executes a procedure. This procedure must to create a new partition. I am doing the following: /*Vars v_tab --> logic tables's name v_year --> year... to use it as part of name v_fech --> this is used to…
David Mart
  • 73
  • 1
  • 4
0
votes
2 answers

postgreSQL get last ID in partitioned tables /

my question is basically the same as this one, but i couldn't find an answer, its also written "to be solved in the next release" and "easy for min/max scans" PostgreSQL+table partitioning: inefficient max() and min() CREATE TABLE mc_handstats ( …
Chris
  • 129
  • 1
  • 2
  • 11
0
votes
1 answer

Mysql puts all data in one partition

I've a 30M rows table and I want to partition it by dates. mysql > SHOW CREATE TABLE `parameters` CREATE TABLE `parameters` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `add_time` datetime DEFAULT NULL, ...(etc) ) ENGINE=MyISAM…
imilbaev
  • 864
  • 12
  • 19
0
votes
1 answer

From where will I get vertically partitioned dataset for mining association rules?

I am working on project privacy preserving data mining for association rules, for that I require sample vertically partitioned binary data set. Can anyone help me?
user1960147
  • 1
  • 1
0
votes
1 answer

Does Amazon RDS Oracle support partition or not?

Recently I'm evaluating the feasibility to migrate current application to Amazon RDS Oracle, since the scale of the data becomes larger and larger. I want to know whether Amazon RDS Oracle could support partition or not. If yes, how to configure it?…
ciphor
  • 8,018
  • 11
  • 53
  • 70
0
votes
1 answer

How to partition by mysql table into two layers?

I want to partition a table this code will show you the structure of the table. the table currently have about 5 million records. I need the MySql partition syntax this table like so Main partition is the filed trigger_on Partition type range "by…
Jaylen
  • 39,043
  • 40
  • 128
  • 221
0
votes
0 answers

How to partition a mysql table after the table is already created

I am trying to partition my table so I can narrow down the record so accessing data won't take as long as it is taking now. this table that I want to partition has 2 key fields (1) 'tigger_on' which is a datetime field and I use this a lot as look…
Jaylen
  • 39,043
  • 40
  • 128
  • 221
0
votes
1 answer

Sharding schemes

I am looking for some sharding schemes, and I also need some literature on that. So far the ones I have found: - Key based partitioning - Vertical partitioning - Directory based partitioning Any more ideas on sharding? And i will be glad if you…
anvarik
  • 6,417
  • 5
  • 39
  • 53
0
votes
1 answer

On MySQL 5.1, how can I query a specific partition?

I need to run a query on a partitioned table, and I'd like a result by partition, like so: partition result count ----------- ---------- ------ p1 apples 2 p1 oranges 3 p2 apples 10 p2 …
mjuarez
  • 16,372
  • 11
  • 56
  • 73
0
votes
2 answers

Range partition table creation with large number of paritions

i have to create an range partitioned table with two hundred partitions. for eg: CREATE TABLE emp ( empno NUMBER(4), ename VARCHAR2(30), sal NUMBER ) PARTITION BY RANGE(empno) ( partition e1 values less than (1000) ,…
subodh1989
  • 696
  • 6
  • 13
  • 40
0
votes
1 answer

select max of a column using range partition

I have a Table which is range partitioned on numeric(parameterinstanceid) value. I want to select max+1 value of the same column .i have global non-partition index on parameterinstanceid. select /*+ parallel(a,32,8) */ max(parameterinstanceid) +1…
subodh1989
  • 696
  • 6
  • 13
  • 40
0
votes
1 answer

MySQL DB: performance and partitioning

I've migrate an access DB to a MySQL DB. In particular, in this DB I've a table with almost 5 million of rows. The most part of operations on this table are queries (filters to select a data subset). I'm interested in performance. The partitioning…
Sefran2
  • 3,578
  • 13
  • 71
  • 106
1 2 3
…
73 74