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....
lubx(黑白世界*大漠孤烟)
if Large file support was enabled, single table size could be at lease 4G.
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
-lubx(黑白世界*大漠孤烟);
2005-4-7(#2227165@0)
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.
-sdyxz(sdyxz);
2005-4-11(#2234039@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....
-lubx(黑白世界*大漠孤烟);
2005-4-11{75}(#2234965@0)
if Large file support was enabled, single table size could be at lease 4G.