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…
We are upgrading MySQL from 5.7 to 8.0. Table cuatom_shapes has column shape with SRID=0, in which few rows have data with GEOMETRYCOLLECTION and few other rows have data with POLYGON. Though column SRID is set to 0, for POLYGON…
I am trying to use covering index (with a functional index) in MySQL 8.0.28 to speed up a group by query on a large InnoDB table. Covering index created: ALTER TABLE `sp_files` ADD INDEX `ix_site_header_to_cleaned_text2` (`sp_site_foreign_key`, (length(`cleaned_text`))); Using only the…
Apparently, sorting is somehow applied incorrectly in mysql 8 (checked on 8.0.33 to 8.0.35) when query has ORDER BY + GROUP BY + GROUP_CONCAT() + COUNT(*) OVER() window function. See test case below (NOTE that it's synthetic and oversimplified for…
I have an application that runs on PHP 5.6 and Laravel 5.2. It's hosted in AWS on an AWS Linux 1 EC2 machine. This web server connects to a RDS MySQL instance. The RDS instance has been running MySQL 5.7…
SELECT e.frist_name, SUM(e.prince), YEAR(e.hire_date) AS year FROM ( SELECT * FROM employee WHERE termination IS NULL ) e JOIN storage s ON e.id = s.eid GROUP BY e.id, e.hire_date; After SQL query I have a table like this: +--------------+---------------+------+ |…
I have the following query: SELECT match_main.checked, match_main.match_main_id, match_main.updated, match_main.created FROM match_main LEFT JOIN match_team AS mt1 ON mt1.match_main_id = match_main.match_main_id AND mt1.team_number = 1 AND mt1.version_number = 0 LEFT JOIN match_team AS mt2 ON mt2.match_main_id = match_main.match_main_id AND mt2.team_number…
I'm having troubles with my MySql server. It's used mainly for storing production logs, but unfortunately it seems like it it too slow and i dont know if there is something i could do to improve it.Sometimes there is even…
I current use the numpy roots function as follows: y = numpy.roots([-2, 3, 0, -1 * x])[1] In the above x is a column in a table that I extract to run through the function. If possible I'd like to…
I'm not able to quite figure out how to capture the changes over time. I have the following: db<>fiddle CREATE TABLE term_changes (load_id int, merchant_id int, load_date date, terms varchar(50)); INSERT INTO term_changes (load_id, merchant_id, load_date, terms) VALUES (1, 1,…