https://forums.mysql.com/index.php Fri, 01 May 2026 06:50:58 +0000 Phorum 5.2.23 https://forums.mysql.com/read.php?10,741801,741801#msg-741801 https://forums.mysql.com/read.php?10,741801,741801#msg-741801
I am currently scaling the backend database infrastructure for our platform, LuvSMM, which processes a very high volume of concurrent REST API requests. We are trying to maintain an API response latency of under 200ms globally.

Right now, we are dealing with sudden traffic "surges"—sometimes thousands of concurrent requests hitting our endpoints simultaneously. The workflow is mostly fast SELECT queries (to check user balances), immediately followed by rapid, bulk INSERTs (queuing the new orders).

My questions are:
1. What is the best practice for managing connection pooling in MySQL when dealing with these sudden, massive spikes in API traffic?
2. Are there specific InnoDB settings (like `innodb_buffer_pool_size` or `innodb_flush_log_at_trx_commit`) that I should tweak to prioritize write speed and reduce database-level locking/latency?
3. Is it standard practice to queue these API insertions externally (using something like Redis) before writing to MySQL, or can MySQL handle the raw concurrency if tuned correctly?

I appreciate any guidance or documentation you can point me towards. Thank you for helping a newbie learn the ropes of enterprise-level database scaling!]]> Sarthak Sarthak Newbie Wed, 29 Apr 2026 07:27:29 +0000 https://forums.mysql.com/read.php?10,741800,741800#msg-741800 https://forums.mysql.com/read.php?10,741800,741800#msg-741800
I am looking for some architectural advice regarding a write-heavy database workload.

I manage the backend infrastructure for SMM Bear, a B2B digital routing platform for marketing agencies. Because our system relies on algorithmic drip-feed pacing, our core MySQL database handles a massive number of concurrent transactions. Specifically, our cron jobs are constantly reading queued orders, fetching data from external APIs, and writing back status updates (Processing, Completed, Partial) multiple times per minute.

We are using InnoDB. During peak hours, when thousands of status updates hit the database simultaneously, we are noticing some transaction queuing and occasional deadlock warnings in the logs.

My questions for the DBA experts here are:

For a queue-like table structure where a 'status' column is being updated constantly, what are the best practices for configuring innodb_buffer_pool_size and innodb_flush_log_at_trx_commit to maximize write throughput safely?

Do you recommend any specific indexing strategies to prevent row-locking bottlenecks when multiple API threads are trying to update different rows in the same table simultaneously?

Any advice on optimizing MySQL for a heavy, high-frequency API environment would be greatly appreciated!

Thanks,
Aaryan Sharma]]> Aaryan Sharma Newbie Wed, 29 Apr 2026 03:58:07 +0000 https://forums.mysql.com/read.php?152,741788,741788#msg-741788 https://forums.mysql.com/read.php?152,741788,741788#msg-741788
I use MySQL Workbench 8.0 CE for Windows.

I have a table of parameters : table PARAMS :

ParamTyp ParamNum ParamDescription
Type1 1 Description 1-1
Type1 2 Description 1-2
Type2 1 Description 2-1
Type2 2 Description 2-2
Type2 3 Description 2-3

on this table there is an index (just an ordinary index, not a primary key) on (ParamTyp, ParamNum).

I have another table of activity : table ACTIVITY :

create table ACTIVITY
(
Info1 <type>,
Info2 <type>,
MyTypeNum <same type as ParamNum in PARAMS table>
) ;

Now, what I’d like to do, is :

alter table ACTIVITY add constraint FK_ACTIVITY foreign key (MyTypeNum) references PARAMS(ParamNum) where ParamTyp = 'Type1' ;

in order to make sure that ACTIVITY.MyTypeNum has a value referenced in the « Type1 » parameters ; so that ACTIVITY.MyTypeNum could only have value 1 or 2 ; but not value 3 which does not exist for PARAMS.ParamTyp = 'Type1'.

But when I try, the alter table query makes an error :

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where ParamTyp = 'Type1'' at line 1

Is it because it’s possible, but the syntax I used is wrong (= the alter table query should be written differently) ?
Or is it just impossible to create a foreign key on filtered datas ?

Thanks for your answer and advices.

