1 of 32

22 Reasons to move to MySQL 8� And 4 reasons not to�

Peter Zaitsev,

Founder at Percona

10 June 2023

2 of 32

Heatwave to melt Snowflake

© Percona

2

3 of 32

#1 MySQL 5.7 Goes EOL in October 2023

© Percona

3

4 of 32

#2 New Development Process

Get new Features Frequently, Rather than once every 2-3 years

​

© Percona

4

5 of 32

#3 Innodb based Data Dictionary

  • Atomic, Crash Safe DDLs
  • Crash Safe Grants
  • Much Faster Information Schema

​

© Percona

5

6 of 32

#4 More SQL, Better SQL

© Percona

6

Window Functions

CTEs (Common Table Expressions)

INTERSECT and EXCEPT

LATERAL JOIN

7 of 32

#5 Better Security

  • New Authentication Protocol
  • Support for More Authentication Plugins
  • Improvements to Transparent Data Encryption (TDE)
  • Improvements to TLS
  • Roles

© Percona

7

8 of 32

#6 UTF8 Default

And Proper (MB4) UTF8 that is !💕👍😉🧌

© Percona

8

9 of 32

#7 All Things Indexes

© Percona

9

Functional Indexes

Descending Indexes

Invisible Indexes

Multi Value Indexes (JSON)

Generated Invisible Primary Keys

10 of 32

#8 Better JSON Support

© Percona

10

11 of 32

#9 Improved Optimizer

Hash Joins among other things…

© Percona

11

12 of 32

#10 Improved EXPLAIN

© Percona

12

TREE Format

1

EXPLAIN ANALYZE

2

Default EXPLAIN Format

3

13 of 32

#11 Better Agility

Much more DDLs supported as ALGORITHM=INSTANT

© Percona

13

14 of 32

#12 SET PERSIST

New way to control MySQL Configuration

© Percona

14

15 of 32

#13 Optimizer Hints

© Percona

15

Number of new Hints Supported

SET_VAR to set some variables for query duration only

16 of 32

#14 Resource Management

Resource Groups to Prioritize or Restrict CPU Resources for some queries

© Percona

16

17 of 32

#15 NOWAIT an SKIP_LOCKED

Flexible handling of encountered row level locks

© Percona

17

18 of 32

#16 Proper AUTO_INCREMENT

Do not loose Auto Increment Counter value in Edge Cases

© Percona

18

19 of 32

#17 Temptable Storage Engine

  • Replaced aging HEAP for In Memory TMP Tables
  • Supports BLOBS

© Percona

19

20 of 32

#18 Undo Space

Separate Dynamically Sized location for Innodb Undo Space

© Percona

20

21 of 32

#19 Double Write

© Percona

21

Separate Location

Configurable

Detect Only Option

22 of 32

#20 Redo Logs

© Percona

22

Dynamically Sizable Online

Can be Disabled for faster data loading

23 of 32

#21 Better Concurrency

© Percona

23

24 of 32

#22 User Comments and Attributes

Store Meta-Data about user accounts directly in MySQL

© Percona

24

25 of 32

Why not Upgrade to MySQL 8 ?

© Percona

25

26 of 32

Heatwave

Is Oracle re-focusing MySQL Development on Proprietary cloud version only?

© Percona

26

27 of 32

New Development Process

  • Lack of Stability
  • Hard to downgrade
  • Quality Problems

© Percona

27

28 of 32

Performance

Performance at low concurrency with simple queries perceived to be lower

© Percona

28

29 of 32

Sharding

No Built In transparent “Scale Out” Option makes developing large scale applications hard

© Percona

29

30 of 32

Question

Know Even Better “MySQL” ?

© Percona

30

31 of 32

31

Want to know more about Percona Software For MySQL?

QR Code goes here

32 of 32

Thank you, Let’s Connect!

​

https://www.linkedin.com/in/peterzaitsev/

https://twitter.com/PeterZaitsev

http://www.peterzaitsev.com

​