Questions tagged [table-partitioning]
The table-partitioning tag has no usage guidance.
16
questions
0
votes
1
answer
2k
views
SQL Server - How to split single mdf file into multiple, and partition table data across them?
In the hopes of improving SQL Server performance, I'd like to take my simple 1-file (1 mdf & 1 ldf) database and split up the mdf files (and maybe the ldf files) across multiple disk drives. I'm ...
1
vote
1
answer
653
views
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/...
2
votes
2
answers
4k
views
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=...
0
votes
1
answer
464
views
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,
...
1
vote
1
answer
5k
views
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 ...
0
votes
1
answer
254
views
"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 ...
0
votes
0
answers
89
views
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 ...
0
votes
1
answer
274
views
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 (...
1
vote
1
answer
640
views
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 ...
1
vote
1
answer
589
views
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 ...
9
votes
2
answers
2k
views
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 ...
0
votes
1
answer
60
views
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......
0
votes
1
answer
111
views
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 ...
0
votes
1
answer
2k
views
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 ...
0
votes
3
answers
786
views
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 ...
1
vote
2
answers
840
views
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 ...