Regards,
Herve]]> Herve Anselme MySQL Workbench Tue, 28 Apr 2026 17:20:33 +0000 https://forums.mysql.com/read.php?3,741785,741785#msg-741785 https://forums.mysql.com/read.php?3,741785,741785#msg-741785 Dear MySQL users, We are pleased to announce the release of the following products: * MySQL Server 9.7.0, 8.4.9, and 8.0.46 * MySQL Shell, Router 9.7.0, 8.4.9, and 8.0.46 * MySQL 9.7.0 Connectors * MySQL NDB Cluster 9.7.0, 8.4.9, 8.0.46, and 7.6.38 These releases are recommended for use on production systems and are available in source and binary form for a number of platforms from our MySQL Community download pages at: https://dev.mysql.com/downloads/ Regardless of server version, always use the latest version of MySQL Clients, Tools, and Connectors as they support both MySQL Server 8.0 and 8.4 LTS too. Windows packages are available via the Installer for Windows or .ZIP (no-install) packages for more advanced needs. The point and click configuration wizards and MySQL products are available in the unified Installer for Windows: https://dev.mysql.com/downloads/installer/ Enterprise binaries for these new releases are available on My Oracle Support: https://support.oracle.com Choose the “Patches & Updates” tab, and then choose the “Product or Family (Advanced Search)” side tab in the “Patch Search” portlet. MySQL Enterprise binaries are also available on the Oracle Software Delivery Cloud: https://edelivery.oracle.com/ Developers can download MySQL Enterprise Edition from https://www.oracle.com/mysql/technologies/mysql-enterprise-edition-downloads.html Innovation releases are supported until the next innovation release, and are recommended for production use. The 8.0, 8.4 and 9.7 series will focus on security and bug fixes only. Please refer to the following for more information: https://dev.mysql.com/doc/refman/8.4/en/mysql-releases.html As of April 2026, with version 8.0.46, MySQL 8.0 reaches End of Life (EoL). MySQL 8.0 users are encouraged to upgrade to the latest MySQL 8.4 LTS or MySQL Innovation release. Changes since the previous releases can be viewed online: https://dev.mysql.com/doc/#current-release-notes On Behalf of the MySQL Engineering Team, Balasubramanian Kandasamy ]]> Balasubramanian Kandasamy Announcements Mon, 27 Apr 2026 09:22:47 +0000 https://forums.mysql.com/read.php?11,741783,741783#msg-741783 https://forums.mysql.com/read.php?11,741783,741783#msg-741783 is it possible that you provide a tar.xz package for Debian 13?

With debian 12 i was using the generic linux package. But this does not work for debian 13 because of changed libs.


Thanks
Andi]]> Andreas SACHS Install & Repo Sun, 26 Apr 2026 19:30:46 +0000 https://forums.mysql.com/read.php?152,741782,741782#msg-741782 https://forums.mysql.com/read.php?152,741782,741782#msg-741782 Gil W MySQL Workbench Sat, 25 Apr 2026 13:37:15 +0000 https://forums.mysql.com/read.php?11,741781,741781#msg-741781 https://forums.mysql.com/read.php?11,741781,741781#msg-741781 could you check repository for communty? We are getting issue about missing package mysql84-community-release-el8-3.noarch.rpm but it is repoda.

Could you add missing package and rebuild repository?

404, message='Not Found', url='https://repo.mysql.com/yum/mysql-8.4-community/el/8/x86_64/mysql84-community-release-el8-3.noarch.rpm';]]> Michal Bartoš Install & Repo Mon, 27 Apr 2026 07:49:01 +0000 https://forums.mysql.com/read.php?11,741769,741769#msg-741769 https://forums.mysql.com/read.php?11,741769,741769#msg-741769
When I follow the steps on https://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/#apt-repo-fresh-install to install on Ubuntu, I'm getting this error:

Err:4 http://repo.mysql.com/apt/ubuntu jammy InRelease
The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 9D769D5183E7DDC8

I'm using the latest version of the apt-config repo (mysql-apt-config_0.8.36-1_all.deb), which still installs an older key:

