Questions tagged [table-partitioning]
17 questions
9
votes
2 answers
Speed up MySQL inserts with partitions on MyISAM with unique key
I have a large MyISAM table (~30M rows). At some point I've switched it to fixed row format, so now table takes ~40Gb on disk and 2Gb for indexes. Table has a unique index and there are 100 'insert on duplicate key update' queries per second. As…
![](../../users/profiles/92011.webp)
d0rc
- 91
- 2
2
votes
2 answers
How to create a EFI partition using PowerShell?
I would like to automate a script that creates an EFI partition.
Currently, one step is manual and requires to start DISKPART and execute these commands:
create partition efi size=100
format fs=fat32 quick label=SYSTEM
assign letter=S
How can I…
![](../../users/profiles/351774.webp)
SuperJMN
- 151
- 2
- 9
1
vote
1 answer
How to restore a saved partition table to another disk with parted
OS: Ubuntu 10.04
I have saved my partition layout from sda and want to restore it to my new disk sdb. I have used the following command to save the layout, but how can i restore it to my new disk using parted?
parted -ms /dev/sda print > sda.parted
![](../../users/profiles/229090.webp)
SteffenNielsen
- 467
- 4
- 15
1
vote
2 answers
Easy Table Partitioning in SQL Server 2005 for Fact Tables?
I've been reading the article at http://msdn.microsoft.com/en-us/library/ms345146(SQL.90).aspx in preparation for implementing some partitioning.
I have several tables I want to partition on a DATA_DT_ID integer, and I'd really like to be able to…
![](../../users/profiles/1903.webp)
Cade Roux
- 375
- 2
- 5
- 18
1
vote
1 answer
SQL Server Partitioning, best practices for creating partition scheme's and functions
I'm implementing Partitioning for the first time in SQL Server 2008r2. I've several large tables that I am partitioning.
My main question is should I use the same Partition Scheme and Function for all these tables, or should I create multiple…
![](../../users/profiles/106090.webp)
David Youngberg
- 11
- 1
1
vote
1 answer
SQL Server 2008 SP1 Transactional Replication of a Partitioned Table Generates StackDump
I have a partitioned table that is published for transactional replication. The SWITCH operations on this table appears to replicated to the subscriber even though the options to allow_partition_switch = 1 and replicate_partition_switch = 0 on the…
![](../../users/profiles/61423.webp)
electricsk8
- 65
- 5
1
vote
1 answer
Different output of parted and fdisk
I have a strange CentOS behaviour,
When I type parted -l command on my server I got following results :
Model: DELL PERC H730P Adp (scsi)
Disk /dev/sda: 5758GB
Sector size (logical/physical): 512B/4096B
Partition Table: gpt
Disk Flags:…
![](../../users/profiles/950893.webp)
Someone Sometime
- 23
- 4
0
votes
1 answer
Why are partitioned MySQL InnoDB tables twice as big as unpartitioned ones?
I have two InnoDB tables identical in every respect except for one being partitioned, and the other - not:
DROP TABLE IF EXISTS `simple_table`;
CREATE TABLE `simple_table` (
`date` date NOT NULL,
`item_id` bigint(8) NOT NULL DEFAULT '0',
…
![](../../users/profiles/205301.webp)
Grisha S
- 173
- 1
- 7
0
votes
1 answer
How does rebuilding partitioned table index affect table access?
RDBMS: SQL Server 2005 Standard Edition
I have a table with 1 billion rows.
What I would like to do is to vertically partition it with a partition function and apply a partition scheme with the function on a table, say BigTable with ID column as a…
![](../../users/profiles/1224.webp)
dance2die
- 1,961
- 7
- 31
- 40
0
votes
3 answers
Partition 500gb of database stored in SQL Server
I have 500GB of database stored in SQL Server. Because it has too big a database, it takes time to update and insert data. Now the case is that I want to partition the data. So which partitioning techniques should I use? Or is there any other…
Devendra
0
votes
1 answer
"Can't create table" when having to many partitions
I am currently having a problem I dont understand. Wherever I look it says mySQL (5.5) / InnoDB doesnt have a table limit.
I wanted to test the InnoDB compression and was about to create an empty copy of an existing table and ran into the following…
![](../../users/profiles/176227.webp)
Chris
- 104
- 2
- 12
0
votes
0 answers
SQL Server Table Partitioning and my data lifetime management
My application stores data on Enterprise edition sql server, and I plan to take advantage of table partitioning to manage data retention. Each partition will hold a predefined period of time (say one week) and the user knows that. The user may have…
![](../../users/profiles/86821.webp)
sOltan
- 63
- 7
0
votes
1 answer
Partition PostgreSQL table based on FK attribute
I want to parition my huge table to solve a performance issue, but the attibute on which I want to parition my table resides in another table that is related by FK.
Here are my tables:
Article (Table1)
id
submit_date
...
Concept (Table2)
id
…
![](../../users/profiles/98385.webp)
dragoon
- 103
- 2
0
votes
1 answer
SQL2008R2 Partitioning query
We have a complex query that returns results in 45 secs when run from the 01-05-11 to the 31-05-11, but when it is extended to the 01-06-11 it runs indefinately... THe tables are partition by month...
I think the indexes are aligned as they where…
![](../../users/profiles/78873.webp)
Chris Wood
- 133
- 5
0
votes
1 answer
How to get optimal drive performance for a DB on SQL Server 2008 R2 Enterprise Ed.?
So I am pretty green when it comes to hardware configurations.
I just asked a coworker and he said we're using RAID 60 (I assume is the same as RAID 6+0).
I am doing some tests on a large table (1 billion rows), and setup a different partition for…
nycgags