Forum for New Users of MySQL. https://forums.mysql.com/list.php?10 Sun, 09 Aug 2026 12:52:55 +0000 Phorum 5.2.23 https://forums.mysql.com/read.php?10,741950,741950#msg-741950 https://forums.mysql.com/read.php?10,741950,741950#msg-741950 How can I minimize this window?]]> Joachim von Kienitz Newbie Sun, 02 Aug 2026 22:53:09 +0000 https://forums.mysql.com/read.php?10,741897,741897#msg-741897 https://forums.mysql.com/read.php?10,741897,741897#msg-741897
I'm storing GoHighLevel webhook data in MySQL for reporting and automation. What's the best database structure for handling contacts, opportunities, and custom fields efficiently?

Would love to hear your recommendations.]]> Funnelsflex Team Newbie Wed, 24 Jun 2026 09:35:38 +0000 https://forums.mysql.com/read.php?10,741865,741865#msg-741865 https://forums.mysql.com/read.php?10,741865,741865#msg-741865
Each image goes through multiple stages:
- Uploaded
- Queued
- Processed
- Completed

I'm curious how others design MySQL tables for this type of workflow.

Do you use separate tables for jobs and results, or a single table with status columns?]]> Moez Cherif Newbie Tue, 23 Jun 2026 11:30:10 +0000 https://forums.mysql.com/read.php?10,741822,741822#msg-741822 https://forums.mysql.com/read.php?10,741822,741822#msg-741822
Is there anyway to query a MySQL server from en Windows client in PowerShell WITHOUT installing any software/driver on it ?

We wander if it is possible to execute a light PowerShell script from any client connected to the network, from a share, making some select and insert, but with no MySQL connector install.

Using "[void][system.reflection.Assembly]::LoadFrom" we got errors, and no cmdlets recognized.

One "dirty" way should use a mysql.exe from a share, but results are unusable.

Could it be possible to "load" MySQL libs or cmd "on the fly" with no install on the computer executing the powershell script ?

Regards,]]> Emmanuel BILLOT Newbie Tue, 05 May 2026 20:47:42 +0000 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 Tue, 05 May 2026 18:24:38 +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?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?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 Tue, 05 May 2026 18:46:02 +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?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?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?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?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 https://forums.mysql.com/read.php?10,741501,741501#msg-741501 https://forums.mysql.com/read.php?10,741501,741501#msg-741501
Database: myacct_dbname
Table: 1_users
Field: password

So I want to change the admin password for a site admin in the myacct_dbname database under the 1_users table. Any help is appreciated thank you.]]> Shirley Bowen Newbie Mon, 22 Dec 2025 07:19:48 +0000 https://forums.mysql.com/read.php?10,741497,741497#msg-741497 https://forums.mysql.com/read.php?10,741497,741497#msg-741497
I’m working on a small project that predicts school closures based on
weather conditions (snowfall, temperature, alerts).

The system collects:
- ZIP code
- Hourly weather metrics
- Probability scores (0–100)
- Timestamped updates

I’m unsure whether a single table with indexed ZIP codes is enough,
or if partitioning by state/date would be better for performance.

Any advice on schema design or indexing strategies would be appreciated.
Thanks!]]> USASnow DayCalculator Newbie Fri, 19 Dec 2025 10:31:27 +0000 https://forums.mysql.com/read.php?10,741460,741460#msg-741460 https://forums.mysql.com/read.php?10,741460,741460#msg-741460
Using a string search value with %...% works fine for most of the campaigns. But, searching for %World War I% also selects the records containing 'World War II'. Thus, I changed the search to use a REGEXP '\bWorld War I\b' but this returns zero records.

This is the code...

SELECT * FROM memorials
LEFT JOIN cemeteries ON cem_id = per_cemid
WHERE per_cemid = 134
AND (per_mil_inscription REGEXP '\bWorld War I\b'
OR per_mil_notes REGEXP '\bWorld War I\b')

The code doesn't work in my PHP code and doesn't work in a cPanel SQL query.

What am I doing wrong?

