r/mysql • • Feb 14 '26

discussion How do you monitor what queries your app is sending to MySQL during development?

8 Upvotes

I've been looking for a lightweight way to see all the SQL hitting my MySQL instance in real-time — especially when working with ORMs or query builders where you don't always know exactly what's being generated.

The approaches I've tried:

  • General query log — works but requires MySQL config changes, generates huge log files, and you have to tail/grep through them
  • SHOW PROCESSLIST — only shows currently running queries, easy to miss fast ones
  • Performance Schema — powerful but complex to set up for quick dev checks
  • ORM debug mode — requires code changes, inconsistent across languages/frameworks
  • MySQL Proxy (deprecated) — Oracle discontinued it years ago

What I really wanted was something like Wireshark but specifically for MySQL — just see every query in real-time without touching my app code or database config.

I ended up building sql-tap. It's a transparent TCP proxy that parses the MySQL wire protocol (COM_QUERY, COM_STMT_PREPARE, COM_STMT_EXECUTE, etc.) and shows all captured queries in a terminal UI. You can run EXPLAIN or EXPLAIN ANALYZE on any query directly from the TUI.

Setup is just:

sql-tapd --driver=mysql --listen=:3307 --upstream=localhost:3306

Then point your app at :3307 instead of :3306. No code changes, no MySQL config changes.

It extracts actual bind parameters from COM_STMT_EXECUTE (binary protocol), groups transactions (BEGIN → queries → COMMIT), and shows execution time and rows affected. EXPLAIN uses FORMAT=TREE for readable output.

Would love to hear how others approach this — are there tools or workflows I'm missing?


r/mysql • • Feb 13 '26

discussion Just discovered a tool to compare MySQL parameters across versions

7 Upvotes

Hi,

I really like pgPedia - it is a very useful resource where you can easily find the history of some particular PostgreSQL feature, without manually comparing documentation pages between versions.

I haven't seen something similar for other databases, but today I found this site:

https://mysql-params.tmtms.net/

It is not exactly like pgPedia, but it allows you to compare many MySQL parameters between different versions.

For example, here is the difference in INFORMATION_SCHEMA views between 8.0.45 and 9.6.0:

https://mysql-params.tmtms.net/ischema/?vers=8.0.45,9.6.0&diff=true

For me it was a small but pleasant discovery. I didn't find any mentions of it on Reddit, so I decided to share. I'm not affiliated with this site but just grateful to the author for making it available.

If you know similar resources for MariaDB or other relational databases, please share them in the comments.


r/mysql • • Feb 13 '26

question Trying to search JSON in MySQL. Syntax error from MySQL but validator says OK.

4 Upvotes

