×

Loading...
Ad by
  • 推荐 OXIO 加拿大高速网络,最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务
Ad by
  • 推荐 OXIO 加拿大高速网络,最低月费仅$40. 使用推荐码 RCR37MB 可获得一个月的免费服务

Here is the table cache issue with MYSQL fail to perform queries. (seems like what you got now) Hope could be any help. Actually, a database size of 3 G is not big deal. Unless single table size > 2 G, on Suse....

if Large file support was enabled, single table size could be at lease 4G.
Report

Replies, comments and Discussions:

  • 工作学习 / IT技术讨论 / mysql 问题,database 有没有内存的限制?我的好像出了问题,存储的数据太多,不能CREATE TABLE 也不能DROP TABLE,死在那里没有反应
    • if table size is too large, on windows, default is 2g. if not, there is a config to increate the table cache size. but it seems not the case. 2 cents
      • Thanks, you are right on the size issue. The database I am trying to load is > 3 GB :-) How do I change the config to increase table cache size ? I am using Suse Linux, and mysql 4.0.
        • Here is the table cache issue with MYSQL fail to perform queries. (seems like what you got now) Hope could be any help. Actually, a database size of 3 G is not big deal. Unless single table size > 2 G, on Suse....
          if Large file support was enabled, single table size could be at lease 4G.
    • 看LOG FILE是不是满了