TIA for any assistance]]> James A Wilson Newbie Thu, 04 Dec 2025 17:54:26 +0000 https://forums.mysql.com/read.php?10,741456,741456#msg-741456 https://forums.mysql.com/read.php?10,741456,741456#msg-741456 Thank you]]> Panagiotis Adam Newbie Wed, 03 Dec 2025 16:56:43 +0000 https://forums.mysql.com/read.php?10,741446,741446#msg-741446 https://forums.mysql.com/read.php?10,741446,741446#msg-741446 Unfortunately, the workbench home screen as shown in the tutorial does not match the home screen on my workbench.
(I was hoping that I would be able to attach 2 jpg files to this to show the differences)
Can anyone help me with this rather annoying start?]]> Andrew Greenwood Newbie Sun, 30 Nov 2025 16:09:04 +0000 https://forums.mysql.com/read.php?10,741431,741431#msg-741431 https://forums.mysql.com/read.php?10,741431,741431#msg-741431
Im trying to edit my database that contains data from a tracker. I wish to delete the values for the odometer, but the value is in a column named `attributes` which contains mutiple data in each cell like below

{"operator":23410,"odometer":4.9654157716276E7,"io83":1265,"io87":51129600,"distance":3.28,"totalDistance":688005.33,"fuel":999873.5,"hours":61446060,"Sleep Mode":"Awake","Mobile Network":"o2","FMC Battery":"3.924","Car Battery":"15.027000000000001","Speed":12,"Fuel Tank (%)":25,"Engine RPM":727,"Total Fuel used (l)":126.5}

I've tried update but can't seem to select the value "odometer" in the column `attributes`

Any help appreciate]]> Adam Bateman Newbie Thu, 27 Nov 2025 13:30:27 +0000 https://forums.mysql.com/read.php?10,741402,741402#msg-741402 https://forums.mysql.com/read.php?10,741402,741402#msg-741402
Complete newbie to MySQL.

So I have installed MySQL 8.0.44 on RHEL 9

a mysql linux account is automatically created but has no shell enabled. So to switch to the mysql linux account I run

su - mysql --shell=/bin/bash

When trying to start mysqld as the mysql user I am prompted for the root password.

uid=27(mysql) gid=27(mysql) groups=27(mysql)
$ systemctl start mysqld
==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ====
Authentication is required to start 'mysqld.service'.
Authenticating as: root
Password:

I have been using OS root to stop and start mysqld but I want to move away from using the OS root user.

All mysql files and directories are owned by the mysql linux account.

So my questions are:

1. Should the mysql account have privileges to start/stop mysqld without prompting for root password?

2. What is best practice for the mysql linux account? is it ok for the user to have login permissions?

Many Thanks]]> Karl Champion Newbie Thu, 20 Nov 2025 09:59:48 +0000 https://forums.mysql.com/read.php?10,741388,741388#msg-741388 https://forums.mysql.com/read.php?10,741388,741388#msg-741388 mysql=8.0.xx
MysqlI Support = enabled
Client API library version = mysqlnd 8.3.27

Getting back into php/mysql after 2 decades with cf/sqlserver.

database connecting, selecting, ordering is fine

Display error when I want to draw a table of first/last names

display code fails at this line

while($row = $result->mysqli_fetch_assoc())


Fatal error: Uncaught Error: Call to a member function mysqli_fetch_assoc() on string in.....

Been on google for hours. Now here. :(

Thanks]]> M. Masters Newbie Thu, 26 Feb 2026 18:50:17 +0000 https://forums.mysql.com/read.php?10,741386,741386#msg-741386 https://forums.mysql.com/read.php?10,741386,741386#msg-741386
Has anyone here experimented with combining AI tools (like SchriftGenerators for custom fonts) with MySQL to create dynamic, visually styled content? Any tips on storing font styles, handling text formatting, or best practices for database design in this context would be greatly appreciated.

Thanks!]]> Ddavid Lee Newbie Mon, 06 Jul 2026 12:08:51 +0000 https://forums.mysql.com/read.php?10,741382,741382#msg-741382 https://forums.mysql.com/read.php?10,741382,741382#msg-741382
I started a topic in the german forum two days ago and two days later it was still not approved.

Oracle, is this forum dead?

Best regards
raZe]]> Ramon Dohle Newbie Fri, 28 Nov 2025 19:19:55 +0000 https://forums.mysql.com/read.php?10,741377,741377#msg-741377 https://forums.mysql.com/read.php?10,741377,741377#msg-741377
Normally for analyzing the long running queries or associated performance issues , its advisable to set parameters like "slow_query_log" in mysql database or "log_min_duration_statement" in postgres. And with this all the queries running beyond certain duration will gets logged into the database log.

