MySQL Performance: MySQL vs. MariaDB

Pros of Maria

• More Storage Engines Options
• Speed improvements
• Faster Indexes/Cache
• Speedier and Larger Connection Pool
• Improved Replication
• New Extensions/Features

Cons of Maria

• Missing Features
• Delayed MySQL Compatibility

https://www.liquidweb.com/kb/mysql-performance-mysql-vs-mariadb/

Run MySQL in Docker

$ docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:8.0.17

https://hub.docker.com/_/mysql

MySQL migration from 5.0 to 5.6

http://mysqlserverteam.com/upgrading-directly-from-mysql-5-0-to-5-6-with-mysqldump/


mysql> \s
--------------
mysql  Ver 14.12 Distrib 5.0.15, for Win32 (ia32)
Connection id:          3
Current database:
Current user:           ODBC@localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.0.15-nt
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    utf8
Db     characterset:    utf8
Client characterset:    utf8
Conn.  characterset:    utf8
TCP port:               3306
Uptime:                 4 days 6 hours 22 min 35 sec

Threads: 1  Questions: 11  Slow queries: 0  Opens: 0  Flush tables: 1  Open tables: 0  Queries per second avg: 0.000
--------------

C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin>mysqldump.exe -uroot --add-drop-table --all-databases --force > c:\temp\all-mysql-dbs.dmp --password Enter password: ****

uninstall mysql 5.0

mysql --uroot --password --execute="source c:\temp\all-mysql-dbs.dmp"

Enter password: ****