I recently upgraded to MySQL 8.4, and I just noticed my C drive is almost full. After looking into it, I realized that MySQL has been creating a bunch of files called “binlog.XXXXXX” where XXXXXX is a random number (it appears). The files are stored in C:/PrograData/MySQL/MySQL Server 8.4/Data.

I recently upgraded to MySQL 8.4, and I just noticed my C drive is almost full. After looking into it, I realized that MySQL has been creating a bunch of files called “binlog.XXXXXX” where XXXXXX is a random number (it appears). The files are stored in C:/PrograData/MySQL/MySQL Server 8.4/Data.

I am using MySQL 8 innoDB.

This could be handled outside of the query but in an ideal world I would like to change this result:
|share_id|email|ip_address|column_a|column_b|column_c|column_d|
|——–|—————|———-|—–|———|—————-|————|
|’4’|'[email protected]’|”|2|3|3|2|
|’4’|'[email protected]’|’127.0.0.1’|1|3|2|1|

The database version is 8

Note: I did look up other answers, but they all seem to be for MySQL 5.x. MySQL 8 has made huge strides in ease of altering tables so I am looking for mySQL 8 specific answers.