$ gpg --show-keys /usr/share/keyrings/mysql-apt-config.gpg
pub rsa4096 2023-10-23 [SC] [expires: 2027-10-23]
BCA43417C3B485DD128EC6D4B7B3B788A8D3785C
uid MySQL Release Engineering <mysql-build@oss.oracle.com>
sub rsa4096 2023-10-23 [E] [expires: 2027-10-23]

There isn't a new key available either at https://repo.mysql.com/ (the latest is https://repo.mysql.com/RPM-GPG-KEY-mysql-2025 which is the old key).

Was there a key rotation yesterday? Will there be an update to the apt-config repo soon for the new key? This is blocking new repo-based installs on Ubuntu.]]> Jeff Erbrecht Install & Repo Thu, 23 Apr 2026 11:05:18 +0000 https://forums.mysql.com/read.php?26,741767,741767#msg-741767 https://forums.mysql.com/read.php?26,741767,741767#msg-741767
During replication, we are encountering the following errors:

* *Error Code: 1030* – Got error -1 from storage engine
* *Error Code: 1032* – Can't find record in table

We have tested both binlog-based and GTID-based replication, and the issue persists in both configurations.

Notably:

* There were no network interruptions during the incidents.
* No corresponding OS-level errors were observed.

We are trying to understand the root cause of these errors in a large, partitioned environment and how to resolve them without risking data inconsistency.

Any guidance on possible causes and recommended troubleshooting steps would be greatly appreciated.

Thank you.]]> Beekshan Chaki Replication Mon, 20 Apr 2026 08:34:47 +0000 https://forums.mysql.com/read.php?10,741766,741766#msg-741766 https://forums.mysql.com/read.php?10,741766,741766#msg-741766
i am new two MySQL and i am trying to setup my first project which is based on an existing DB (non MySQL).

Now i face a problem.

I have two tables: Departments and Persons. Both tables have unique primary keys.

Each department has a person as head of the department. 1:N This relationship formed no problem.

The second relationship says that every person can belong to a department. But this is not mandatory. So this relationship is 1:N but in the opposite direction.

When i try to send my model to the DB i get a nice little error message (as many i suppose):

