Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with mysql
Search options not deleted
user 8393
All versions of MySQL (not Microsoft SQL Server). Please also add a version-specific tag like mysql-5.7 if that is relevant to the question.
4
votes
1
answer
2k
views
Impact of using UUIDs with an UNIQUE index vs. PK?
It's well known how the performance of random UUIDs as PKs in an InnoDB table degrades terribly as it increases in size. Would an UNIQUE index for a non-PK UUID column have the same impact?
UUIDs are …
- 328
2
votes
1
answer
81
views
Query difference with where condition
I need to find the ids of all rows in a table A without a matching row on table B. Following the answer on this question I'm using a left join like this:
select A.id from A left join B on B.id_A = A. …
- 328
3
votes
3
answers
7k
views
Query 'optimizing' state is taking too long
I have a MySQL 5.6 on Amazon RDS that I'm using for testing some data archiving scripts. I'm removing oldest data based on a "updated_date" column and index. …
- 328
2
votes
1
answer
808
views
Is the Memory engine adequate for a read intensive/lookup table?
I have an InnoDB table with just two columns, a VARCHAR(20) and a DATETIME, and around 4M rows. This table serves as a blacklist for other tables, and is truncated and recreated from a csv file from t …
- 328
3
votes
2
answers
4k
views
How to check innodb history list length?
The output for show engine innodb status has the history list length as a number, but that output is hard to parse, and there's just too much data when all you want is a single value. Is the value ava …
- 328
4
votes
Accepted
How to check innodb history list length?
It would be nice if someone familiar with the MySQL source code could confirm it. …
- 328
3
votes
1
answer
2k
views
innodb_flush settings on Amazon RDS
Setting innodb_flush_log_at_trx_commit = 2 improves my application performance considerably on my local development environment. The response time and number of requests per second on a 40 concurrent …
- 328