mysql 大字段影响

CREATE TABLE articles (
    id INT PRIMARY KEY,
    title VARCHAR(255),
    content TEXT
);

CREATE TABLE article_content (
    id INT PRIMARY KEY,
    article_id INT,
    content TEXT,
    FOREIGN KEY (article_id) REFERENCES articles(id)
);

-- 不对content字段建立索引

import redis
import mysql.connector

# 连接Redis
redis_client = redis.Redis(host='localhost', port=6379, db=0)

# 连接MySQL
mysql_conn = mysql.connector.connect(user='user', password='password', host='localhost', database='database')
mysql_cursor = mysql_conn.cursor()

def get_article_content(article_id):
    # 先从Redis缓存中获取数据
    content = redis_client.get(f'article:{article_id}')
    if content is not None:
        return content.decode('utf-8')
    
    # 如果缓存中没有数据，从MySQL中获取
    mysql_cursor.execute("SELECT content FROM articles WHERE id = %s", (article_id,))
    result = mysql_cursor.fetchone()
    if result is not None:
        content = result[0]
        # 将数据存入Redis缓存
        redis_client.set(f'article:{article_id}', content)
        return content
    
    return None