14,953
edits
Troubleshooting of MySQL errors: Difference between revisions
Jump to navigation
Jump to search
→SQL and Query Errors
(→Connection and Network Errors: Can't assign requested address) |
|||
| Line 327: | Line 327: | ||
SET SQL_MODE='ALLOW_INVALID_DATES'; | SET SQL_MODE='ALLOW_INVALID_DATES'; | ||
</pre> | </pre> | ||
=== Optimization Solutions for Query Performance === | |||
Originally, product_id (VARCHAR, 200) was used as the primary key. When the data volume reached approximately 600,000, data processing became very slow. Adding a field id (int) as the primary key can solve the problem of slow query speed. | |||
== Connection and Network Errors == | == Connection and Network Errors == | ||