Executing SQL script in server
ERROR: Error 6125: Failed to add the foreign key constraint. Missing unique key for constraint 'fk_tbl_persons_tbl_departments1' in the referenced table 'tbl_departments'
SQL Code:
ALTER TABLE `mydb`.`tbl_persons`
ADD CONSTRAINT `fk_tbl_persons_tbl_addresses1`
FOREIGN KEY (`per_adr_index`)
REFERENCES `mydb`.`tbl_addresses` (`adr_index`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_tbl_persons_tbl_departments1`
FOREIGN KEY (`per_dep_index`)
REFERENCES `mydb`.`tbl_departments` (`dep_index`)
ON DELETE NO ACTION
ON UPDATE NO ACTION

I am not sure if i am doing something here which is not possible or what the error might be or how i have to deal with this situation.]]> Magnus Müller Newbie Tue, 21 Apr 2026 05:15:57 +0000 https://forums.mysql.com/read.php?10,741759,741759#msg-741759 https://forums.mysql.com/read.php?10,741759,741759#msg-741759
Can't change the password using windows terminal because it says mysqld is not recognised.
Just kinda confused because I havent had any issue using mySQL in university or having to input a password to open connections there, not sure if i set something up wrong.]]> Javier Nguyen Newbie Wed, 29 Apr 2026 02:09:52 +0000 https://forums.mysql.com/read.php?149,741748,741748#msg-741748 https://forums.mysql.com/read.php?149,741748,741748#msg-741748 I'm not sure how Python is installed in your base image — is it provided via PYTHON_TARBALL in this script?
Is this a custom-built Python package maintained internally?]]> Bing Ma MySQL & Kubernetes Thu, 23 Apr 2026 11:39:27 +0000 https://forums.mysql.com/read.php?152,741713,741713#msg-741713 https://forums.mysql.com/read.php?152,741713,741713#msg-741713 ALL sql commands operate on the UNWANTED database.
There are aspects of this tool which are so useless!
Code entered in the editor, after copying from a text editor produce a sql error. yet copying the exact same code into the command line editor run fine.
Is workbench only able to connect to a single database?
It does not allow us to specify a paarticular one anyway.
This is the latest version too.]]> Nick Cole MySQL Workbench Tue, 28 Apr 2026 17:28:06 +0000 https://forums.mysql.com/read.php?10,741708,741708#msg-741708 https://forums.mysql.com/read.php?10,741708,741708#msg-741708 4:26:39 PM [main] Initializing Control Panel
4:26:39 PM [main] Windows Version: 64-bit
4:26:39 PM [main] XAMPP Version: 8.2.12
4:26:39 PM [main] Control Panel Version: 3.3.0 [ Compiled: Apr 6th 2021 ]
4:26:39 PM [main] Running with Administrator rights - good!
4:26:39 PM [main] XAMPP Installation Directory: "c:\users\administrator\desktop\xampp\"
4:26:39 PM [main] Checking for prerequisites
4:26:39 PM [main] All prerequisites found
4:26:39 PM [main] Initializing Modules
4:26:39 PM [Apache] XAMPP Apache is already running on port 80
4:26:39 PM [Apache] XAMPP Apache is already running on port 443
4:26:39 PM [mysql] MySQL Service detected with wrong path
4:26:39 PM [mysql] Change XAMPP MySQL and Control Panel settings or
4:26:39 PM [mysql] Uninstall/disable the other service manually first
4:26:39 PM [mysql] Found Path: C:\Users\Administrator\Desktop\XAMPP\mysql\bin\mysqld --defaults-file=C:\Users\Administrator\Desktop\XAMPP\mysql\bin\my.ini mysql
4:26:39 PM [mysql] Expected Path: c:\users\administrator\desktop\xampp\mysql\bin\mysqld.exe --defaults-file=c:\users\administrator\desktop\xampp\mysql\bin\my.ini mysql
4:26:39 PM [main] The FileZilla module is disabled
4:26:39 PM [main] The Mercury module is disabled
4:26:39 PM [main] The Tomcat module is disabled
4:26:39 PM [main] Enabling autostart for module "Apache"
4:26:39 PM [main] Enabling autostart for module "MySQL"
4:26:39 PM [main] Starting Check-Timer
4:26:39 PM [main] Control Panel Ready
4:26:40 PM [Apache] Autostart aborted: Apache is already running
4:26:40 PM [mysql] Autostart active: starting...
4:26:40 PM [mysql] Attempting to start MySQL service...
4:26:40 PM [mysql] Status change detected: running
4:26:47 PM [mysql] Status change detected: stopped
4:26:47 PM [mysql] Error: MySQL shutdown unexpectedly.
4:26:47 PM [mysql] This may be due to a blocked port, missing dependencies,
4:26:47 PM [mysql] improper privileges, a crash, or a shutdown by another method.
4:26:47 PM [mysql] Press the Logs button to view error logs and check
4:26:47 PM [mysql] the Windows Event Viewer for more clues
4:26:47 PM [mysql] If you need more help, copy and post this
4:26:47 PM [mysql] entire log window on the forums]]> Jie D Newbie Sun, 29 Mar 2026 20:34:29 +0000 https://forums.mysql.com/read.php?3,741688,741688#msg-741688 https://forums.mysql.com/read.php?3,741688,741688#msg-741688 ======================
As part of our continued focus on MySQL Community collaboration, we’re pursuing a three-pronged strategy:

1. Deliver innovation by introducing developer-focused features into MySQL Community Edition
2. Extend and enrich the ecosystem and adoption
3. Increase transparency and encourage broader community participation


What’s new in MySQL 9.7.0 (feature highlights)
======================
The release notes remain the authoritative source for complete details and final behavior. Highlights include:

* Flow-control monitoring for MySQL InnoDB Cluster (Group Replication)
* MySQL JSON Duality Views
* Hypergraph Optimizer
* Telemetry (OpenTelemetry / OTLP)
* Profile-Guided Optimization (PGO)
* Multi-threaded applier: extended applier statistics (new replication observability tables)

Early Access (EA) builds: intended for early feedback
======================
EA builds are pre-GA / developer preview packages meant for testing and feedback before GA. They may change prior to GA and are not intended for production use.

Download EA builds: https://labs.mysql.com/

Join the discussion (and help shape what’s next)
======================
Our next public MySQL Community discussion is on March 23:
Public MySQL Community Roadmap Discussion Webinar (Edition #2)
Registration: https://oracle.zoom.us/webinar/register/WN_KSzOt8qTRNm6q7ez-5ym_Q?_x_zm_rtaid=W8ywnK#/registration

Worklogs (WL): increased transparency
======================
We have also resumed publishing selected MySQL Worklogs (WL) to increase transparency and invite earlier design feedback:
https://dev.mysql.com/worklog/

More info and links
======================
* Blog post (full context + details): https://blogs.oracle.com/mysql/mysql-community-early-access-builds
* EA builds download page: https://labs.mysql.com/
* Webinar registration: https://oracle.zoom.us/webinar/register/WN_KSzOt8qTRNm6q7ez-5ym_Q?_x_zm_rtaid=W8ywnK#/registration
* Worklogs: https://dev.mysql.com/worklog/
* Report and view bugs: https://bugs.mysql.com/
* MySQL on GitHub: https://github.com/mysql/
* MySQL Community Slack channel: http://mysqlcommunity.slack.com/]]> Lenka Kašparová Announcements Wed, 18 Mar 2026 12:38:56 +0000 https://forums.mysql.com/read.php?152,741681,741681#msg-741681 https://forums.mysql.com/read.php?152,741681,741681#msg-741681 Why not have a list of users to manage?
Migration task list does NOTHING, CANNOT MIGRATE withoUT SPECIFYING WHAT TO MIGRATE FROM AND TO!
How do we specify where the data is stored?
cannot connect to a previous database set up under mySQL.

Someone clearly hasn't thought through these basic functional processes.
cannot bulk load data, and neither have hundreds of other people.]]> Nick Cole MySQL Workbench Tue, 28 Apr 2026 17:32:31 +0000 https://forums.mysql.com/read.php?26,741676,741676#msg-741676 https://forums.mysql.com/read.php?26,741676,741676#msg-741676
I have an issue with a cluster from 3 nodes and Group replication, oracle linux 9.7 and MYSQL CE 8.4.8.

Every time I restart the mysqld service the read_only and super_read_only remain ON.

If I check the cluster all nodes are online and primary and no errors (it`s a multi master).

