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
2 answers

MySQL Partition pruning on variable

I am trying to optimize a query that is taking almost 30 minutes to run. What I am trying to do is to take advantage of partition pruning to minimize the rows searched. The range of the variable by which the table is partitioned is a variable from…
Steve Ford
  • 58
  • 1
  • 4
0
votes
3 answers

SQL Server Scripting Partitioning

Had a good look on the net and books online and couldn't find an answer to my question, so here goes. Working on someone else's design, I have several tables all tied to the same partition schema and partition function. I wish to perform a split…
Simon
  • 196
  • 1
  • 2
  • 10
0
votes
2 answers

can i avoid creation of a foreign key constraint for a one-to-one relationship?

i want to use eclipselink to partition my database. for performance reasons i will have one table (entity A) replicated to all nodes and one table (entity B) that is hash partitioned over all nodes. Since every A has a one-to-one relationship with a…
Laures
  • 5,389
  • 11
  • 50
  • 76
0
votes
2 answers

SQL Server partition unnormalized data

I think there might be a way to partition this to find what I want, but I can't see it. I have some slightly unnormalized data about product sets: SetItemID ComponentItemID quantity IsPrimary 123 234 1 1 123 …
David Fox
  • 10,603
  • 9
  • 50
  • 80
0
votes
1 answer

Partitioning and Sequence Increment

I have table call it scdr_buz and have partitioned it on monthly basis, I have created trigger on insert which take care of upsert and create table if not present then upsert. I have sequence i_buz_scdr sequence with 1 increment but it's behavior…
sharafjaffri
  • 2,134
  • 3
  • 30
  • 47
0
votes
0 answers

Can I use partition relation tables?

Currently, I have one Table A (parent) with primary key as 'KeyID'. This table has 2 children-tables B and C. In table B, it has foreign key 'KeyID'. Same for table C. Below is schema for 3 tables: tblA (KeyID, POName, DateReceiver, Desc) tblB…
Thang Lang
  • 75
  • 1
  • 11
0
votes
1 answer

mysql partition pruning not work

I created a table with MySQL partition by hash(to_days(...)). CREATE TABLE `requestlog` ( `remotehost` varchar(40) DEFAULT NULL, `user` varchar(255) DEFAULT NULL, `request_time_str` varchar(40) DEFAULT NULL, `request_time` datetime NOT NULL…
lucemia
  • 6,349
  • 5
  • 42
  • 75
0
votes
1 answer

MySQL database with entries increasing by 1 million every month, how can I partition the database to keep a check on query time

I am a college undergrad working on a PHP and MySQL based inventory management system operating on a country-wide level. Its database size is projected to increase by about 1 million plus entries every month with current size of about 2 million. I…
user1593979
0
votes
2 answers

Which field should I use with Oracle Partition By clause to improve performance

I have an update statement that works fine but takes a very long time to complete. I'm updating roughly 150 rows in one table with some tens of thousands of rows exposed through a view. It's been suggested that I use the Partition By clause to speed…
dee
  • 609
  • 7
  • 16
  • 24
0
votes
1 answer

Read mysql table that grow continuously

I have a mysql table that already have 1 million records and will grow continuously. But this table is read heavy and slow performance. I want to speed it up. I know mysql sharding, partition and master/slave solution. But it unable to fullfil my…
Magic
  • 1,182
  • 2
  • 18
  • 28
0
votes
2 answers

generate list of partition name

I would like generate a list of partition without having to manually type them and I can also choose how many partition I want to create. I'm using partition by range. Please see below example. P_PARTITION_20120830 VALUES LESS THAN…
mysticfalls
  • 445
  • 5
  • 17
  • 28
0
votes
1 answer

Scaling DB2 to increase tps

I wanna have brainstorm with you guys all about scaling option that DB2 have. Hope can helped me to resolve the problem. I need to scale my DB2 database to anticipate flash crowd transaction to database server. My database can only serve around 200…
fritz
  • 121
  • 4
0
votes
1 answer

Can we use parallelism in analyzing partitions of a table?

It was taking hours to analyze the partitions. Are there any commands to parallelly analyze the partitions of a table?
user1403174
  • 27
  • 2
  • 12
0
votes
1 answer

mysql partition without unique field

i want to partition my table. the table is: create_table "multimedia", :force => true do |t| t.integer "id" t. binary "data" t.integer "device_id" t.datetime "created_at" end id is the…
Dabidi
  • 397
  • 5
  • 14
0
votes
1 answer

Does partitioning in mysql create tables or merely virtual tables?

When a partition is done in mysql , does it create tables or does it create virtual tables (i.e. views) which are pretty much stored queries accessed by a table name? Here is an example (although in Oracle, this is just used as an example - I am…
Travis J
  • 81,153
  • 41
  • 202
  • 273
1 2 3
…
73 74