Server Fault Stack Exchange
Server Fault Stack Exchange

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…
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…
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
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…
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…
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…
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:…
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', …
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…
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…
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…
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 …
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…
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
1
2