I’m facing several issues with MySQL Workbench on my MacBook Air (M1 chip). Here’s what’s happening:
Empty Database:
I downloaded MySQL and MySQL Workbench from the official site, and I imported the Sakila database. However, when I query the film table, it returns 0 rows. It seems like the database is empty despite the import process completing without errors.
Performance Issues:
After installing MySQL Workbench, my MacBook has started slowing down significantly. Additionally, when I try to save or import a script through the File tab, Workbench just keeps loading indefinitely and doesn’t complete the action.
Installation Details:
MySQL Version: 8.4
MySQL Workbench Version: 8.0.38 (latest)
Installation Method: Downloaded directly from the MySQL website (not via Homebrew)
Steps I’ve Taken:
Reinstalled MySQL and MySQL Workbench at least 10 times.
Tried different methods of importing the Sakila database, but the film table remains empty.
System Details:
MacBook Air (M1)
macOS (latest version)
Issues:
Sakila database is empty despite successful import.
MacBook performance is degraded after installing MySQL Workbench.
Unable to save or import files in MySQL Workbench just kept re-loading and stop.
Has anyone else experienced these issues on an M1 Mac? Any advice on how to resolve the empty database problem and improve performance would be greatly appreciated.
Thanks in advance!
mysql> show databases
-> ;
+--------------------+
| Database |
+--------------------+
| information_schema |
| mysql |
| performance_schema |
| sakila |
| sys |
| world |
+--------------------+
6 rows in set (0.01 sec)
mysql> USE sakila;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> SHOW FULL TABLES;
+----------------------------+------------+
| Tables_in_sakila | Table_type |
+----------------------------+------------+
| actor | BASE TABLE |
| actor_info | VIEW |
| address | BASE TABLE |
| category | BASE TABLE |
| city | BASE TABLE |
| country | BASE TABLE |
| customer | BASE TABLE |
| customer_list | VIEW |
| film | BASE TABLE |
| film_actor | BASE TABLE |
| film_category | BASE TABLE |
| film_list | VIEW |
| film_text | BASE TABLE |
| inventory | BASE TABLE |
| language | BASE TABLE |
| nicer_but_slower_film_list | VIEW |
| payment | BASE TABLE |
| rental | BASE TABLE |
| sales_by_film_category | VIEW |
| sales_by_store | VIEW |
| staff | BASE TABLE |
| staff_list | VIEW |
| store | BASE TABLE |
+----------------------------+------------+
23 rows in set (0.00 sec)
mysql> SELECT COUNT(*) FROM film
-> ;
+----------+
| COUNT(*) |
+----------+
| 0 |
+----------+
1 row in set (0.00 sec)
user26807587 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.