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

nodetool tablehistograms command returned "No SSTables exists, unable to calculate 'Partition Size' and 'Cell Count' percentiles"

command I ran was nodetool tablehistograms The bug was No SSTables exists, unable to calculate 'Partition Size' and 'Cell Count' percentiles I tried to calculate partition size for better selections on partition keys, but nodetool…
HulkZZH
  • 1
  • 1
-1
votes
1 answer

Mysql: how to optimize occasionally slow query where all indexes are set and tables are partitioned?

Consider the following query: SELECT * FROM product_related pr LEFT JOIN product p ON (pr.related_id = p.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pr.product_id = '" . (int)$product_id . "' AND…
Roman K.
  • 69
  • 6
-1
votes
1 answer

Query a Specific Partition of a Mainframe DB2 Z/OS Table

I am working with a Mainframe DB2 Table Customer_Details. Owner : GMMOM Columns : Name,EmployeeNo,Salary,Age Now, I have a few questions related to partitioned Tables. How do I identify if a table is partitioned? How do I find out the number of…
vazn
  • 1
  • 1
-1
votes
1 answer

How to create multiple column partitions for postgresql db, one for time range and one for specific sensor ID?

I have one application to store and query the time series data from multiple sensors. The sensor readings of multiple months needed to be stored. And we also need add more and more sensors in the future. So I need consider the scalability in two…
yyuankm
  • 295
  • 4
  • 22
-1
votes
2 answers

How to use partition on a join to get a count

I'm confused on how to get a count without using group by on a join I know I can get the desired results using group by, but the table joins are long and lots of selected headers with case statement so I was hoping to avoid that I'm sure I've seen…
jamheadart
  • 5,047
  • 4
  • 32
  • 63
-1
votes
1 answer

MySQL SELECT subquery from same table

I have partitioned by date (timestamp with simple index) table with ~1000000 rows. I need to get rows by date range + other optional columns criteria. Can I use subquery somehow for speed optimization? For example: select rows by date range (it…
RocketBoom
  • 139
  • 3
  • 10
-1
votes
1 answer

cannot partition this mysql table

I have an innoDB table named "transaction" with ~1.5 million rows. I would like to partition this table (probably on column "gas_station_id" since it is used a lot in join queries) but I've read in MySQL 5.7 Reference Manual that All columns used…
mOna
  • 2,341
  • 9
  • 36
  • 60
-1
votes
1 answer

renaming column for a partitioned table

I have a partitioned database environment with partitioned tables. Can I alter the column name for the table. I am aware that I cannot do that in following condition: it is being used in any views it is referenced in any in index definition it is…
Aryadhara Das Adhikari
  • 1
-1
votes
1 answer

Is there a benefit in creating a vertical partition of a table if only relevant columns are being selected anyway?

I am using MySQL 5.6. I have some tables that have upwards of 15-20 columns each. However, I am being careful to only select relevant columns in each of my queries. Would there still be some benefit (ex: performance-wise) in creating vertical…
Ian Spangler
  • 3
  • 3
-2
votes
1 answer

Passing a file path as a variable in SQL Server

I'm trying to add a file to a file group in order to create a partition in SQL Server. When I pass in a hardcoded file path to the the filename, the code works. But when I use a variable for the file path, I get an error Incorrect syntax near…
Awar Denen
  • 1
  • 1
-2
votes
2 answers

Get pairs of two records with highest average grade

I want to calculate the average grade of every record, and then get the two records with the highest average grade, per category. My grade table looks like this: userid | recordid | grade 123 | 1 | 8 123 | 2 | 1 123 | 3 …
stijnb1234
  • 184
  • 4
  • 19
-2
votes
1 answer

How to remove all list partition without dropping table structure

I have around 600 tables. How to drop list partition from oracle table without dropping table structure.
Prabakaran
  • 5
  • 3
-3
votes
1 answer

MYSQL Query Optimization with subqueries and joins

Hi I have 8 million row data and need to optimize Mysql query to fetch a row from that data. I am using below query but its server response time is too high that creating issue in page loading speed SELECT q.id , q.title , q.question …
Inderjeet Singh
  • 17
  • 4
-3
votes
1 answer

ORA-14511: cannot perform operation on a partitioned object

Deal All, I created a table with partitions and inserted data in tables. I mention tablespace for partitions correctly But i forget to mention tablespace for table. Now i tried to move tablespace for table by using "Alter Table INC_MDK Move…
user3797516
  • 1
  • 1
  • 1
-3
votes
1 answer

SQL Server Partitioining on Date field

Need help - How to create partition in SQL server which will held 2011, 2012, 2013 data in separate file groups. I'm struggling to understand between RANGE RIGHT or RANGE LEFT....
Conrad Jagger
  • 643
  • 6
  • 19
  • 31
1 2 3
…
73
74