In case of cloud databases like aws aurora mysql/postgres which eventually pushed the logs to cloudwatch. And then on top of that cloudwatch logs, we can do alerting or do the analysis in case of any performance issues.

However, I wanted to understand how things work in case of some organizations which deals with PI or PCI data like say for e.g. financial institutions. As because in these cases there happens to be some sensitive information exposed in the cloudwatch logs which may be embeded as part of the literals in the sql query text. So how should one cater to this requirement?

Basically wants to have these logging features enabled at the same time not breaking the regulatory requirement of "not exposing any sensitive information inadvertently" ? As because we may not have full control on what people embeded in the sql text in a large organization with 100's of developer and support guys running queries in the database 24/7.]]> Jasper Callahan Newbie Wed, 25 Feb 2026 12:41:46 +0000 https://forums.mysql.com/read.php?10,741292,741292#msg-741292 https://forums.mysql.com/read.php?10,741292,741292#msg-741292
We are using aurora mysql database.

Is there any dowsnide of enabling slow_query_log in mysql in production? and also to what value we should be setting it to be in safe side without impacting any other?]]> Sheryl Carlson Newbie Fri, 28 Nov 2025 19:12:12 +0000 https://forums.mysql.com/read.php?10,741285,741285#msg-741285 https://forums.mysql.com/read.php?10,741285,741285#msg-741285
Oracle said they are focusing on HeatWave and AI within OCI but what about us that use MySQL for few decades? I know there are MariaDB and that Percona have their fork too but both are heavily dependent on the Oracle work. If Oracle is scrapping MySQL - what is the best course of action now? Should we look at alternatives immediately or should we hope someone will pick up all the riffed engineers and continue the work (e.g. Meta as one of the biggest users or Amazon that already have a big team working on MySQL source) and we hope they will share it with rest of us? Problem is we already know Amazon is not sharing their work.]]> Sheryl Carlson Newbie Thu, 26 Feb 2026 19:01:25 +0000 https://forums.mysql.com/read.php?10,741284,741284#msg-741284 https://forums.mysql.com/read.php?10,741284,741284#msg-741284
I’ve been working on improving the performance of MySQL databases used in high-traffic web applications. While exploring different caching and query optimization techniques, I found some helpful tools and tutorials that really boosted my understanding.

For example, using query indexing, JOIN optimization, and connection pooling helped reduce response times significantly.

I also write about MySQL-related automation, AI integrations, and backend optimization on my personal tech blog — you can check it here:
👉 Learn more about MySQL optimization here

Would love to hear your tips too —

What’s your favorite method for caching or reducing query load?

Do you prefer MyISAM or InnoDB for large-scale systems?

Thanks in advance for sharing your insights! 🙌]]> Edward James Newbie Thu, 09 Oct 2025 11:33:21 +0000 https://forums.mysql.com/read.php?10,741259,741259#msg-741259 https://forums.mysql.com/read.php?10,741259,741259#msg-741259 dpkg -i mysql-apt-config_0.8.34-1_all.deb
Which launches the installer, but initially, as it didn't have a Trixie option listed, I selected the Abort option so I could research what to do. Now I know I can use the Bookworm option (with a manual install of libaio1), I am re-running the above, but on the second time of running exactly the same command as above, nothing happens!

dpkg -i mysql-apt-config_0.8.34-1_all.deb
(Reading database ... 34911 files and directories currently installed.)
Preparing to unpack mysql-apt-config_0.8.34-1_all.deb ...
Unpacking mysql-apt-config (0.8.34-1) over (0.8.34-1) ...
Setting up mysql-apt-config (0.8.34-1) ...

And then I am returned to the prompt?!

How do IRunn run the installer a second time so I can continue?]]> Alan Ingram Newbie Fri, 03 Oct 2025 23:16:17 +0000 https://forums.mysql.com/read.php?10,741246,741246#msg-741246 https://forums.mysql.com/read.php?10,741246,741246#msg-741246 Pearl Goodwin Newbie Fri, 26 Sep 2025 08:29:40 +0000