What`s the problem ?

I`ve tried to set the /etc/my.cnf with setting:
read_only = OFF
super_read_only = OFF


but no success.

Once I restart mysqld service read_only came back to ON.

Thank you.]]> Mircea Ispasoiu Replication Mon, 23 Mar 2026 16:21:41 +0000 https://forums.mysql.com/read.php?10,741651,741651#msg-741651 https://forums.mysql.com/read.php?10,741651,741651#msg-741651
I’m new to MySQL and learning how to manage databases efficiently. I’ve noticed that some queries, especially when joining tables or filtering large datasets, can be slower than expected.

I’d love some advice on a few things:

How to use indexes effectively without slowing down insert/update operations.

Best practices for writing joins and subqueries to make queries faster.

Ways to monitor slow queries and find bottlenecks.

Tips on structuring tables and choosing the right data types for better performance.

Any guidance, examples, or beginner-friendly tips would be very helpful. I’m eager to learn from the community’s experience and improve my database skills.

Thanks in advance for your insights!]]> Funnelsflex Team Newbie Wed, 25 Feb 2026 18:07:39 +0000 https://forums.mysql.com/read.php?52,741646,741646#msg-741646 https://forums.mysql.com/read.php?52,741646,741646#msg-741646
I also get authentication errors now. I have root/ownership of the domain.

Ubuntu is the latest LTS release.

Can someone help?]]> Christopher Feeny PHP Tue, 24 Feb 2026 21:58:32 +0000 https://forums.mysql.com/read.php?10,741640,741640#msg-741640 https://forums.mysql.com/read.php?10,741640,741640#msg-741640
Ideally, I'd prefer to change it from the mysql cli in Linux as with the right command, that's probably super simple, the problem is I can't find the right command. Nothing I've found has worked.

I can get all the way down to looking the variable in the table after selecting the database, but I can't get further than that.

mysql> select * from my_variables\G;
*************************** 1. row ***************************
variable_id: 1
variable_name: padding_tile
variable_datetime_utc: 2026-02-21 19:04:23
variable_value: 754
variable_type: int


