MySQL 5.7 vs MySQL 8 Benchmark

preview_player
Показать описание
MySQL 5.7 vs MySQL 8 Benchmark, with WordPress
  1. Marcos Nobre
  2. MySQL 5.7
  3. MySQL 8
  4. Benchmark
  5. WordPress
Рекомендации по теме
mysql 5 7 0:04:10

mysql 5 7 vs mysql 8 do you need to upgrade to mysql 8

Ask Me Anything 0:08:15

Ask Me Anything about MySQL 5.7 to 8 Upgrade with Vinicius Grippa

MySQL 5.7 vs 0:01:29

MySQL 5.7 vs MySQL 8 Benchmark

MySQL Upgrade from 0:17:17

MySQL Upgrade from MySQL 5.7 to MySQL 8 using YUM repository | Tutorial 8

Reserved Keywords in 0:00:37

Reserved Keywords in a MySQL 5.7 to 8 Upgrade

Upgrade your MySQL 0:35:01

Upgrade your MySQL 5 7 and older Galera Clusters to MySQL 8 0 with no downtime

Стоит ли переходить 0:20:06

Стоит ли переходить на MySQL 8? Сравниваем версии 5.7 и 8.0 по скорости работы...

Why is the 0:03:43

Why is the AWS RDS MySQL 5.7 to 8.0 upgrade especially impactful?

MySQL Atomic DDL 0:01:13

MySQL Atomic DDL difference between 5.7 and 8.0

Upgrade Ihres MySQL 0:49:44

Upgrade Ihres MySQL 5 7 Galera Clusters auf MySQL 8 0 ohne Ausfallzeiten

How to Check 0:09:36

How to Check and Upgrade Your MySQL Version Easily

Upgrading to MySQL 0:52:12

Upgrading to MySQL 8 0 Michael Coburn at Percona

MySQL - Upgrade 0:06:42

MySQL - Upgrade de 5.7 para 8.0

MySQL is having 0:27:37

MySQL is having a bumpy journey

Mastering EOL Migrations: 0:46:22

Mastering EOL Migrations: Lessons learned from MySQL 5.7 to 8.0 with Amazon RDS [Cloud Masters #104]

Plan your MySQL 0:02:24

Plan your MySQL upgrade

Why We’re excited 0:23:14

Why We’re excited about MySQL 8

How to Upgrade 0:02:14

How to Upgrade to MySQL 8.0 – MySQL Database Tutorial

Upgrade MySQL 5 0:05:33

Upgrade MySQL 5 7 to 8 0 with APT on Ubuntu - MySQL Database Administration Practices

MySQL Day Milano 1:18:19

MySQL Day Milano 2019 - Da MySQL 5.7 a MySQL 8.0

MySQL Upgrade Checker 0:35:45

MySQL Upgrade Checker | MySQL Upgrade | Percona server 5.7 to 8.0.27 | MySQL Shell utility | Percona

Databases: How to 0:01:21

Databases: How to properly downgrade mysql 8 to 5.7 in centos 8?

Upgrading to MySQL 0:22:30

Upgrading to MySQL 8 0+, a more automated experience by Nisha Gopalakrishnan

MySQL Parallel Replication 0:55:47

MySQL Parallel Replication (LOGICAL_CLOCK): all the 5.7 (and some of the 8.0) details

Комментарии
Автор

I run MySQL database with hundreds of millions of records and response time is always a few milliseconds. I have no idea why yours is so slow. But on the other hand, to me WordPress is one of the worst database implementations in a popular product. It's just sad how bad WordPress, its codebase and especially the database design is...

harlycorner
Автор

try this: select or select EXTRACT(YEAR FROM NOW())); . I found mysql57 is faster for this and uses less memory.

youspag
Автор

Wasted my time to watch this.
Your test is useless.

You have installed WordPress and ran apache benchmark tool with 30 request concurrency to first page of site.

it’s invalid test method since here we see participation of external network conditions, nginx, php.

I want to see examples where:
1. You write code which inserts million rows of data to equally schemes table
2. You write code which requests for data in parallel and measure time

*testing suites should be directly connected to db over unix socket

anar-k-jafarov