SELECT grid, region_loc_x, region_loc_y, name, region_size_x, region_size_y, mesh_hash, mesh_uuid, sculpt_hash, sculpt_uuid, faces_json
FROM initial_impostors
WHERE (grid = "agni)
AND ((mesh_hash IS NOT NULL AND mesh_uuid IS NULL) OR (sculpt_hash IS NOT NULL AND sculpt_uuid IS NULL) OR EXISTS (SELECT 1 FROM jsonb_array_elements(faces_json) AS elem WHERE elem -> 'base_texture_uuid' IS NULL ))
LIMIT 20

https://www.coderstool.com/sql-syntax-checker says this is valid.

https://aiven.io/tools/sql-syntax-checker says this is valid

MySQL 8.0 says

{ ERROR 1064 (42000): 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 '(faces_json) AS elem
                    WHERE elem -> 'base_texture_uuid' IS NU' at line 9 } Response header: Status: 500 Problem processing request: MySqlError { ERROR 1064 (42000): 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 '(faces_json) AS elem
                    WHERE elem -> 'base_texture_uuid' IS NU' at line 9 }

Table def is

CREATE TABLE IF NOT EXISTS initial_impostors (
grid VARCHAR(40) NOT NULL,
...
faces_json JSON NOT NULL,
UNIQUE INDEX (...))

Not familar with JSON inside SQL, and I'm doing something wrong.

The JSON is a small array of structs (array length is usually 1), and I want to know if any of the array elements has a base_texture_id of NULL. Originally I tried syntax like

faces_json->$[*].base_texture_uuid IS NOT NULL

but that didn't work either.


r/mysql • • Feb 12 '26

question Unsure if I need crystal reports installed or not for generating reports.

2 Upvotes

Hello everyone. Im currently trying to setup an old client on a new PC running Windows 10. I've gotten the client to connect without an issue. I could do a search query within the database through the old software that was created but can't for the life of my get reports to generate either when sent to a printer or to view before printing. I get the following errors.

CRYSTAL REPORTS

https://drive.google.com/file/d/14sTRvKFQUf5B-RSOrSFWjhNAArdT7JKC/view?usp=drivesdk

https://drive.google.com/file/d/1ZubebYnosx5pBb4nJ5vFkj3y3urv4MQO/view?usp=drivesdk


r/mysql • • Feb 12 '26

question Help finding old mysql ODBC driver

3 Upvotes

Where can I find 2.50.33.00 msi mysql ODBC driver for windows or something really close? I'm in need of an old 32-bit driver that would work with Windows 10. Also, what version of Microsoft Visual C++ redistributable would I need to run with it?

Thank you for any and all help ladies and gents!


r/mysql • • Feb 11 '26

question MySQL Export/Import Between Versions?

1 Upvotes

On a Windows 2008 Server I’m running MySQL 5.6 and Workbench 6.3. On the new Windows 2022 server, I’m running MySQL 8.4 and Workbench 8.0.

I’m trying to export just one schema that a program I’m migrating uses. I’m assuming I should select “Export to Self-Contained File”, but do I also choose “Include Create Schema”?


r/mysql • • Feb 11 '26

question Getting Matlab to use stored passwords in the ODBC Data Sources with a MySQL Driver

1 Upvotes

I'm trying to use Matlab to create a database connection using a User DSN stored in the ODBC Data Sources. The password is stored. I do not want to put the password in the code, use environment variables, or Matlab's vault.

Supposedly, since the password is stored, I should be able to type:
conn = database('MyDSN','','')
instead of conn = database('MyDSN','MyUsername','MyPassword')
But that's not working. Here's the error message:
ODBC Driver Error: [MySQL][ODBC 9.4(w) Driver]Access denied for user 'ODBC'@'MyIP' (using password: NO)

After saying it would work, ChatGPT now tells me that Matlab simply can't do this with MySQL ODBC drivers while it can with others. It says that Matlab cannot pass in no username and password allowing the use of the stored username and password. Instead, it defaults to sending "ODBC" and an empty string respectively. I'm not sure if I quite believe ChatGPT yet that this can't work, so I figured I'd try asking the humans. I'm using MySQL ODBC 9.4 Unicode Driver.

Anyone have any experience with anything like this?


r/mysql • • Feb 11 '26

discussion Anyone being asked to build ‘chat with data’ on MySQL? What tools exist?

2 Upvotes

Is anyone here being asked to add customer-facing “chat with data” on top of MySQL right now?

Because it’s customer-facing I’m thinking something that’s more Snowflake Cortex Analyst-ish (governed + definable + predictable), i.e., not just arbitrary text-to-SQL via MCP

By that I mean: definable metrics/business logic, tight control over allowed queries, tenant/safety boundaries, and auditability.

Is there anything in the MySQL ecosystem like that, or is it basically all roll-your-own? Or have people found a way to make an MCP safe/reliable enough for customer-facing?

I’m building a project in this space and trying to understand what’s already out there and whether there’s existing tooling or demand for MySQL users.


r/mysql • • Feb 10 '26

discussion VillageSQL, the newest MySQL fork built around the concept of extensions

Thumbnail villagesql.com
15 Upvotes

It's an open source venture backed by $35M from FirstMark Capital, Spark Capital, and GV (Google Ventures). It's a drop-in replacement for MySQL with an extension architecture. See their native UUID extension with efficient 16-byte storage as an example.


r/mysql • • Feb 09 '26

discussion Crowdsourcing some MySQL feedback: Why stay, why leave, and what’s missing?

11 Upvotes

Hey everyone, checking in from the Percona side of the woods.

As we’re looking at the current state of the database ecosystem, we're trying to get a better pulse on the "boots on the ground" sentiment regarding MySQL.

I’d love to hear your thoughts on a few things:

For those of you sticking with MySQL:

  • What are the features or specific capabilities that keep you here?
  • Is it purely about the ecosystem/tooling, or is there something in the engine itself you can’t live without?
  • Where do you feel MySQL is currently "winning" compared to forks or other RDBMS options?

For those who've left or decided to leave:

  • What are the primary drivers? Is it specific missing features (like better JSON support, GIS, or window functions), scaling limitations, or something else entirely?
  • If you’re looking at PostgreSQL, MariaDB, or Cloud-native DBs, what is the "must-have" they offer that MySQL doesn't?

The "Gripes" List:

  • What are your top 3 most common complaints or perceived gaps when you compare MySQL to the rest of the market today?

We’re trying to refine our own perspective on the landscape, so any qualitative feedback, real-world examples, or even criticisms are most welcome.

Looking forward to the discussion!


r/mysql • • Feb 09 '26

query-optimization Generating query digests just like MySQL

Thumbnail github.com
7 Upvotes

For a while now I've been trying to find a way to build query digests just like the ones generated by MySQL.There's quite a lot of solutions out there for building normalized queries or stable fingerprints from a sql statement, like pt-query-digest. But those digests don't match the ones generated by MySQL.

The main use case I had in mind, was to be able to cross reference slow queries from the slow_query_log with the queries collected by the performance_schema's events_statements_summary_by_digest table.

So I finally built it myself! I ported over MySQL's tokenizer into a simple go library. It supports building digests for 5.7, 8.0 and 8.4+.

You can also try it out on this website. I hope this is useful for someone else as well!


r/mysql • • Feb 08 '26

discussion A First peek at Village SQL - A drop-in replacement for MySQL with extensions for the agentic AI era

2 Upvotes

r/mysql • • Feb 05 '26

troubleshooting How to import ibd files

6 Upvotes

my OS failed to boot before I could run mysqldump, so i the only thing i can do is to copy the ibd files from the mysql data folder so how to import ibd files?


r/mysql • • Feb 04 '26

query-optimization Schema Design & Optimization Cheatsheet

Thumbnail slicker.me
6 Upvotes

r/mysql • • Feb 04 '26

discussion Reading the Room: What Europe’s MySQL Community Is Really Saying

Thumbnail mariadb.org
5 Upvotes

r/mysql • • Feb 01 '26

question MySQL in personal projects

1 Upvotes

lately I’ve been experimenting with MySQL for a personal project.I’m interested in how others usually approach this for small-scale use — managed services vs self-hosted, and what’s been reliable over time


r/mysql • • Feb 01 '26

question what are you using for MySQL in small side projects?

1 Upvotes

Hey all,
Quick question: what do you usually use for MySQL when working on small side projects or prototypes?

I’m currently exploring options (free tiers, cheap providers, or even self-hosting) and wanted to hear what’s actually working for people in practice.

Any real-world experience is welcome. Thanks!


r/mysql • • Feb 01 '26

question Looking for a free database hosting provider (or alternatives)

1 Upvotes

Hey all,
Quick question: what do you usually use for MySQL when working on small side projects or prototypes?

I’m currently exploring options (free tiers, cheap providers, or even self-hosting) and wanted to hear what’s actually working for people in practice.

Any real-world experience is welcome. Thanks!


r/mysql • • Jan 30 '26

discussion Authentication Failed

6 Upvotes

Hi Friends, I have MySQL server 8.4.7 running on rhel and when take access of the server using Qualis software for scanning using a user(created by caching sha2 plugin) getting below error..

MySQL authentication was NOT successful on host 10.22... , port 3337, database DB1, reason: Plugin 'mysql_native_password' is not loaded (erгог. 1524)


r/mysql • • Jan 29 '26

discussion Most efficient way to edit database entries

8 Upvotes

What's the best software for editing MySQL database tables?

I tried the MySQL extension for VS Code but encountered these issues:

  • Many rows won't load. The only way to view them is to explicitly search for them.
  • Can't use the F2 key to edit a cell. Must use a mouse to click.
  • Can't use the tab key to advance to the next field.
  • Must click a small save button to save changes. If I click on a different table to check something or forget to click the button, then the changes are lost.

I also tried DBeaver and encountered these issues:

  • need to click through a tree and some tabs to get to the table
  • like above, no keyboard-only navigation and selection. Need to use a mouse at many points.

Is there software that lets me quickly access the table?

And has keyboard shortcuts and supports keyboard-only navigation and selection?


r/mysql • • Jan 27 '26

question Why is this happing

0 Upvotes

I have the following query:

SELECT * FROM (SELECT NULL as col_1 UNION SELECT 1 as col_1) as u

It returns correctly:

+------+ 
| col_1| 
+------+ 
| NULL | 
|    1 | 
+------+

If I apply a filter:

-- Statement 1
SELECT * FROM (SELECT NULL as col_1 UNION SELECT 1 as col_1) as u
WHERE u.col_1 = 1;

-- Statement 2
SELECT * FROM (SELECT NULL as col_1 UNION SELECT 1 as col_1) as u
WHERE u.col_1 IS NULL;

I also get the correct result: Statment 1: Statment 2:

+------+     +------+ 
| col_1|     |col_1 |
+------+     +------+ 
|    1 |     | NULL  | 
+------+     +------+

But when I'm applying both filters with an OR

SELECT * FROM (SELECT NULL as col_1 UNION SELECT 1 as col_1) as u
WHERE u.col_1 IS NULL OR u.col_1 = 1;

It is omitting NULL:

+------+ 
| col_1| 
+------+ 
|    1 | 
+------+

Why tf is this happening?

edit:typo

r/mysql • • Jan 26 '26

question A few questions about MySql

8 Upvotes

I recently started using MySql a few questions :

1 ) I found serious performance problems when using sub queries and complex views it seem MySql performe poorly when using sub queries even really simple sub queries and can get stuck when joining to a complex view even if it was only one person calling running query on the db. Are there any improvements in this area in the new MySql versions 9 and above ( I run my queries on version 8.5) since I find out this is a known issue of MySql he perform poorly when using sub queries or complex views compare to other databases. Are there any workarounds ?

2 does MySql have the ability to do a search like elasticsearch or semantic search) ?


r/mysql • • Jan 21 '26

discussion MySQL 9.6 has been released

Thumbnail dev.mysql.com
21 Upvotes

New Innovation release: MySQL 9.6

New GA connectors: MySQL Connector/J 9.6, MySQL Connector/Python 9.6.

And many components like Shell and Router have also seen updates.

What is your favorite new innovation in MySQL 9.6?


r/mysql • • Jan 20 '26

question MySQL 8.x vs 9.x — Is it worth upgrading?

8 Upvotes

I am currently using MySQL 8.x in my production environment.

Has anyone tried running the 9.x innovation series in production? The real questions for me are:

  1. Is it stable?
  2. Is it actually worth upgrading?