Could someone please tell me what command I'd need to run to change the 'variable_value' of '754' to something else? It seems this should be so simple, but I haven't been able to find a clear command.]]> David person Newbie Mon, 23 Feb 2026 10:46:03 +0000 https://forums.mysql.com/read.php?152,741629,741629#msg-741629 https://forums.mysql.com/read.php?152,741629,741629#msg-741629
I start the program, connect to a remote database and then exit the program. The program will no longer start from its shortcut. Task Manager reveals that it’s running as a background task, not as a service, just as a background task.

Killing the background task enables the program to start from its shortcut.

I did initially have MySql running as a service via xampp but I’ve subsequently uninstalled that service and rebooted. Still have the issue.

What’s going on?

Thanks in advance.

Ron James]]> Ron James MySQL Workbench Tue, 17 Feb 2026 17:19:31 +0000 https://forums.mysql.com/read.php?152,741622,741622#msg-741622 https://forums.mysql.com/read.php?152,741622,741622#msg-741622 Will I have any compatibility issues with your application?
How do I migrate?]]> PATRICK DIXON MySQL Workbench Fri, 13 Feb 2026 01:20:33 +0000 https://forums.mysql.com/read.php?11,741621,741621#msg-741621 https://forums.mysql.com/read.php?11,741621,741621#msg-741621
We are planning to upgrade from MySQL 8.0.36 (Community Edition) to MySQL 8.4, and before proceeding we would like confirmation/guidance from the MySQL community (or any official references) on the following:

Whether a direct in-place upgrade from 8.0.36 → 8.4 is supported (or if an intermediate upgrade step/version is recommended).

Any required pre-upgrade steps or mandatory fixes that should be completed prior to the upgrade.

Any known issues, upgrade advisories, or common pitfalls for this upgrade path.

Any deprecated or removed features in MySQL 8.4 that could impact existing workloads.

Environment details (for context):

Current version: MySQL 8.0.36 (Community)

Target version: MySQL 8.4 (Community)

Platform: [AWS EC2 ]

Application: Axway B2Bi (application layer already verified compatible with 8.4)

Thank you in advance for any guidance or links to relevant documentation.]]> Raja Pathri Install & Repo Thu, 12 Feb 2026 09:17:15 +0000 https://forums.mysql.com/read.php?10,741583,741583#msg-741583 https://forums.mysql.com/read.php?10,741583,741583#msg-741583
I am developing a web application using Python with either Flask or Django, and MySQL as the backend database. As the application grows, I want to manage database connections efficiently and avoid opening a new connection for every request.

I would like to know:

What is the recommended way to implement MySQL connection pooling in Flask or Django?

Which libraries or tools work best for connection pooling (SQLAlchemy, mysql-connector, PyMySQL, etc.)?

How should pool size and timeout values be configured for a production environment?

Are there any common mistakes or performance issues to watch out for when using connection pooling?

If possible, sample code snippets or real-world experiences would be very helpful.

