Tables that have rows more than 100M in numbers may have a performance degradation on queries, especially when the queries must join multiple tables, which… Read More »How to Accelerate Queries on Big Tables
When we partitioned a table by a timestamp-typed column "order_time" in table "orders", it generated an error 1486 like this:mysql> ALTER TABLE orders PARTITION BY… Read More »How to Resolve ERROR 1486 (HY000) in MySQL