Articles

In the video below, we take a closer look at MySQL DB Installation: Using MySQL Workbench to connect to MySQL DB and how to install the Mysql 8 Server. Let’s get started!

Source de l’article sur DZONE

10 MySQL mistakes

MySQL 8 is one of the most popular database engines. It can assist link thousands of databases to servers once configured correctly and at comparatively low prices. Additionally, as it’s such a common tool, you’re unlikely to run into issues where servers don’t acknowledge it or configure it to do what you want it to do.

There may be few situations when using MySQL 8 where you will not be able to access or use MySQL correctly. These can be very unpleasant situations, but they can be readily fixed. However, you must understand the issue before you search for the solution!

Source de l’article sur DZONE

The Short Version

I created > one billion InnoDB tables in MySQL 8.0 (tables, not rows) just for fun. Here is the proof:

$ mysql -A
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1425329
Server version: 8.0.12 MySQL Community Server - GPL
Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
mysql> select count(*) from information_schema.tables;
+------------+
| count(*) |
+------------+
| 1011570298 |
+------------+
1 row in set (6 hours 57 min 6.31 sec)

Yes, it took 6 hours and 57 minutes to count them all!

Source de l’article sur DZONE