Thanks in advance for your guidance.]]> harishma kumar Newbie Fri, 06 Mar 2026 18:14:05 +0000 https://forums.mysql.com/read.php?3,741575,741575#msg-741575 https://forums.mysql.com/read.php?3,741575,741575#msg-741575 Dear MySQL users, We are pleased to announce the release of the following products: * MySQL Server 9.6.0 Innovation, 8.4.8 LTS, and 8.0.45 * MySQL Shell, Router 9.6.0, 8.4.8, and 8.0.45 * MySQL 9.6.0 Connectors * MySQL NDB Cluster 9.6.0, 8.4.8, 8.0.45, and 7.6.37 These releases are recommended for use on production systems and are available in source and binary form for a number of platforms from our MySQL Community download pages at: https://dev.mysql.com/downloads/ Regardless of server version, always use the latest version of MySQL Clients, Tools, and Connectors as they support both MySQL Server 8.0 and 8.4 LTS too. Windows packages are available via the Installer for Windows or .ZIP (no-install) packages for more advanced needs. The point and click configuration wizards and MySQL products are available in the unified Installer for Windows: https://dev.mysql.com/downloads/installer/ Enterprise binaries for these new releases are available on My Oracle Support: https://support.oracle.com Choose the “Patches & Updates” tab, and then choose the “Product or Family (Advanced Search)” side tab in the “Patch Search” portlet. MySQL Enterprise binaries are also available on the Oracle Software Delivery Cloud: https://edelivery.oracle.com/ Developers can download MySQL Enterprise Edition from https://www.oracle.com/mysql/technologies/mysql-enterprise-edition-downloads.html Innovation releases are supported until the next innovation release, and are recommended for production use. The 8.0 and 8.4 series will focus on security and bug fixes only. Please refer to the following for more information: https://dev.mysql.com/doc/refman/8.4/en/mysql-releases.html Changes since the previous releases can be viewed online: https://dev.mysql.com/doc/#current-release-notes On Behalf of the MySQL Engineering Team, Balasubramanian Kandasamy ]]> Balasubramanian Kandasamy Announcements Fri, 23 Jan 2026 17:56:47 +0000 https://forums.mysql.com/read.php?10,741567,741567#msg-741567 https://forums.mysql.com/read.php?10,741567,741567#msg-741567 please help to achieve this.

I tried below in PhpMyAdmin Console but it returns NULL.

--- start
SELECT DATE_FORMAT(
STR_TO_DATE('Mar-2025', '%b-%Y'),
'%c-%Y'
) AS result;
--- end

thanks in advance.]]> Smith John Newbie Tue, 10 Feb 2026 12:19:58 +0000 https://forums.mysql.com/read.php?169,741564,741564#msg-741564 https://forums.mysql.com/read.php?169,741564,741564#msg-741564
We noticed that the following MySQL artifacts are no longer available in the MySQL Product Archives:

- MySQL Installer Community MSI 8.0.42
- MySQL Connector/ODBC 9.3.0 MSI
- MySQL Connector/J corresponding to MySQL 8.0.42

Other surrounding versions such as 8.0.41 and 8.0.43 are still present in the archive, but exactly these versions are missing.

We were using these versions as prerequisites in our enterprise product installer, and customers are now unable to download them from the official MySQL site.

Could someone from Oracle or the community please clarify:

1. Were these artifacts intentionally removed from the archives?
2. Was there any official announcement or document about this removal?
3. Is there any possibility these versions will be restored in the archives?
4. What is the officially recommended replacement version?

Thank you for your guidance.]]> Dhamotharan Sivaraman MySQL Installer for Windows Fri, 20 Feb 2026 04:59:52 +0000 https://forums.mysql.com/read.php?104,741563,741563#msg-741563 https://forums.mysql.com/read.php?104,741563,741563#msg-741563
I’m running MySQL on a small server and looking for general advice on improving performance. The database has moderate traffic, and I’d like to optimize it for efficiency and future growth.

Any recommendations on configuration settings, indexing, or tools for identifying slow queries would be appreciated.

Thanks!]]> John Ackerman MySQL Workbench - Database Migration Thu, 23 Apr 2026 11:48:42 +0000 https://forums.mysql.com/read.php?104,741559,741559#msg-741559 https://forums.mysql.com/read.php?104,741559,741559#msg-741559
I used mysqldump command to export databases to an sql file.
I was able restore only with mysql < database-file.sql. Nothing else worked.

Terminal and MySQL workbench worked fine, i can see schemas and tables.
I gracefully shut down the mysql server and rebooted the physical server.

After restarting the mysql server threw errors. Some databases, I believe mysql were MySAM engine. They need to be InnoDB engine.

I am starting the 3 day import again into a clean installation.
I will hold off on the reboot.

Can I alter if running?
How can I alter tables after import?

Is there a better way to backup mysql 5.7 databases for easier 8.0 import?

All the documentation I read recommends mysqldump. Never a mention of converting engines.

Thank YOu.]]> Vito Cavallo MySQL Workbench - Database Migration Tue, 28 Apr 2026 17:40:44 +0000 https://forums.mysql.com/read.php?10,741538,741538#msg-741538 https://forums.mysql.com/read.php?10,741538,741538#msg-741538 Alonzo Lattimore Newbie Thu, 08 Jan 2026 20:31:44 +0000