Skip to main content
John's user avatar
John's user avatar
John's user avatar
John
  • Member for 5 years, 10 months
  • Last seen more than 1 year ago
10 votes
2 answers
6k views

Innodb: after 48 hours of optimizing 10mb/sec write speed

9 votes
3 answers
14k views

Extreme performance loss due to moving from Mysql 5.7.23 to Mysql 8.0 (status, config included) [closed]

3 votes
1 answer
1k views

What difference does it make if my COLLATION_CONNECTION is utf8mb4_0900_as_cs or utf8mb4_0900_ai_ci

2 votes
1 answer
4k views

Innodb: When bulk inserting or updating - how to disable transactions?

1 vote
3 answers
6k views

Mysql 8: count(*) on INT primary is 13500 times slower than supposed to be. any innodb dev here?

1 vote
2 answers
61 views

mysql innodb index: better one big or many compact?

1 vote
2 answers
823 views

mysql - large table - index performance and query issue

0 votes
3 answers
982 views

Mysql: Any way to properly index 3 ENUM columns with the same options ? (A OR B OR C)

0 votes
1 answer
230 views

mysql 8 information_schema.processlist -> correct approach to cache it?

0 votes
0 answers
278 views

Mysql 8.0:Innodb index performance loss until server is dead. Performance perfect after index is re-created?

0 votes
0 answers
72 views

Mysql: extremely weird index behaviour on "SELECT WHERE IN"?

0 votes
1 answer
458 views

mysql, performance issue with FOR UPDATE query

-1 votes
1 answer
106 views

Mysql - index - optimization (two separate or a multikey)