Changing column from longtext to mediumtext taking over 2 hours

This page summarizes the projects mentioned and recommended in the original post on /r/mysql

InfluxDB - Power Real-Time Data Analytics at Scale
Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
www.influxdata.com
featured
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com
featured
  • gh-ost

    GitHub's Online Schema-migration Tool for MySQL

    Not sure which version of MySQL you're using, but one approach would be to use a tool like pt-online-schema-change (from Percona) or g-host -- which will create a duplicate table and then swap it in place of the original table. It's a safer approach when operating in production environments. Here's a good comparison of the tools many people use https://planetscale.com/docs/learn/online-schema-change-tools-comparison

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
  • mig

    Your own MySQL guru to deal with indexes in a friendly way. (by Gonlo2)

    On the other hand I do not know if reducing the column size is going to improve the performance of the queries, for experience I comment you that normally the problem is that a good index is not defined so check if you use some fulltext or btree index. If you can use a btree and the query is simple, maybe you can use this tool that I made to recommend an index from a query https://github.com/Gonlo2/mig

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts

  • Features I wish PostgreSQL had as a developer

    1 project | news.ycombinator.com | 5 Apr 2024
  • "At GitHub we do not use foreign keys, ever, anywhere"

    1 project | news.ycombinator.com | 22 Jan 2024
  • How Meta Built the Infrastructure for Threads

    1 project | news.ycombinator.com | 8 Jan 2024
  • How Modern SQL Databases Are Changing Web Development - #3 Better Developer Experience

    4 projects | dev.to | 8 Dec 2023
  • Automagically generate migrations for GORM

    1 project | /r/golang | 29 Jun 2023

Did you konow that Go is
the 4th most popular programming language
based on number of metions?