New answers tagged aws-aurora
0
votes
innodb fetch time, not query execution time
If this is the query:
SELECT profile_id FROM clients WHERE is_vip = 0
Then, INDEX(is_vip, profile_id) is the best you can do to improve speed. You say, "Both profile_id and is_vip have indexes&...
- 79.4k
1
vote
innodb fetch time, not query execution time
Networks are fast, but not infinitely fast. There is a rate of data transfer over a network, and you can do the math.
For example, 4.6M rows, assuming on average 40 bytes per row, that's about 175MB.
...
- 16k
1
vote
Amazon Aurora RDS - invalid undo record
Ultimately, unfortunately this required us reaching out to AWS support (and paying the 10% Business Support Plan tithe).
They determined that there was corruption in undo records associated with one ...
- 121
Top 50 recent answers are included