partitioning

I'm using a partitioned postgres table following the documentation using rules, using a partitioning scheme based on date ranges (my date column is…

I have a large table that I'd like to partition by user_id. However, a large portion (40% or so) of the table has user_id 0, which means the content…

Does anybody has experience of using partitioning feature in conjunction with the Doctrine2 library? The first problem is that Doctrine creates…

I'm partitioning a very large table that contains temporal data, and considering to what granularity I should make the partitions. The Postgres…

Hi, I need to partition a MySQL table amongst temporal data (field begin in the following table). CREATE TABLE `table1` ( `id` bigint(20) NOT NULL…

MySQL I have two columns. Col1 contains a list of IDs, Col2 contains a list of numbers (ranging between -100 and 200+). I want the COUNT(IDs) WHERE…

Here is my statement ALTER statement: ALTER TABLE MY_TABLE PARTITION BY RANGE(EVENTID) ( partition p001 VALUES LESS THAN (9000) , partition p002…

I have a table that's partitioned by range on id, and by hash on code (both are integers). 30 partitions, 4 hashed subpartitions apiece, 120 total.…

I have a partitioned mysql table, and I need to insert hundreds of millions of rows. What are the performance implications if I simultaneously…

hello, i am developing an application that will use three tables. 1 - 1 million rows of products. 2 - 500 million rows of users. 3 - 10 billion rows…

I'm a developer of a social game where we have almost 2 millions players(and this number is growing). The master MySQL DB server has 24 Gb RAM and…

Hi, I'm looking for the approach in testing performance of SQL queries in different conditions. For example I have 2 tables with identical structure…

Hello all, I want to partition a big table I have by date. (Partition it per month) Then I want to partition each partition again on a given ID. I…

Hi, We are trying to put several Tb in to MySQL Cluster, unfortunately the index does not fit in to memory. Are there way to overcome this…

Hello all, I have a problem with the partitioning and subqueries (mysql 5.1). Exactly when I'm executing select with subselect mysql skips…

I have the following example table... mysql> CREATE TABLE part_date3 -> ( c1 int default NULL, -> c2 varchar(30) default NULL, -> c3…

I don't know you but I, I have lost DB data several times when I decide reinstall an OS... Yes, I know... please don't say it. So is not first time…

Hello, I am setting up a server with the following specs: * Qty 4 Processors (AMD Opterons with 12 cores each) * 32 GB Memory * Qty 8 HDD (15K SAS…

Hello, I am setting up a server with the following specs: * Qty 4 Processors (AMD Opterons with 12 cores each) * 32 GB Memory * Qty 8 HDD (15K SAS…

Given the following table partitioning under PostgreSQL 9.0.3: CREATE TABLE records ( ts TIMESTAMP, ... ); CREATE TABLE records_2010 ( CHECK (ts…