All Questions
9 questions
0
votes
1
answer
199
views
mysql partition on categorical fields and timestamp column which is varchar
Currently we have table:
CREATE TABLE `T_TRANS` (
`CASE_ID` varchar(20) DEFAULT NULL,
`C_ID` varchar(20) DEFAULT NULL,
`C_ST_IND` smallint(6) DEFAULT NULL,
`D_DTTM` int(11) DEFAULT NULL,
`...
- 4,335
0
votes
1
answer
44
views
How to define Indices on huge table (>38.700.000 rows) using group by, where and order by clause
I'm trying to speed up my Queries on a huge MySQL-Table (more than ~38.700.000 rows) but I can't figure out what to do. I read dozens of related Articles and even messed around with the MySQL-...
0
votes
1
answer
973
views
MySQL partitioned table works slower than equivalent unpartitioned table
Help!
I have a table in MySql (without partitioning) with ~4 500 000 rows:
CREATE TABLE stat_accounts_history (
id bigint(20) NOT NULL AUTO_INCREMENT,
accountId bigint(20) DEFAULT NULL,
month ...
0
votes
2
answers
534
views
In MySQL partitioning a table, how is the DIV used here as part of the HASH partition definition?
I was reading about partitioning and somewhere I read the following example:
HASH (id DIV 1000000)
This can be used to create a new partition for each million rows inserted (id is the primary key).
...
- 19.6k
2
votes
2
answers
226
views
MySQL Partitioning: SELECT by ID, but DELETE by date
Consider the following table:
CREATE TABLE `event` (
`uid` bigint(13) NOT NULL,
`time` bigint(14) NOT NULL,
`type` smallint(5) NOT NULL,
`msg` varchar(2048) DEFAULT NULL,
KEY `uid` (`uid`),
...
- 21
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
2
votes
1
answer
8k
views
MySQL performance with large number of records - partitioning?
I am trying to build a database that would contain a large number of records, each with a lot of columns(fields) - maybe around 200-300 fields total for all tables. Let's say that I would have in a ...
- 2,550
0
votes
0
answers
152
views
How to partition a mysql table after the table is already created
I am trying to partition my table so I can narrow down the record so accessing data won't take as long as it is taking now.
this table that I want to partition has 2 key fields
(1) 'tigger_on' which ...
- 40.4k
0
votes
1
answer
135
views
MySQL DB: performance and partitioning
I've migrate an access DB to a MySQL DB. In particular, in this DB I've a table with almost 5 million of rows. The most part of operations on this table are queries (filters to select a data subset).
...
- 3,588