All Questions
15 questions
0
votes
2
answers
140
views
MySQL partition by foreign key
I have a chat database in MySQL.
'users' table
user_id(PK), user_name
'chat' table
chat_id(PK), user1_id(FK), user2_id(FK)
'messages' table
message_id(PK), chat_id(FK), user_from(FK), ...
- 2,139
1
vote
1
answer
108
views
mysql database partition on extreme imbalance data?
2 million customers produce 2 billion orders in 2 years, but according to history data, 50% orders are belong to 100 top customers, so the data is extreme imbalance on customer id. the customers wish ...
- 461
0
votes
1
answer
3k
views
Partition By List and Range at the same time - Multiple Partitions MySQL
Is that possible in MySQL to use List and Range partitions together.
Let say
I have different categories and i want to put each category in "List Partition"
Now each category I want to create "Range ...
- 1,528
2
votes
2
answers
6k
views
How to handle large amounts of data in MySQL database?
Background
I have spent couple of days trying to figure out how I should handle large amounts of data in MySQL. I have selected some programs and techniques for the new server for the software. I am ...
- 4,047
1
vote
1
answer
3k
views
Best way to deal with Big data in mysql
Current Design
Previously my co-worker designed a databse which had tables like customer_0, customer_1.... to customer_9 wherby all the customer ids are split into 10 different tables based on the ...
- 3,232
1
vote
1
answer
148
views
Strategy to maintain large table of backup catalogs per project in MySQL or PostgreSQL
I am developing an LTO backup/restore solution based on gnu tar.
We either keep the tapes inhouse, or the customer might buy these backups from us.
Hence the choice of a widely available, and free ...
- 11
0
votes
2
answers
627
views
Performance in a 1 million row MySQL-table in a chess game scenario
Say I run a game website where the users play chess to each other. I have a MySQL-table that contain all the games with their individual chess moves:
Games table (psuedo syntax):
gameId INT
...
- 7,403
11
votes
8
answers
5k
views
Storing changes on entities: Is MySQL the proper solution?
i want to store changes that i do on my "entity" table. This should be like a log. Currently it is implemented with this table in MySQL:
CREATE TABLE `entitychange` (
`id` int(11) unsigned NOT NULL ...
3
votes
2
answers
3k
views
Vertical partitioning of tables in MySQL
Another question.
Is it better to vertically partition wide table (in my instance I am thinking about splitting login details from address, personal etc. details of the user) on a design stage or ...
- 4,014
11
votes
8
answers
7k
views
Mysql improve SELECT speed
I'm currently trying to improve the speed of SELECTS for a MySQL table and would appreciate any suggestions on ways to improve it.
We have over 300 million records in the table and the table has the ...
- 433
2
votes
1
answer
233
views
database partitioning explanation
I just read about database partitioning and still have some confusion about it.
So anybody please give me some explanations about what were changed in term of disk storage(like data file, index file, ....
- 18.1k
6
votes
4
answers
3k
views
Too many columns to index - use mySQL Partitions?
We have an application with a table with 20+ columns that are all searchable. Building indexes for all these columns would make write queries very slow; and any really useful index would often have to ...
- 1,309
1
vote
1
answer
595
views
Design recommendations for a history/audit table
I need to keep track of many items and their states throughout time.
Example
ItemId Location DateTime State
1 Mall A 2010-02-03 07:00 on_sale
1 Mall A 2010-02-20 08:22 ...
- 2,161
2
votes
1
answer
13k
views
mySQL KEY Partitioning using three table fields (columns)
I am writing a data warehouse, using MySQL as the back-end. I need to partition a table based on two integer IDs and a name string. I have read (parts of) the mySQL documentation regarding ...
- 5,721
3
votes
2
answers
3k
views
Partitioning a database table in MySQL
I am writing a data warehouse, using MySQL as the back-end. I need to partition a table based on two integer IDs and a name string.
A more concrete example would be to assume that I am storing data ...
- 5,721